- [Free Webinar] Learning Table Series - Creator for the Nonprofit Industry- Hello Everyone! The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience by demonstrating how Creator can be used as a solution for various 
- Give us access to record comments through API/Workflows/Deluge- It would be great to have access to comments related to a record through API, workflows and deluge. This could open up a lot more possibilities on how the comments section in Zoho Creator is being used. One use case I would consider is creating workflow 
- Reservation System- Here is my basic code to start with. // Step 1: Capture user input for Check-In and Check-Out dates check_in_date = toDate(check_in,"MM-dd-yyyy"); check_out_date = toDate(check_in,"MM-dd-yyyy"); //info "Check in date " + check_in_date + " - Check out 
- Zoho App For Written Note Taking Template- I am trying to use some app within the Zoho sphere of apps to take my on site assessments with customers. Every app on Zoho I tried so far (Writer, Projects, Etc.) can not handle me using my Apple Pencil (It only wants text entry). Is there an app that 
- IT Asset Tracker using People- Hi, we are currently using Asset Tracker to hold our machine "laptop" information. Is there a way we can use the User contact information in People to associate them to a machine "laptop" Thanks 
- Find next upcomming date in report (calendar or list) with workflow- I have a web store in which I want to force the delivery date of the order to be the next upcomming date of another form (a form that states the available dates for deliveries). Any type of script like "getthenextdate" exist in Deluge ? Also, is it possible 
- directing contract form to my email- Morning I've creating a contact form and embedded it. How do I get responses to come to my gmail inbox please? 
- User level log in data- We have given roles and access, but when i am logging in using login user id, i was not able to see the exact related data of myself, it is showing me all the details. 
- Styling a Multiselect Lookup in a Report- Has anyone ever successfully been able to style a multiselect lookup in a report? These types of fields aren't available in the styler... 
- Empty Values in Mandatory Field in Zoho Creator Report- Dear Zoho Support Team, We are facing an issue in our Zoho Creator application where a mandatory field in one of our forms is showing as empty in the report. Despite making the field mandatory and preventing duplicate entries, some records still have 
- Sandbox data- Another useful feature would be to migrate the data from production into Sandbox. Otherwise making up test data in the Sandbox is a very very tedious job to say the least. 
- Creator Simplified #3: Iterate a set of code "n" times- Hey Creators—we're back with another edition of Creator Simplified! Objective Generate subform rows with serial numbers based on user input in a field. Use case Assume an event is being organized in an organization, and HR needs the list of participants 
- Delay timer for submiting form- Hello, Another bizarre question : is it possible to have a workflow that gives a delay for submitting a form or else it send the user to another page ? The purpose is that I have a customer form folowed by a subsciption form (or an order form) and if 
- Searching for creator-openAi resources- Hello and good day...I saw a while back in the community a webinar series on how to connect Zoho creator to OpenAI via the API but I am having trouble locating that resource again. It was a webinar about an hour long hosted by a woman...can anyone help 
- How to insert multiple selected records from a report into subform of a form in zoho creator?- I am developing a simple site apkzhola inventory application in zoho creator. There are 2 forms in this case. Form A: Material request. This form has a subform with fields for product and quantity, Form B: Purchase Order. Has a subform with fields for 
- Accessing subform record related to another record.- I'm trying to access the record of a subform that is related to another record, is there any way to do so? I've tried by fetching the records of the subform with specific criteria, however the ways to search pull multiple records and not just a specific 
- Calculate 18 dates to fetch separately in another form- Hello, I have a form called "Subscription" that holds the following informations : Customer name (or ID, it is from a lookup) Delivery day (ex. tuesday, using single line string field) Number of deliveries (9 or 18) Start date (a given monday) As soon 
- Trying to show a hidden field in a subform but get "invalid task in subfrom action.- When trying to show a hidden field in a subform but get "invalid task in subfrom action" when trying to save the action. The script is below. I look forward to your help. if(input.Jobs.Job_Type = "Warranty")  { show Jobs.Warranty_Parts_Cost;  } 
- How Does One Control Form Field Visibility by Role?- I feel like this is should be obvious and I'm being a dummy for missing it... Basically, is it possible to get this type of visibility control for form fields for roles other than Everyone or Admin? My use case is that my form has a bunch of fields that 
- Make some workflows functionnal only for portal user, not the admin- Is it possible to make workflows function only for portal users ? I have a form that I disable some specific fields, for user not to change them but see them, and as admin I want to change their content. For example the user has to ask me to make a change 
- zoho.crm.searchRecords from Salesorders by id- Hi, I'm trying to obtain salesorders data using searchRecords id but I don't know what is the id field name. I have tested with salesorderid, salesordersid, id, ... and a lot of names for the id field but always I get the error {"4832":"Invalid parameter value"}. I only want to know what is the id field name to get the salesorder data. I am using this code: sCriterioBusqueda = "(salesorderid|=|" + input.OrdenDeVenta_ID + ")"; crmResp = zoho.crm.searchRecords("SalesOrders", sCriterioBusqueda); alert 
- Creating a Button to Open a Report based on a criterion- I have a report called All_Jobs_Report with fields like Job_Number, Client, etc..... I have another report called Item_List where Items are added with a look-up field which gets the info from Job_Number field from All_Jobs_Report. Now, in the All_Jobs_Report, 
- ENTER key triggering Submit- Is it possible to stopped the ENTER key from the mandatory triggering of the Submit button on Creator form? I want forms submitted "ONLY" when the Submit button is pressed.  
- Retrieving informations from a lookup of a lookup- I have 3 forms linked by lookups: customer linked to subscription which in turn is linked to calendar. In the third form, calendar, I don't have access to the customer name of the first form to use in my deluge scripts. What are the good practices for 
- change week format?- hi make view in zoho creator take Added Time == This Week system takes all days since sunday how can i tune system take all days since monday for This week? since monday is russian format of week 
- Have another form in a dialog box loaded from another form instead of new window- Hello, I am trying to attempt a workaround with forms being submitted on the Enter Key. Barcode Scanners usually default to send an Enter Key command after scanning the barcode. While there is ways to configure your scanner to not do that, I want to provide 
- GPS Link Custom Action- Here's a custom action you can use to make a popup window using google maps void GPS(int zID) {     query_address = MASTER_FORM[ID == input.zID].ADDRESS_for_GPS;     query_address = encodeUrl(query_address);     openUrl("http://maps.google.com/?q=" + query_address, "Popup window"); } I prefered the way the old url builder worked. It took me some time to figure out how to set-up the new url builder to work: Cheers, John Whitney 
- Need support with Curl API and fetch data for GPS Telematics- Hi I am trying get a GPS Data of a vehicle form its service provider .I have reced a sampl CURL Request. I am new to use this kind of API in zoho deluge .Kindly help me out with a sample code to use the same inside deluge curl --location 'https://cvp.api.tatamotors/auth/realms/external/protocol/openid-connect/token' 
- Sorting subform rows and display results in page- Hi all, assuming I have a subform like this: row1: a) row2: b) row3: c) than I save the record and open it later for a quick sorting the subform by dragging the rows: row1: b) row2: a) row3: c) Now I have a page that display the results, but in the first 
- Delete Subform Row (Orphaned Records)?- Hi guys, We have hourly instances where our employees use a parent form with a subform within. It's common for them to remove many of the rows in the subform, leaving behind many orphan records. I want to be able to delete the orphaned records that have 
- Creator Simplified #2: Effortless Code Management with Deluge Version Control- Hey Creators, Welcome to our next post in the Creator Simplified Series, where we share tips and tricks to make your app development journey easier. In this post, we'll be focusing on an often overlooked but super helpful feature—version control in Deluge. 
- How can I get emails into a list in a multi line form?- I have a form named company details with a single line field named company name and multi line field named "user email list" I have a second form named user profile. In this form there is a lookup field that shows a dropdown of records of all company 
- What links customer to their own information in the portal ?- I know how to give permissions to some parts of my application, and how send portal permission link to my customers, but what exacly links my customers to their own information in the portal ? I though it was as simple a recognising the email adress in 
- Masking phone number- Hi all, I'm trying to mask the first 3 digits of a phone number, like this example: Original: "912384735" Masked: "xxx384735" I've tried use the remove and replace function but with no success. Thank you for your help. Best regards, Rui 
- Lookup used in an OpenUrl script do not transfer ID ?- Bonjour, Is it possible that a lookup field I use basicaly to open another form and transfer a customer name, with the openurl, do not transfer the ID of the original form ? In a third form linked with lookups, I was not able to retreive the first form 
- How can I make a Math equation from user input using Zoho creator?- I try to create an app like a calculator in Zoho creator to enable users write an equation with any number of fields and operations how can the user input N of numbers and N of operations to calculate the equation? 
- PMT Calculation- Anyone know how to calculate a payment on a loan.   I have the term in months, annual percentage rate and principal ... easy to do in Excel with the PMT function but in Creator?????  I would like to just put the formula on a Form page without having to write any script ... is this possible? 
- Calendar report - Customizing the view- Hello, My main calendar view will have approximately 80 entries per days (customers will only see their on one entry though). Is it possible to limit the size of the calendar's day box ? Or simply put a number as how many entries are there ? Sylvain 
- how deluge statement usage limits are count- Hi, There is a limit of 5000 statements in a script, for example when I process an on load or submit script. In an earlier forum post I found this text: But if you have a "for each" loop within your action script, the number of times the tasks are executed depends on "the number of records iterated x the number of tasks".  For example, if you have 500 records to be iterated and 3 tasks, the total number of executable statements for this action is 1500.  It is not the number of times they are triggered 
- Help with global structure of my project- Hi, I do not know if this is the place for that type of question, if not please tell me where to send this question. I am to a point I need advises on my structure. I have created the basic forms I need in my project, but I will soon get in more complicated 
- Next Page