Tool to automate via API's
Hello, I want to automate some task within our instance of Zoho analytics via the APIs (Delete's with specific criteria, Select-Insert using download then Insert etc) I can do this via Postman, but when I try to schedule the tasks, the scheduling does
Update record from another form to subform Zoho Creator
Hi. - I have a form name maintain - And a subform (in another form: car_maintain) name car_maintain.set_up_maintain I want to update every new record in form maintain to subform car_maintain.set_up_maintain if maintain.car = car_maintain.car AND maintain.type
Display image on form
how to insert image on a form, the image field only allows for upload of images.
Image field preview and download are broken
Something changed recently (rights-wise?) in which my non-admin users are presented with a broken image icon when trying to view images in a report's Quick View or Detail View. When they click on an image, they receive the following error message: "Something
Can I connect Creator to a user created module in CRM
I want to be able to create a trigger which, when actioned, will add an item to a custom module i created. Is that possible? In the conenction setting between creator and crm, it only has a few modules. Thanks
getYear() function not allowed in criteria - what's the alternative?
In my form1 I have a dateField and salePriceField. In my form2 I have a yearField and totalSalesField. I'm trying to insert records into form2 like below, but getting the "not allowed in left side of criteria error. dateList = form1[ID !=0].distinct(dateField);
Open URL to a report record to edit from public
I have a form set up that my customers will input their full name and DOB to see if they already have an existing record. If they don't, then a new blank form will open for them to complete a record. However, if they do already have a record for this
Unable to create many-to-many relation between existing subform and form
Hello, I'm trying to create a many-to-many relation between existing subform and form following this guide: Bidirectional relationship between main and sub-form | Zoho Creator Here's the structure. Form 1: Tasks - Task name (single line field) - Steps
Can regular user and portal user from China access to Creator in US DC (.com)
Hi, We are an American company that register Creator account with US DC (.com). Most of of customers are located in China, also there is a small office team in China. As title mentioned, would like to know will the regular user and portal user having
Subtracting a value from another form
Hi, I have a form called performances which has 3 numerical fields: Number_of_Tickets_Available Number_of_Tickets_Allocated Tickets_Remaining I have another form called Tickets_Allocated. This form pulls the values of the three numerical fields from the
Populating a form field from a report button
Hello, I have a form report that has a list of coach companies, and a column that enables users to add a review by clicking a button. (See below): There is an 'Add a Review' button on every line (next to each coach company. When the user clicks add a
alignment in forms
Hi there, I have two questions: 1. In a form, how can I align checkboxes to the left margin? 2. Is there a way to force a single or multiple line text field to appear below the label? The form I'm talking about is http://creator.zoho.com/kimschotanus/intas-projects-coordinators-and-team-leaders/form/50/
Zoho Creator Calendar view
Is there any way of sorting a list of items on a given day in Calendar view to display in alphabetical order?
Send email notification to added employees when a record is added to a multiselect-lookup field
Hello, I'm using Zoho Creator to keep tracks of who's responsible for each Function in the company. Here's an example of a "Function" record: Function name = Invoicing Main owner(s) = John Doe Substitute owner(s) = Amanda Lear, David Bowie Where: Function
Deluge statement execution limit
Hi I try to use a function iterate all records (about 10,000 records) and revise some fields Here is the error message I got "The number of deluge statement execution limit exceeded the maximum limit." Is there any way I can easily to do the batch revise over all records Thanks Regards, Matthew
Help !!!!
Je souhaite réaliser des calculs sur les montants de ma table 'table_faits' en les multipliant par les coefficients correspondants. Cependant, il est essentiel que cela soit fait de manière séquentielle, en commençant par un type de mouvement spécifique,
Built in Search, Last n Days not including Today
I'm seeing a strange behavior using the built in search option on date fields. This is a field that I populate through the Zoho API. If I choose any of the available "Last n days" date range functions, i.e. Last 7 days, Last 30 days, the view does not include records with today's date. The "Today" option returns today's records. The field uses the following format: yy-mm-dd hh:mm:ss I have not tested other formats to see if it is specific to this one. Update: After looking at the code zoho generates
Hide Subform Field for members
Hi, I have a field in a sub-form which I would like to remain invisible for anyone except the administrator. In the Permission section of this field I have selected "Hide this field to others". If I log on as user, the field is still visible. How can I hide fields to users?
Direct link to record audit?
Is there a way to create a grid view action that would take me directly to the audit record for a particular item that's clicked on - what would the URL be?
adding currency fields in a formula
This seems like a no-brainer but when I try to add two currencies in a formula field I'm getting a concatenation instead of the sum of the two fields. So, $5.00+$8.00 becomes 5.008.00. Do I need to convert the currencies or something?
Is there a way to invoke a function using <a> tag in html snippet in zoho creator page?
Is there a way to invoke a function using <a> tag in html snippet in zoho creator page?
Lookup field to the same form
Hi, I'd like to create a lookup field that points to the same form where i'm creating the form. Is it possible somehow? I want one record to point to another record in the same form, based on some critierias. Thank you.
Different behaviour when saving record depending on how I open the record editing page
Hello, I've created an app on Zoho Creator and I see a different behaviour depending on how I open the record. 1) If I open the record by navigating the app, edit it and save it: I see a "Data updated successfully" pop-up on the top of the screen and
Conditional Formatting Date parameters
I have a date field that is used for a deadline. I'm using conditional formatting to color the date text red if the date is in the current week. The problem is if the date is past due over a week, the color does not stay red. It reverts back to the normal color if the date is post-dated over a week ago. Is there a condition that says, "if the date is after the deadline, keep it red." I've tried using the "after" condition but there isn't a way to tell it "after" the field date. It only allows a string.
How to get the link /url to an attachment
I need to get the url / link to download files uploaded through the form. this link needs to work for people who are not logged in (i.e public link). Can anyone help ? The old format i found won't seem to work. Thanks!
Filter dropdown lists
How can I filter the data users can select from a drop-down list? Example: A sales person wants to enter a sales meeting it had. He selects his name from a dropdown list and after that he wants to select the company he visited ( he previously entered the company in another form, with all its details ). How can the dropdown list with companies filter only the companies he is accounting for?
Save as Draft Button Missing in Zoho Creator Form
Hi, I already enabled "Save Draft" option in my Zoho Creator form. But when I go to the published permalink, I only see Submit and Reset buttons in the form's footer What am I missing here? I also tried filling the required inputs but still no "Save as
Find all duplicate Names
In a form with many records imported, I need to find and mark (Suspected_Duplicate field ="Yes") all the records with the same Name.
File uploaded - how to attach and send using sendmail
Hi, My form has these fields Document: [upload file] Contact Email: XXX@domain.com When a new record is added, i want the document/file uploaded to be sent to the contact email. i tried to add it into the message using "input.Document". But when i received the email, input.Document just prints the name of the document into the message body. There is no email attachment. Anyone with any idea! This is pretty important to the application i want to build... anyone with any ideas?
Accessing Zoho's Barcode generator?
Is there a way to create an image link to barcode images from Zoho's free barcode generator using and openURL script? I'm doing this using barcodesinc.com's free generator, but would like to try getting them from Zoho's generator. I can't figure out what
Sort list by count (occurance) or character count
Wondering how to sort a list by either occurrence count or character count. I have: toppfs = LP_inventory_form[AUCTION_TITLE_ROOT = input.AUCTION_TITLE_ROOT].Pressing_features.getAll().distinct(); toppfs.sort(true); input.Pressing_features:ui.add(toppfs);
How do I pass data from one form to another form?
hi Zoho creator has 2 forms. First form have name and email. Go to second form after submission. How to view name and email in second form?
Cursor lands on disabled fields when tabbing through forms
As of yesterday, form behavior has changed w/ regard to disabled fields. Previously when tabbing through a form the cursor would skip over disable fields (as would typically be desired). But now the cursor is landing on all disabled fields, in all of
"Save & Resume Later" or "Save as Draft" for Zoho Creator Forms
Hi, I am trying to create a form on Zoho Creator with the options of "Save & Resume Later" in addition to "Submit" and "Reset". How can I create that? (I had been a user of Zoho Form and that was a matter of setting, but it seems that there is no such
How much of Creator is Low-Code [a discussion]
The following table is my take on how much of a low-code environment Creator actually is. My takeaway? The minority. I welcome your edits and comments! Record Event Created C Edited E Created or Edited CE Deleted D Hide, Show, Enable, Disable, Set Fields
Approval flow from update
Hi, i'm setting up an approval flow in Zoho Creator. However, it seems it's only triggered when submitting a brand new entry. We have the situation where the entry is already created, but approval is requested when a certain field is updated. Is this
How to auto populate fields based on an entry?
I seem to run into brain fade right when I need the answer most. And when I'm about to go out of town. Thus I'm asking an easy question that I can't find through forum/help searches. I have one form that starts with a radio button with 5 possible choices (called "Team"). The following fields should be auto populated based on the response to to Team: Team_Head_Coach (5 possible values) Team_Coach_Email (ditto) Team_Coach_Phone (ditto) If a new record is being entered and the user choose "Team 1"
How do I find out the user account id from an email ?
I'm creating an employee register by using an API from our HR system (not Zoho People) and I want to link the zoho account of employees to this record. However I can't use the associated email and I can't find a way to get the account id. For example
barcod
pl
How to add and remove fields that can be mapped when importing from Excel
I am trying to import an Excel sheet which will come out of our POS and create an Order Management tool. When I try to import it says I have to map columns, but when I go in to map them, there are "required" fields like "Delivery Agency" which we will
Next Page