Autonumber subform rows through deluge script
Hi all, Ive been trying to create a numbering system for each new subform row added. The problem ive come to is on add row, it doesnt show show the value Im trying to display Here is the code ive tried: on Add row: linecount = 1; for each item in Items_Ordered { //This will autonumber each new line added in items ordered items.Line_Number = linecount; linecount = (linecount + 1); } The output I'm looking for is to have each new row added contain a row number, starting at 1 and increasing
Is it best practice to use the exact same if statement in two different places?
I'm using the following if statement: // Display Writer Rate field if Position contains "Writer" and Type is "Freelancer"; hide otherwise. hide Writer_Rate; if ((input.Type == "Freelancer") && input.Position_s.contains("Writer")) { show Writer_Rate; } I've included this statement within the On User Input section of two different fields: Position and Type. Is that best practice? It feels messy to me (e.g. if you wanted to amend the if statement, you'd need to remember to do it in the two different
How to hide/show a section in Zoho creator 5?
Ho can I hide/show an entire section in Zoho creator 5. I searched for the solution but every says go to Application Settings<Sections. But I don't find sections page in settings. Here's how my section page looks.
Possible to Filter a Zoho CRM Lookup Field
Is it possible to filter a CRM lookup field onload? If not possible, is their a good workaround? I'm basically trying to pull all cases with status of "New" from the CRM so a user can select one for updating. We have about 5000 cases but only ever have
How to update conditional dropdown in a deluge script?
I have a conditional dropdown in my forms (Single select drop down buttons configured as described here: https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html) and need to be able select their values in a script. Script is called
Facing issue on file upload using Creator api v2
When I'm trying to upload a file using creator api that time I'm getting authentication error, but when I have tried to create new records within creator using api that time record creating successfully and the authentication error is not showing. Please
Form to search a lookup and then open another form
Hi all, Coming from an Access background here so a few kinks to iron out. I have an application with Form 1 that is: Initials (Autocapitalise) Postcode (Checks details are correct) UniqueID (Initials+Postcode) updated on form submission I then have Form
Comments on records
1. Can a user write and view comments on records on mobile app ? 2. When writing new comments is there a way to use them and send email notifications ? 3. Can someone atach file in comments ?
Print template in list view.
Hi, is there any special way to use a template when printing in list view? I have followed the online examples, but can only get it to work in summary view so far
pop up reminder
HI there Hope someone will be able to help me I have a schedule set up for Birthdays. Is it possible to create a pop up (instead of sending an email) with all the schedules for that day Regards
Deactivated Users will accounted for the number of users?
Hi All, I have added a user to my apps, but unable to removed from the list of users and I can only deactivate the user. My question is will this user occupy my users count when it is deactivated? Thanks!
Embedded form problem in Safari
Within Safari, our most popular embedded form is showing "Please wait..." with a rotating arrow that never goes away. Only by right-clicking and opening the embedded form in a new tab does the problem behavior resolve. Is there a Safari-specific issue?
How to Effectively Use Zoho Creator Customer Portal?
Zoho has become one of the most important platforms being used by businesses all across the world. It has multiple functionalities aimed at improving the business processes within organizations. One of these functionalities is the Zoho creator customer
when select single record and generate(button) working fine, but when selects multiple records and click on that button not working the same.. issue..
Hi, On report page just next to delete button i have added button called as Generate and it is working fine when selects one record and click on that button but when i select multiple records it is not working same as when we select single record. So,
Best source for learning Creator
Can anyone share a source that is a good resource for learning all things Creator? I've been learning on my own as I build and expand our companies application. Every time I need to figure something out, finding solutions can be quite the task. Often
Page parameter not passing to form field
Hi, I'm trying to pass a simple text value to a form field in a page using a parameter. I'm sure I've achieved this easily before so need to double check. I've checked the parameter is being passed by adding a panel to display the parameter value which
point of sale
Hi, Can Zoho creator make POS (point of sale) system ? if yes from where I should start ? Thanks
How to integrate Creator with ZOHO Projects
Hi All, I get no help about how Creator integrate with Projects from https://help.creator.zoho.com/Integration-with-other-Zoho-Products.html. Is there any way for Creator to list projects from ZOHO Projects and then list project users for the selected one? Thanks, Roger
How do I deal with multiple currencies?
Hello, I have a form that uses a dropdown field to determine currency, then number fields to store the 'raw' decimal amount. So, for example, a user might choose "Dollar" from the dropdown, then add values of 0.06 and 50 to a couple of other fields, which means $0.06 and $50. Alternatively, a user might choose "Pounds Sterling" from the dropdown, in which case the 0.06 and 50 would mean £0.06 and £50. I ultimately want to produce a report with totals in US$. So, I assume there will need to be an
Automatically create email accounts from Zoho Creator
We have an esablished Zoho Creator site and create email accounts for our clients to sign in with. Is there any way of automating the process to automatically create a new email account when details are added to a form in Creator ? example : We have a
Deluge Script Version control system
G'day, can you recommend an online source code control system (over the web) for the retention of older copies of Deluge script???? Liam.
Subform JS SDK - Creator
Q1 I have a need to use an array data type in my widget, and most suitable seems to use a Subform. As multi select requires predefined fields. What other field could I consider when I need an array in my record? Also I have trouble working with SubForm
Grammarly no longer works.
Grammarly chrome extension or firefox extension is not working and I am sure that there were changes made to the text box. Both Windows and Mac same issue. The third point in this support article is the issue https://support.grammarly.com/hc/en-us/articles/115000090392-I-do-not-see-the-G-icon-on-a-certain-web-page-or-in-a-certain-text-field-but-see-it-on-other-web-pages- And it worked before, major issue. Any views?
Where are the email templates?
I have created a form and there is an option to send an email upon completion of the form. I see a dropdown where I can select a template to use. There is an option for Template 1 and Template 2; where are these templates stored so I can see what they
What is NOT and OR logical operators?
Hi all, new to deluge. What is this logical example means? Two Conditions with NOT and OR logical operators? ! (a>1) II (b<10) How does this differ from OR logical operator (a>1) II (b<10) The examples in Zoho Help doc text explanation are the same "implying
Image Upload Field Size Limitations
Like most image uploaders I want to restrict my users to specific file formats and image sizes (eg, .png 256*256) How do I do this with Zoho Creator?
URL Field - Scripting
hi, The form field type "URL" has three variables: "URL", "Link Name" and "Title" can you use scripting to access and modify these seperate variables? I want to dynamically create a URL field for each record. The reason for this attempt is to create "View this record" link for each row which goes straight to the individual record view. I managed to script this effect for the form using a "Single Line" which has only one variable. But only to find the system automatic URL linking broke the link once
disable form button in Zoho Creator
Hello is it possible to disable the enter button in a Form so when a person is entering data and is only partly done but hits the enter button on there key board by mistake which submits the Form I only want them to be able to submit the form with the buttons below the Form not the enter button on the keyboard how would I go about doing this.Thanks in advance.
Update Record function Problem
I just got problem about Update Record Function, it change the data field to all records in the report. it just happen today since i use this function very long time ago. Anyone got the same problem, and how i quickly fix this problem by coding deluge
I want to translate the form of Verification Code
Hello! Is it possible to code something, or otherwise translate this part: I want to translate the form of Verification Code (enter the characters you see in the picture Above) PIC: Is this possible? Can not add system CAPTCHA code system? It would be easier and easier to understand ...
1 to many relationship
I need to create a one to many relationship between two forms. EX: Property -> Diary 1 Property can have many diary entries by date. I want to be able to click a button on the Property Form and add a diary entry. Is this possible? I'ver read your samples on creating an autonumber field, relationships, and subforms and I'm still confused. The property field has a property_id and the Diary field has a diary_id. Thanks, Leslie
Rename "THE MAIN NAME" ? of the form?
Hello! This may be a stupid question but I can not find the option to do that. I know how to change the name of a regular form or report but how do you change the main name? I underlined the titles Id like to rename. Im running around all the pages and
new import tool causing problems
the new import tool is a major downgrade for us, a few problems we are having: 1.Fields not mapping or mapping wrong ( exact same name in file and in zoho ) , worked before . 2.Import fail on date even due the date format is fine ( this has been working
NO OUTPUTENCODING message
Hallo everyone, today when I export a html page for printing, it appears the NO OUTPUTENCODING message as you can see in the screenshots. I search the code of the page and I made also a screenshot in case it helps! Thanks in advance for your help!
Is there a way to do an "OR' search on a column, using normal Search?
Is there a way to do an "OR' search from the normal Search? Such as to find tenant name (text field) that contains "starbuck" OR contains "coffee" OR contains "brew"? If it is possible, please reveal the syntax. (I see that the Global search allows OR. But Global search does not assume wildcards and does not work right when wildcards are used with OR. And, global search has limits vs. searching on the actual report.) (And, using an automatic Filter requires a Lookup field, and this is not practical
Including field data within a URL
Hi, I'm trying to embed some fetched data into a URL to send out in an email but struggling. I have a field against a user called Calendly Username which i'm fetching from that form. That is all working fine. What i'm struggling with is using that data
Cannot Find Payment Module in Zoho Creator
Hi, I'm trying to integrate payment processing into a form I have on my application, but cannot find the option to add the relevant field anywhere. I have configured a Stripe connection (see first image), but there is no option to use it in the Integration
Multi-Page Forms
I have seen this question asked numerous times over several years, but it seems that Zoho still has not addressed it. It is possible and easy to create a multi-page form in Zoho Forms, but this functionality is still missing in Zoho Creator. Are there
Terms and Conditions Field
Is there a Terms and Conditions field in Zoho Creator like there is in Zoho Forms?
Multiple date fields in Calendar
I would like to be able to have different events (read: date fields) to appear in a calendar view. Even fields across different forms. An extra cool feature would be if each field could get it's own color for the multi-field-calendar.
Next Page