limit of fields
Hello the world is there a maximum quantity of field per form? because i can't add a new radio, the field is "adding" forever only the checkbox is adding well is that normal? thank you
Startup form
Hi! I was wondering if there is a way to change the first item that opens when accessing my application. Currently when I access my application for the first time of the day, I am taken to the first form I created. This is the main entry form but I have built a dashboard and would like that to be the first thing seen when accessing. Thanks in advance.
Confirm submission option for stateful and stateless buttons
Changes to data that have large consequences should have 2-factor confirmation. It would be useful to have the option to enable a 'Confirm Change' for buttons in both stateful and stateless forms. The button editor could have a toggle to turn confirmation on/off along with a text box to configure a custom message that would display in the modal confirmation dialog presented to the end user. The modal dialog would have 2 buttons: OK and Cancel.
Auto populate
If we have a "Start" Date/Time Field, how can I auto populate the "Finish" Date/Time Field on entry of the "Start" Date/Time Field in the same form as a default value to allow me to then edit the "Finish" Date/Time Field?
Add amount every time form is submitted
Hi! I have a report of contractors and I also have a form to record each time I pay them. I would like to see the total amount paid on the contractors report. Below is the Pay_Contractors form And this is the report of another form called Contractors I would like to see the total amount paid for each contractor. How do I accomplish this?
Adding line breaks in Chrome, Firefox, IE, Safari with Rich-Text troubles
Dear ZOHO, The Rich-Text fields gives me a lot of trouble. When I try to use the data of these fields, it depends on the browser whether or not line breaks <br> or </ br> are added to the field. This makes it currently undo able to use the content of this field in html-page views and the like. It seems that depending on the browser, creator adds <br> and/or <DIV> elements to the field or not. Chrome adds <DIV>, Firefox and Safari do not. I cannot tell what IE does because it will not show the RichText
Simple way to track rent received from tenants
Hello, First off, I'm totally new to databases, forms and the terminology so please bear with me. I manage a property with 50 tenants. I'm trying to create a way to have a list of current tenants that includes name, site number, monthly rent amount, and what they are paying for. I then need to be able to track the date we received their rent, amount received, payment form (check, cash, credit) and their rent paid through date. Some people pay multiple months in advance. Then ultimately an easy
How do you make a custom theme in Zoho Creator?
I've tried to look up how to make a custom theme in Zoho Creator, but all the answers I'm finding are for the old layout. It says that the "custom theme" button is under settings > customisation, but I do not see it. How do I make a custom theme in the new layout? Thanks in advance.
How do I parse JSON to use variable? toMap and getJSON are confusing...
Hey Everyone! I would love some help with this. I'm stuck. I have the following JSON. { "result":[ { "bearing":-1, "currentStateDuration":"00:53:14", "exceptionEvents":[ ], "isDeviceCommunicating":true, "isDriving":false, "latitude":34.9946861, "longitude":-106.659889, "speed":0.0, "dateTime":"2017-03-02T19:31:44.000Z", "device":{ "id":"b1" }, "driver":"UnknownDriverId",
Pass dates to OpenURL
I am trying to create a stateless form that has two fields a Start Date and an End Date. The idea is to pass these dates to the OpenURL and generate a report based that includes all the dates between Start Date and End date. but when I follow the example on the functionality based URL's, my report does not filter the unwanted records out. openUrl("https://app.zohocreator.com/notjustanothername/order-management#Report:ALLORDERS?Order_Date=input.Start_Date;input.End_Date&Order_Date_op=58","same window");
Need help with rule criteria for checkbox
I need help with a rule creation. I have a check box field for yes/no. I then have another field that I want displayed if the check box for yes is checked. I understand that the criteria has to be set as true for yes. but I'm having trouble seeing where and how to set that. Under the criteria section I have selected the field name, but under the operator menu I see the choices as EQUALS NOT EQUAL TO STARTS WITH ENDS WITH CONTAINS DOES NOT CONTAIN How do I set the criteria for a TRUE or FALSE? And
Rich text fields in Subforms
Hello. When I create a field in a subform, I get the following type options: As you can see, Rich text doesn't appear as an option. Is there an alternative way to use Rich text fields in a subform? Thanks in advance.
What does it mean "Error at line 0"?
Here is the function that I wrote: map externalapps.GetCurrentSymptoms() { symptomMap = map(); for each Symptom_ID in Symptoms [notContains(Symptom_Name,"Deprecated")] { symptomMap.put(input.Symptom_ID,input.Symptom_Name); } return symptomMap(); } When I try to save, it gives me this error: Error at line number : 0 Mismatch data type for function 'put' at argument index 2 expected data type STRING found data type SymptomsI don't really know how to debug this one? Symptom_ID
Display Image from Another Form.
Good Day, I created a form with an image and on my second form, when I select the product, I would like the image to display. Please advise. Thanks Safraz
Prevent duplicate item on same date
Hi! When I am adding a new record, I would like my dropdown menu (that is in the form) to grey-out the items that are already recorded on the same date as the field in my form. In other words, I would like to prevent an item being double-booked on the same date. How do I do this? I would like for the dropdown of "Facade" to grey out any other items that are being used on the same date. The date is in "Date of Event". I should also mention that "Facade" is a lookup field.
Google Drive function?
I've find this Google Drive function in deluge script... any news?
HI
even though i publish my website i cannot access my website :( it indicates that web site cannot be found (DNS PROBLEM )but the site publishes sucessfully
19-digit number replaces the original data in report column
Hi An error has shown up yesterday in a report. Instead of the proper data - in this case the name of the assigned caseworker ("sagsbehandler") a 19-digit number shows up. Same goes for the assigned consultant (konsulent-kontaktperson). When I group the colums by caserworker or consultant it will readily display the name but not when they are just data in a column. Please have a look at the attachments. I thank you very much in advance for your help. Best regards Thomas
Can't delete profiles
I have created an app and shared it but they can't log in. An error message pops up saying that they are logged in but they can't access the app. Your suggestion on the topics is to delete the profiles, "Deleting the roles and profiles for the user will solve the issue. Please click on the below link and follow the steps to delete the profile. https://www.zoho.com/creator/help/security/clone-profiles.html#Deleting_Profiles But there is no "X" to delete a profile and the edit is greyed out. I only
triple column
Hi Is it possible to create a triple column as it is possible to create a double column on the form of zoho creator? thank you
Customer Portal & Ipad App & other issues
I have a few questions about the customer portal We created a customer portal user, but: A. The customer can not log-in using the iPad app. Does a user of the customer portal not have use of the android and ipad creator apps? B. When they log-in the old version of zoho creator is what appears. What needs to be does to insure that the new ui appears when a user logs in through the customer portal?
to populate a subform based on a form
Hi, I have a form named "inventory" with product_name and quantity. I would like to have a new form named "inventory entry" with a subform that populate each product_name in order to fill the new quantity to add. How can I do it? Thanks, David
Free form Deluge code displayed differently than it is saved and executed. Subsequent edits cause errors.
First example: If I switch to Form Builder view and then back to workflow view, the line: lstAnswerChoices = recAssessment.subAnswerChoices.ID.getall();is changed to: lstAnswerChoices = recAssessment.subAnswerChoices.getall();If I then try to save without making any changes I get an error. Second example: If I save the following line and navigate back to the function, it is displayed without the first set of parenthesis which returns a completely different result: strDisplayName = (rec.rtfQuestion
Can I create an App to calculate Selling Prices?
I want to be able to calculate selling prices for Items in Zoho Books/Inventory, based on a number of factors including: - The buy price in currency - The Currency Type for a Vendor - The exchange rate - etc Can I create a Zoho App using Creator to do this, perhaps triggered by a custom button in Zoho Inventory? John Legg Owner: The Debug Store
Precreator.zoho.com unavailable anymore?
I remember being able to access https://precreator.zoho.com/ to get the latest features in beta for ZohoCreator. However this morning, the link is dead. What happened ?
Functions within a form (Form scope, not application scope)
Wondering if it's possible to create a reusable function with form scope only. It appears Creator only allows application scope functions. Form scope functions would make it easier to reuse code that is specific to the form and make for less lines of code and easier maintenance.
Show/Hide events on calendar view
Hi, I have a create_event form and it has 5 different types_of_events. How can I code such that the report can show or hide events pertaining to the type_of_event selected as a custom function? Thanks!
Is the zoho creator totally free by allowing multiple users in employee management application?
Is the zoho creator totally free by allowing multiple users in employee management application? please reply
Skip errors when inserting rows
I need to write a Deluge script to insert 10,000 rows into a form from another form. How do I skip error rows when "unique key" condition is not met, but continue with the other rows? Thanks. Also looking for a full Deluge training manual.
newline base64Encode bug when using very long strings
Hello, I have a bizarre bug to report using the base64Encode function. When trying to encode a very long string like this: tokenStr = "averyveryveryveryveryveryveryveryveryveryveryveryverylongusername:anotherveryveryveryverylongtokentypeofpassword"; auth = zoho.encryption.base64Encode(tokenStr);As you can see below, the result of the encoding includes a newline (which is invalid): YXZlcnl2ZXJ5dmVyeXZlcnl2ZXJ5dmVyeXZlcnl2ZXJ5dmVyeXZlcnl2ZXJ5dmVyeXZlcnlsb25n dXNlcm5hbWU6YW5vdGhlcnZlcnl2ZXJ5dmVyeXZlcnlsb25ndG9rZW50eXBlb2ZwYXNzd29yZA==
Change field name with "if" deluge script
Hi! I would like to change a field name with an "if" function in deluge. How do I do this?
Formula results in dialog box
Is there no way to have a formula and simply place the results into a "dialog box" on the report somewhere and give the results in that box? I do not want the results to be on every line for every record although the result is correct I simply want it in one place. Jerry
Zoho CRM Invoice from Creator
Hello I want to create entry in ZOHO CRM Invoices module from Creator form. Can any one know how can i add multiple products in Creator form and on submitting form, create Invoice entry in ZOHO CRM Invoice module?
Resolved - "Error modifying the page" when copying a Form to a different app via definition copy/paste
Thanks in advance... I'm trying to copy a form from one app to another (we created as a standalone app and now we want to move its objects to inside our main app instead. It only has 2 forms and a few reports.) Form is very simple. It is a simple "documents list", with 4 fields to name and describe the document, plus a File Upload field. In the target app: Created a blank form, using same form name. In the source app: Copied all code for the form "with action" (even though it has no actions). In
How to replace the value (not id) in a lookup field with data in a lookup field from a different form
Hi there, It's days that I am facing this problem, and hope someone can show some light on this. I am a newbie to Zoho Creator. I am trying to create a Job Card application through Zoho Creator so I have created so far a form named "Suppliers" where I can store all the details of the suppliers of machines we sell, in this form I have also created a subform called "Systems"where I store the different machines model name. Then I have created another form called "Machines" where I have implemented 2
Check for duplicates using two fields
Hi, I have a form where I enter different types of products for different countries. So the form has two fields: Country and Product. I would like to make sure that there is only one product entered (no duplicates) for each country. I can't simply set the product field to unique, as this would not allow me to have eg. 'beef' in both Italy and Spain. I there any way to have the system check whether a product already exists for a given country? thanks, Anne
Need to add more data in a form
I wanna to create employee database which is in 4 parts 1. Personal information 2. Education 3. Employee details 4. Other information. Every parts has many information to collect. it's nt gud way to create in single form. I need like Step 1, 2, 3..... The Employee has to enter the data in step wise. And also i need to store in single database tables. Pls suggest any idea.
A too long form
Hi everyone, I have a form which is very long and complex, i would like if possible to segment it into several forms. For example, based on the Conditional output of form A, the sister form : form B will be prefilled and/or precreated The forms should be in a certain manner be interconnected to each other's My problem is : 1 I don't know how to interconnect to Form 2 i don't want to create millions of records for the same implementation thank you
How can I visualize an image that I have in a report and be able to see it on a page html?
This is the image the the report contains. And this is how it appear in the page html. how can i do so that the same image apper to me in the report?
How to get data selected in subform onSuccess
Hey, I'm trying to get the products and quantity selected in a subform and put them in a map. Here are my forms: Form 1: OrderForm: Fields: 1.Name (Single_Field) 2. Products (Subform - Form 2) Form 2: ProductsForm Fields: 1.Product Name (Dropdown Lookup Field to Form 3) 2.Quantity (Single_Field) Form 3: Items (Here is where I insert the products into the system, the user is not able to see this form) Fields: 1.Item Name (Single_Field) On submit in the OrderForm, I want
Next Page