How to hide or show options in dropdown B based on selections from dropdown A
I have created two dropdowns A and B. I want to show certain options in dropdown B based on the selection in dropdown A. Is it possible? What is the relevant coding to perform this function? Please help me Many thanks
Connect to an API that needs to whitelist my IP
Hello, I need to connect to an external API and they only allow connections from whitelisted IP addresses. How can I achieve this if my app is hosted on Zoho Creator? Is the IP the same (static) for all Zoho Creator apps?
How do I add button on a form?
I want to either have a button on link on my form which can take the ID and show respective details for that that record? For e.g. Let's say I have EmployeeInfo form and VacationRequest form. In the VacationRequest form, I have lookup called EmployeeName that displays all employees. I want to give a link or button right next to the EmployeeName look up field where the user can view the Employee details, in a popup, without leaving the VacationRequest page. Question: How do I add a button or clickable
Classes and CSS styling in Zoho Creator form fields
Hi, it would be nice if you could assign CSS styles and classes to the form elements from the field properties. And also, to be able to write CSS somewhere for the form, so that it is applicable on the form in any situation. Since I am currently using
Setting Up Deploy Mobile
Hi zCreator Team, Just want some help navigate where can I find the deploy section for me to create an SDK for Users.
Contains operator in Creator REST API
Hi, How can I use the "contains" CompOperator from the REST API ? If I do http://creator.zoho.com/api/csv/dvd/DVD/view/matchall/Title=Heroes/apikey=... it will work for exact matches. But how can I search for fields which contain the string I specify? Many thanks, Richard
How to find time difference between Date-Times and set to Time field of Creator
STEP 1. FIND TIME GAP using `timeBetween` startTime = zoho.currenttime.subHour(2).subMinutes(24).subSeconds(4); endTime = zoho.currenttime; timeGap = startTime.timeBetween(endTime); STEP 2: Structure Time String for Time Field There's an issue with the
File upload and send email
Hi I created a form on Zoho Creator and some fields are file uploads. I would like an email to be sent to me when the form is sent, with the form information and the file uploaded in the form attached. In Zoho Form, I've managed to do this, but I can't
Zoho Creator customer portal limitation | Zoho One
I'm asking you all for any feedback as to the logic or reasoning behind drastically limiting portal users when Zoho already meters based on number of records. I'm a single-seat, Zoho One Enterprise license holder. If my portal users are going to add records, wouldn't that increase revenue for Zoho as that is how Creator is monetized? Why limit my customer portal to only THREE external users when more users would equate to more records being entered into the database?!? (See help ticket reply below.)
Redirect USER to new url after submitting form
As it is, when a user clicks submit on the form on my website, it appears as though nothing happens because the form is so long, you cannot see the "date submitted successfully" message that pops up. Nonetheless, all the input is still there and nothing else happens. What I would like to accomplish is for the form data to do what it's designed to do (send confirmation emails and send data to zoho for storage), but the user be redirected in the same window to a new url on my website, such as, ".../ThankYou.aspx."
Hyperlynk local file
Hi, I am trying to create a hyperlink to a local file, however I keep running into an issue. The user should enter the path in a string field. From this string field I then make the hyperlink as followed: mypath = input.filepath; filehandle = "file:///"; new_link = "<a href=\"" + filehandle + mylink + "\">" + mylink + "</a>"; input.url_link= new_link input.new_link_string = new_link //this variable is to verify the newly created link new_link_string displays the newly created link properly, however
How to fetch parameter from url
Hi there. I have an application (a sample is available on https://creator.zoho.com/zoho_dhl/dhltest/#) where I want to send my users a URL with their userid so my form can fetch the ID and fill out part of the form up front. So I would like https://creator.zoho.com/zoho_dhl/dhltest/#Form:RMA?User="Happy User" to result in disabled User field being updated with "Happy User" (and then having my deluge script finding the email for that user etc. etc.) But I cant seem to pass on the parameter to the
How to use creator edit mode form in a widget
I can publish a creator form and report with embed code and use it in the widget. but I need a edit mode form embed. is there any way to get it ?
App Custom Icon Not Work
Hello Zoho team, I have set a custom icon in the code-signed Zoho Creator application but not work. Also discussed this with the Zoho support team but still have not solved this issue. As per the Zoho technical team's suggestion, We checked by installing
License manager for custom (non-Zoho) app
I am a Zoho One customer and am developing a non-Zoho app to be installed on premise for which I need a solution to manage subscription expiration. I have built little database apps in Creator before, but this would need to allow querying over the internet
Error Message with Deluge Workflow
Hello everyone, I have this Deluge script that executes whenever another form is successfully submitted: insert into New_Site_Assessment [ City=input.City Homeowner_Email=input.Homeowner_Email2 Homeowner_Name1=input.Homeowner_Name Homeowner_Phone_Number=input.Homeowner_Phone_Number
Input validation phone number
I am trying to find a way to make field constraints for input of a phone number. Example: France (country code 33) local number 0142687984 should be input as 33142687984 and not for example 00331 42687984, 0033 (1) 42687984, +33 1 42 68 79 84 etc basically the number should never start with 0, should not include spaces or signs like + ( ) etc and should have at least 9 digits I have been trying to find a sample for deluge scripting but no success. Please help
Three state decision-box
Hi, if i use a decision box field in a form and make it mandatory, i can submit the form only if i flas as true. I thinks that is better to make it with three state, true (V), false (X) and null(-) if i make it mandatory cause of a mandatory decision
Workaround to follow both physical stock and project-related expenses.
Hi All, I built an Asset Management App in Creator and now want to exclusively use this app to keep track of the physical stock as well as the related expenses on associated projects. I do all that through deluge scripts using the api's. Each asset is
Stumped by OpenUrl when trying to open a filtered report with the click of a button.
I have two Forms, Accounts (parent) and Jobsheets (child), with their respective reports. They are related in 1:N relationship. I tried adding a button in the Accounts report, as a column labeled "View Jobsheets". The intent is for the on-click action
Spacing between fields
how do you control spaces between fields? I have a lot of fields to put on a form and want to put the fields more closely together. It seems like the spacing between the fields are automatically set and I am not sure where I can change this if possible.
Free version
This has been discussed elsewhere but I can't find a specific answer relating specifically for Creator. I have signed up for the free version (I think), at least I did not enter any payment details. As I have invested quite a lot of time and effort into developing (quite a good) app, I want to know exactly what will happen when I hit day 15? Will the app behave any differently or will I be forced to upgrade my account to keep using the app? Thanks
Subform properties
Hi, I need to understand the behavior behind a subform. If I create a form called "subform" with some fields and workflows related to each field (e.g., enabling fields, setting values, etc.), why can't I inherit that behavior when I use my subform within
Change the File Name before Downloading the file ?
I need to change the filename before downloading using deluge. Is this possible?
Please share the steps to done it.
Can I get page variables when I execute a button in a report which in that Page?
Can I get page variables when I execute a button in a report which in that Page?
Find next available integer in sorted list
I have a custom function that finds a next available integer and creates a part number. The function currently takes a sorted list and loops through each item to find the missing number in sequence. On some part numbers I run into an issue where statement
how to calculate difference between time?
hi there is Added_Time and Modified_Time how can i calculate how much time between Modified_Time and Added_Time Modified_Time - Added_Time = time_X ? in days, hours, minutes, seconds
How to get the request object on zoho Creator API.
Hello, I'm trying to create a Deluge function that runs on an incoming webhook. I made a custom API on Zoho Creator and connected it with the custom function, but I can't get the request object in the function. I found an article that shows it can be
2MFA in ZOHO Creator Portal User
How can I implement 2FA (Two-Factor Authentication) for Zoho Creator portal users?
Help me! Error {"code":2945,"description":"EXTRA_KEY_FOUND_IN_JSON"}
Hi, Good mornig , I have a problem with add data to creator API and I don't understand for why. The same process be have correctly excute the last week. {"code":2945,"description":"EXTRA_KEY_FOUND_IN_JSON"} I need your help. Thank You
How to update a Creator form record checkbox value to be true (checked) or false (unchecked)
I can't find the answer to this... I have page which is successful pulling record from a Form, and now I am making a custom function which will update a checkbox when it loads. My function is: dataMap = Map(); dataMap.put("Company_branding", true); otherParams
Prepopulate a field name based upon a zipcode table
I have a created 2 forms, an application that people will enter their information. Once they enter the field zip code I want to pre populate a field in form 1 with the city information. Form 1 is the application Form 2 is the zipcode with city and county fields Pls help I am new with building scripts
Kaizen #136 - Zoho CRM Widgets using ReactJS
Hey there! Welcome back to yet another insightful post in our Kaizen series! In this post, let's explore how to use ReactJS for Zoho CRM widgets. We will utilize the sample widget from one of our previous posts - Geocoding Leads' Addresses in ZOHO CRM
Creator Form - Form Submission Confirmation Popup not working
I have a form in Creator, and in the Form Properties, I have selected the checkbox for "Open form submission confirmation popup when Enter key is pressed". However it doesn't seem to work. When editing my form, if I enter a new value and press enter,
Change name of PDF download
Hi! Is there a way to change the file name of the PDF to the input of a field before downloading it? Ex: When I download the PDF of a record, I want the file name to be the input of " Date_of_Event". So it will download as 1/1/2017.pdf
Checking Expiry Date
Hi, Im new to Zoho creator, i need to create a function or query for my report to show records expiring in the (x) days. I have a expiry_date field and i try using Expiry_Date.toLong() / (1000 * 3600 * 24)) <= 30 Im getting an error " Invalid Search Criteria" Thanks in advance
Resize Signature field dynamically
On the tablet, it is perfect. But on smaller mobile devices and PCs, both web and application, it is too small for people to sign. Is there any plan to make the signature field size dynamically in the future update?
List report with totals for Group and Subgroups
I have a List Report with Groupings of Division, Department I total some numeric column Now I get Totals for Department and totals for the whole report (the whole company for all records included in theForm. How can I show a row of totals at the end of each Division?
Regarding Multiple user dashboard
"I have created a dashboard that includes information on the number of students who have joined and the number of colleges, among other details. There are two portal users, Tharun and Abi, who are adding records to the form. I would like to track which
SUM a field with related record and update in another form
Hi, I have one form called Record form for portal user and admin user to add record accordingly. In this Record form, there is one Amount field. There is another Profile form where each portal user will be prompted to create their Profile upon first login.
Next Page