How to trigger workflow on-(Twilio API)submit?
Hello, I have a workflow that fails to trigger when an incoming twilio text message is posted in Creator using Twilio API. The workflow was created in Creator using a form trigger, "on-submit". Does the workflow need to be built inside the Twilio package
Publish form as a public calendar?
Hi All! We have a creator app that's basically built to manage various events we're working on with associated tasks. Whilst the 'Calendar View/Report' in Creator is handy it'd be much more useful if it can be published as a calendar that our team can
Can I get file data from the file upload field upon submission?
From inside my Creator app, my users need to send images (.jpg files), documents (.pdf files) and spreadsheet tables (.csv files) to one or more external APIs. Is there any way to grab the file data (I need to include it in my API calls) from the file upload field upon clicking the submit button?
error occured please contact application owner
Hi Zoho, I am facing an error on my application on Zoho creator. The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. However, the data has been trapped in the database. The user doesn't know this and tries to re-enter the data, causing multiple entries. Can you please help? I can give you access to the application if required. Naveen
problem with dollar sign replacement
Hi, I am trying to avoid users from entering the dollar sign in a string field So I want to check if the dollar sign is in the string and if so replace it with nothing if (input.invoer.indexOf("%") >= 0){ input.invoer = (input.invoer).replaceAll("%","");} This works other characters. If I do this for # or & it works. But only not for the dollar sign Please let me know how to solve this? Rob
Zoho Creator Performance - Slow
Since 10:00am AEST, the response time in Zoho Creator is around 35 seconds. Has anyone else experienced this in the same time period?
Can you create confirmation messages in Zoho Creator?
Hello, I would like to create a confirmation message that asks the user to confirm that information they have added in a field is correct when they attempt to submit the form, and gives them a "Continue" or "Cancel" option. Is this possible, and if not, is there a workaround? Thanks!
Customer Portal
I have been successfully using customer portal to allow individual to have access to certain forms and data in my system. They all have their own unique username (email). Is there a way for me to know or capture each time the user access the system using
ZOHO Creator just hangs when i try and install a template.
Hi As the title suggest, when I try and install a template it just hangs on the below screen.
Convert Unix Time Stamp to Date
I am getting external data with a Unix time stamp (number of seconds since 1/1/70... the Unix epoch). I have used a formula field to give us the right date serial number. This formula is: (createdTime/86400 + 25569 + (-5/24)) The explanation for doing this in Excel is here (http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/) Now, since the formula is a number, how do I then convert it to dd/mm/yy format?
Not Working Get Recode API V2 and V2.1
Hello Zoho Team, curl --location 'https://creator.zoho.com/api/v2.1/zoho_admin8544/powerbi-connector/report/PowerBi_CRM_Form' \ --header 'Authorization: Zoho-oauthtoken 1000.036ed6dbd843860314596bf7eca4fc13.20b068cbfb671318a625466d4b8d8712' \ --header
No duplicate entries in Lookup Field
I have two Forms: FormA and FormB. I have a Lookup in FormB called "LastName" wich imports data from "LastName" in FormA (dropdown single select). "LastName" in FormA is not able to have duplicate entries. Is there anyway to avoid having "LastName" in FormB with duplicate entries? In other words, once one LastName has been selected in FormB, it won�t appear in that dropdown list for the next records. Thank you very much for your software.
Can I display a currency symbol in a formula field?
Hi I am new to Zoho and have quick question - I am using a formula field and woudl like the result to display in AUD currency - is this possible or is there a work around? Thanks
Filtering for a specific date range....
Hello, Trying to set a filter for agenda items by Start Date. This report goes out every Sunday and the Start Date is the following Sunday (1 week ahead). The duration is 1 week, Sunday thru Saturday. Using the operator "next n weeks" where n=2 gets me
Merge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation
Sending a canvas report via email
Hi, I have created a report layout using canvas and now I would like to send it via email as it can be done using a template. My working method so far is: sendmail [ from :gw@gmail.com to :mw@gmail.com subject :"Sample invoicel: " + input.CzeUzyNum message
Formula Field + .sum() Function
Dear support, It would be life changing if you allowed us to use the .sum() function in Formula Fields, especially to sum row values in Subforms. I'm aware of how to do it via deluge/workflows, however, this would save a tremendous amount of development
can we add print feature in the button by page?
Hello, I'm trying to generate barcodes in Zoho Creator using an external API, and it's generating successfully. However, when I attempt to print it, the predefined process in Zoho Creator seems complex. Is it possible to integrate printing features into
Save image to device gallery on Creator Mobile app
Hi there, Is there a possibility of implementing functionality where an image taken on the mobile versions of Creator apps will give the option to be saved on the device itself, similar to the Zoho Forms mobile app? We have a use-case where we want the
Scheduled Fx Script - Not Working
Hello everyone, Its been 2 years and still feel new to Zoho Creator because it seems like I am consistently needing things done that I do not know how to exactly fix. But anyway. I have a form my team submits. Within the form, there is a field for the
Workflow to trigger when ANY user unpit field is changed in a form
Hi, I would like to see a form recalculate formulas ON SCREEN whenever a user changes ANY ONE of a group of specific field numeric input on the form. I would like the funtionality similar to the "on submission" result, but be able to see the change on
What is going on w/ field focus on disabled fields?!
Prior to a few months ago, field focus ignored disabled fields when tabbing through a form. Then all of a sudden disabled fields were focused, which caused me to modify all our forms to keep our workflow going smoothly. Now, as of today field focus is
First Aid Tracker
Good day, all, I hope you're doing well. Would like your assistance with creating a Zoho Application on Zoho Creator. We are creating a First Aid tracker which will ask the user to check 12 different first aid kits given three conditions. What is the
Filter Project List by Owners in Creator
I am able to list all active projects using the following code: zoho.projects.getProjectDetails("myPortalName","active","myConnectionName"); Is it possible to filter this list where Project.Owner inclues a given employee name/ID?
How to Get a List of Radio Button Options or the Index of Selected Radio Button Option in Deluge
Hi, I have a list of radio button questions, each having 3 unique (texts are different) options. For example: Question 1: - This is an answer - Well this is another answer - You could also choose this answer I want to assign scores for each option as
Difficulty retrieving portions of Date-Time object
Having some issues with date-time objects and could use some guidance. I've retrieved a timestamp from a module, in this case the "Created Time" timestamp. The timestamp variable returns true for isDate(), but when I attempt to use .getHour(), .getMinutes()
Creating a data entry table form
Hi I was wondering if Zoho Creator allows to create tables for data entry instead of just single line and multi line in the form builder. For example the highlighted cells below represents the cells to be entered. Regards
Send Mail | Insert Code | How to use it? What's it for?
Hi All, After a few hours of web searching, I'm struggling to figure out how to use the insert code feature in send mail. I'm trying to create a dynamic reference code based on the current year. If the year is 2023 then the code would be DEPOSIT23. Next
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/
Next Page