Form Field Tab Order
If you want to optimize data entry on a zoho form in Creator, how do you set tab order for fields on your form?
Checking for duplicates in a subform
I have an app with a mainform, and within that is a subform (see screen grab) which contains rows of employee names along with hours worked per day by each. I am attempting to create a validation script which will cancel submission of a new or updated record if a duplicate employee name is found. I've tried a couple of variations by defining a variable and using COUNT, but depending on how I do it I always get an error saying the form doesn't exist, or the variable doesn't exist. I'm fairly new to
How to add record to zoho creator from Github webhook payload data
Hi, I want to use a Github webhook to send data to Zoho Creator. I understand the Github webhook needs a payload URL to send the data to. Looking through community forum postings this URL will be a creator form URL in the format https://creator.zoho.com/api/<ownername>/<format>/<applicationName>/form/<formName>/record
Error at on click script: We are working on giving more meaningful error messages on script failures
I am getting this message in a stateless form. In the old version of Creator errors would show something meaningful info, like a brief description and a line number. In the new version this seems to be all I get. I looked under Settings - > Developer
Accessing widget from Zoho Creator IOS App returns non UTF-8 JSON Results
I have a widget that works just fine on IOS (iphone Safari) as long as I am not using the Zoho Creator App on the iphone (don't have it installed). But if I do install the default zoho creator IOS app and then access this widget from the App, then when
Calculating Time Difference between Date-Time fields in Minutes
Hi everyone, I know that there were a lot of concerns regarding time difference calculation, especially if you want to calculate it in a number field. I went through a lot of articles but I couldn't find a solution that I wanted, I wanted to calculate
Update wordpress database with zoho creator?
anyone here have tried to push information from zoho creator to update wordpress database? i have a plugin for my woocommerce which built under wordpress. i can connect to woocommerce api but the plugin data is on wordpress database.. anyone can shed
"Unexpected error"
Hi One of our customers are reporting that when she filters in reports she gets a prompt saying "Error Occurred. We are sorry for the inconvenience" randomly. I was asked to get some more info from the customer and it looks like it doesnt look like what
eSSL Biometric integration help
Hi Team, we are in need of quick support for us in terms of understanding the biometric integration part.
Zoho Deluge (Creator) developers - how do you organize your environment and code?
I've been doing Zoho Creator/Deluge development for about eight months. I come from a PHP/Laravel background. While there are many things to love about Creator and Deluge, I see two main challenges as my code base becomes larger: Testing/Dev Environment
Please add "Last Updated" to the Functions list in Workflow ( or a least have the same "Created On" column that all the other tabs have
All the tabs in Workflow have a "Created On" field, EXCEPT Functions. Why? Even more useful would be a "Last Updated". Adding "Last Updated" would help code management immensely. Many of us develop using a copy a restored back-up because the limitations
Permissions: Remove Ability to Create Duplicate Record
I would like to remove the "Duplicate" option within permissions for a user, but I'm not seeing that anywhere. Thanks.
Lookup field data in Deluge
I have a workflow email with various field data ... when the field is a lookup from another form the email displays a code number eg 40540007788. How do I get it to display the actual field data from the lookup field rather than this number?
Create chart with html snippet
hi guys, is that possible that we can build a chart with html script? the page chart has quite alot of limitation like height is not adjustable and cant show figure in the chart other than howering the chart. pivot chart not in consideration as in it
Subset Sum solution in Deluge
I'm trying to figure out how to implement a feature that requires the Subset Sum algorithm. Use case is pretty simple--processing a single customer payment against a subset of open invoices, but I don't know which specific invoices the customer payment
Query Parameter not working in Zoho Creator Page Configuration
Hi, I am trying to setup an Action to a Page panel using the Query Parameter option as show below. Test_AD is a field link name. Test is the field name. As shown from the corresponding Form below: As per the link here, we can query the report with a
Auto Increment field with both 1 static letter and 4 incrementing numbers
Short Question: How can I have an auto increment field with a single letter that is static and four numbers that auto increment with each new entry? More Explanation of Use Case: I looked at Zoho a few years ago to replace a spreadsheet we maintain for our car inventory. Each car is assigned a stock number that is a combination of a single letter and four numbers. For example G1441, G1442, G1443 are stock numbers for cars bought in 2019. Each year the next letter is used to start over the number
Field Link Summary Page for Creator
Just an idea to have a page similar to the CRM's API reference page for Creator Forms. Large Forms require us to build the reference table ourselves for third party integrations. The script editor's suggestions in Creator are helpful, but there is no
Import adres field
Hi, Just antoher question, i'm tryiing to import data from Excel but run into the adress field. I like the ZOHO adres field cause of it's map functions. In my Excel sheet i have columns "Street", "Zipcode" and "City". How do i import these into the ZOHO Adres field component? I can import them to a single line component but then i miss the map functions. Thanks Bart
How to check if a String has alphabets & numbers?
Hi, I would like to validate if a string has 4 alphabets and 6 numbers. For example: alphaNum = "BHGU789412" I would like to check if the user has entered 4 alphabets and 6 numbers in the above variable alphanum. Please let me know.
Bug with "For Single Record" & "For Multiple Records"
Hi, I removed "Duplicate" button from "For Single Record" under "Actions" in "Quick View" of a report. PFB the configuration. However, the changes don't reflect in the UI. PFB The changes would reflect only if I remove that button from "For Multiple Records"
Change Ticket Custom Function Example in ServiceDesk Error
I receive the following error when trying to use the example program to change a ticket in ServiceDesk: "Error at line : 17, 'TEXT' can not be cast to '[KEY-VALUE, TEXT, LIST]' for the function 'get'" LINE 17: status = result.get("status"); PROGRAM: //Assigning
Where is the reference page of all applications, reports and fields?
In the link here, it says that we can find the link name of application, reports and fields at this URL. However, I have no luck with that. It seems to be pointing to a wrong URL. PFB the screenshot of the same. I know there are other ways of getting
Is there any way to hide a row in a subform?
I have a subform on the main form which is a service ticket. The techs enter their time on the job on the subform for each trip. The seem to keep deleting the previous row on the form by mistake. Any way to prevent this? Thanks in advance.
Adding Script for a Button in a stateless form
Hi, I have added a button to a stateless form. But I am unsure about how to add a script for when the button is clicked. Can you please let me know? PFB the corresponding configuration
Generate a single Custom Report PDF with multiple records
Hi, I have created a Custom Print & PDF Template for a Report. I would like to know if its possible to select multiple records and export them under the same PDF (rather than having a separate PDF for each record as the system does by default) For instance,
Is it possible to http post to a form or html page?
I would like to post the incoming messages to Twilio into Zoho Creator form. Twilio allows to specify a webhook url to post the message data when an incoming sms is received. Is this possible? I do not want to use any intermediate php or any code.
How to specifying the encoding format as UTF-8 when using MD5 encryption.
Hello everyone Has anyone encountered this situation? Data interaction between zc and other platforms through api requires md encryption. Corresponding to the encryption format that needs to be specified as UTF-8. So ,How to specifying
open *existing* record for editing via Deluge or embedded in page
I have a page with embedded reports showing different views of a single record. The built-in Edit function opens in tiny panes where only a few fields are visible at once. To improve usability by making more of the field visible, I want to open the form
"Lead Management" built-in app
I'm trying to understand how the built-in lead management app works. For example, I can't figure out the relationship between "Leads" and "Accounts". Are you able to convert a lead to an account? Does anyone have any documentation on this built-in app?
Change Form Width
Hi Zoho Community, I am facing an issue with respect to Form Spacing. The below is the normal spacing of a form. However, for one of the forms, the two columns have a big gap in between. I am new to Zoho Creator. So, I am unable to debug. Please let
Subform: On Delete Row - For Each Record still accesses deleted record
I have a main form called Invoice which contains a subform called Alterations. The subform Alterations basically contains line items of my invoice which the dollar value is added up on a currency field of the form called Alterations_Total. I created the code below for a "subform: on delete row" event. The issue I'm having is that the record just deleted on the subform still gets accessed by the loop "for each record". That is causing my Alterations_Total to still take into account the last deleted
UPS Tracking API Certificate Change
Hello, I received the following email from UPS about a change to their API certificate. We use invokeUrl in Zoho Creator to track UPS shipments through the UPS API. My question: Is this something I need to worry about, or is it handled between Zoho
Reverting changes for invalid rows
On the form validation I can check the old value of a form row and compare it to the new value. However, I can't find a way to generically revert all changes on a row to their old values. This is what I'm trying, but I can't find the right function for
Custom Domain?
I just don't find it anywhere.... followed the instructions as on this page: https://www.zoho.com/creator/help/general/zoho-creator-for-your-domain.html There is no way for me to add/edit my custom domain. Please can you clarify as I am testing the system and upgraded to paid version and still no luck.
Bulk email limits
Hello team, In my Zoho creator application, We created two forms one is to create email groups (Each group contains many number of emails) and another one is to send emails to the group of emails that we already created. We are using send email function
Open & edit linked record in report
I have created an 'archive' custom button in an 'orders' report. On click of 'archive', I want to open the record of the CUSTOMER that this order relates to. Customer is a lookup field and therefore has a link to view the customer record in the report,
Passing Parameters to a View via URL
I need to pass a variable from a "passive screen" to a View screen. The data is to be used in the evnt that a user wants to "ADD" a record via the view screen The value that needs to be passed is not a constant (like 1234) - the value will not be known so the openurl can not have a constant passed through. How do I use the openurl command with a variable to be passed - not a constant. http://creator.zoho.com/zchelp/employee-manager/#Form:Employee?Employee_ID=<variable name> Here is the instruction
Creating a stateless form to have a supervisor sign an employee filled out record
My goal is to have an employee fill out a request form, sign it, and when submitted an email will be sent to their supervisor (one of the fields the employee enters is supervisor email), with a record template filled with the record information, and a
How to view Record ID in front end of a report?
Hi, I would like to see the Record ID of a record in the frond end of the application (May be in the detail view of the Report). Where and how can I see this information? (I know how to fetch it in the back end)
Next Page