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
Access token rate limit issue
We are using Zoho Creator API to retrieve data using the Data API. We have a large number of reports and running into rate limits for access tokens. Since we use serverless processes, we can not share memory across multiple runs. So we retrieve a token
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
How to update zoho creator record ( a look up field) through widgets - js api?
Can I ask help how to update a record with a look up field from a widget using JS API? I get to fetch value of look up field using the code below. But I'm not sure how to update the record in creator when user selected a different option from the dropdown.
Zoho Creator Upcoming Updates - December 2023
Hello all! 2023 proved to be an action-packed year for us at Zoho Creator. Riding that momentum, we're geared up to conclude the year with a bang! Here are this month's top highlights: Zia Assistant powered by OpenAI Custom APIs Support ticket tracker
Zoho Creator - [Free Webinar]Learning Table Series for Media
Hello Everyone! For the month of December - Bringing on to your table - Zoho Creator for Media 12 Months 12 Industries Media Industry The media industry is an ever-evolving and influential force that includes journalism, entertainment, advertising, and
Ability to access Zoho Creator Success/Failure Logs programmatically, via Deluge
It would be great to have an ability to access logs programmatically. Currently I am manually checking logs every day to ensure I pick up any errors and bugs. I would like to be able to automatically iterate and check those via Deluge on schedule. In
OnSubmit workflow won't run when record is added with ;insert into' through another form?
Form A has a workflow that triggers on successful form submission but most of the time, records are added with an insert into function in a different form. Should the workflow for on successful form submission still work if records are being added this
Zoho Channel/Reseller Portal
Does anyone know is there a good package available that is built on Zoho for managing channel partners (deal registration, support tickets, Marketing document access, and a dashboard)? I would be open to Zoho but their portals seem very limited and can't
Multiple user updating inventory qty with deluge
Hi all, i have a scenario below I have a inventory product A with qty 10 and there are three users submit their order at the same time. user A ordered 10 user B ordered 10 user C ordered 10 i have script on validate to check if the qty goes less than
Are dynamic images in a record template possible?
Hi there, My challenge is getting an image of a signature in a contract which is build up using variables. The signature is variable as well, based on the issuer of the contract. The signature are stored on external website, but I also added an image
Is there a way to invoke deluge function from within a widget?
Hi! I have custom functions in deluge and I was wondering whether there is any way to call this function through a widget? Something like on click of a button inside a widget, run the deluge custom function. Would this be possible?
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
record_cursor
I'm working on api call using the v2.1 api. When I use record_cursor in the header to get the next set of records, the returned call is ignoring the field_config: custom and fields: {field} parameters. This behaves the same in both Postman and my sc
Display image on form
how to insert image on a form, the image field only allows for upload of images.
Creator theme menu levels possible?
Hey, Is there a way to get a second level to the menu structures in zoho creator? I have too many tabs to fit on screen and too many views already in the tabs I have. i could easily have 25+ views and forms in an admin tab but they would stretch well beyond the page limits. How can I add a second level of menus? Currently it seems I can only do 2 levels. For example Admin Parts Part ID Part Categories Users Rolls .. and 30 some odd other admin related items.
Create hierarchy chart?
Is it possible to create a organizational chart based upon records in Creator? I would like to do this using a "Manager" field.
Hide 'Add' button on a report
Hi All I have created a report using the summary view for use as a settings page, where I have added decision boxes for things like notifying users by email when a record has ben added. If the field is checked, an IF statement checks the condition of the decision box before sending the email (email is sent if decisionbox is true/not sent if decision box is false). I have limited the number of records in the report to one, however, my question is, can i disable or hide the blue 'Add' button on the
Tip #25: How to add background images to forms
Hi everyone, The world is going through a difficult time right now, and we hope you're all staying safe. We're here with another Creator tip—this time on how to add background images to your forms. Sometimes, to add some context or make your forms look a little better, you may want to add a background color or an image to your form. Let's go over the three easy steps it takes to get the job done. Use case In this example, we have a New Order form, and we'd like to add the company's logo to it, to help establish better
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
Sample code for passing parameter to a widget. And code for fetching record in a look up field.
Hi! Im trying to create a widget but I didnt know how I can pass paremeter? There isnt much documentation avaialable? If I have the widget in a page and this page has parameter. How can I pass it to the widget? Also how can I get record from a look up
Pause(1);
I'm using scheduler to invoke an interaction via http post with an external service. The schedule code uses a for-each loop that runs so fast my external application's log files get messed-up (they are named by date-time stamp). What I'm suggesting is
Zoho Creator Upcoming Updates — February 2023
Hello all! A very happy new year to all of you! We're back with the very first monthly update of the year! Your support has made Creator's journey in 2022 both momentous and remarkable, and we'll be striving hard to make sure 2023 is even more incredible.
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!
Rename the attachment from record template pdf in the sendmail deluge script
Hello Zoho, I urgently need a feature to rename record templates that I send via the sendmail feature. The program I created sends emails to clients with an invoices that have been created in the invoice database. If the user selects 3 invoice numbers,
Feature request: Zoho Creator - Zoho Writer integration for mail merge
Hi, I've set up a purchase order template on Zoho Writer and I want to have the fields in my template linked to the fields in a report in Zoho Creator. So far I was only able to achieve this by exporting a CSV file from ZC and importing it into ZW through mail merge. Is there anyway to automate this process? Will Zoho consider integrating both apps?
Is it possible to disable add entry feature when clicking on date grid in calendar report
Hi, I am having a calendar report. The event records are added using deluge to the form associated with the calendar report. Basically, I want to use the calendar report only for viewing. But, clicking on the date grid brings up the corresponding add
postURL - Error due to - 'Internal Exception'
Good day, I created a function that makes a simple postURL call to our API without authentication. It works using Postman but I get Error due to - 'Internal Exception' in Zoho Here's my code : HeaderMap = Map(); HeaderMap.put("content-type","application/x-www-form-urlencoded"); param = Map(); param.put("param","test"); url = "https://zoho-teleopti.tpcc-trim.com/api/Zoho/post"; result = postUrl(url,param,HeaderMap,false); info result;
Zoho Developer Creator Privately Published app, cannot remove clients?
When creating an app through the creator developer space and publishing it privately to a client, is there no way to remove clients? View clients from the developer dash shows the clients but no way to remove them? Deleting the app to effectively “remove”
Conditional script for whether a user is currently logged in
I have a table in my app that holds records my organization's users. I want to write a function that will set an Available field to false if they are logged out, and to true if they are logged in. Is there some way for me to do this in deluge?
Get form name?
Hi Zoho, Is there a way to get a form name (to be used in the "On Success" script)? Something like the formdata function, but for the form name... Thanks! Ravid
Zoho Creator Upcoming Updates - October 2023
Hello all! As we step into the final quarter of this year, we're ushering in a fresh wave of improvements and new features to supercharge your experience with Zoho Creator. Join us today as we present the newest updates and enhancements for this month:
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
Zoho Creator - 2023 Release Projection 1
Hello everyone! A very Happy New Year to you and your family. Hope you're all good and having a great time using Zoho Creator to make your lives easier and your businesses prosper. 2022 was an action-packed year for us at Creator, and we hope to continue
How can I transfer data from Production to Development environment?
Hi, I am using Creator V6 and would like to bring all the data in production to the Development and Testing environments? Is there an easy way of doing that or I have to export and import each table?
Multiple Instances of the Same Application
Can I have multiple instances of the same application and update each one from a master application. For example I build an application called Test, I know I can duplicate that application, let's say I create two copies called Cust1 and Cust2. Cust1 and Cust2 are now used and data is entered by my users into these two applications. I continue to develop the Test app with new tables, new views, charts etc. Now I want to copy these updates to Cust1 and Cust2 - how do I do that?
Make A Different Row for each Multi-Select Item Selected/Submitted
I'm trying to get each item selected in a Multi-Select field added to a record, but have each selection be it's own row on the spreadsheet instead of all the selections be inserted into one row as a list. What can I do to achieve this? Thanks
Error message
I am trying to add field actions to the ORDER_TYPE field in the NEW TELCO ORDER form at https://creator.zoho.com/essistmgmt/form/1696/scriptbuilder. I have tried in both the old & new script editor When I add some code, I get the following error Error at line number : 10 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression When I remove the new code & try to save, I still get the error It relates to this row of code if (input.ORDER_TYPE != null) Why am
Next Page