How to store auth credentials
Hi I have a Creator project with an external service I use through API with key and secret for auth. I store them in the app variables but not sure it's best practice. Tried on microservices custom connectors but the service requires the key and secret
Assistance Required for printing multiple Barcodes on a single sheet of paper.
Dear Zoho Support Team, I am currently working on a project within Zoho Creator where I need to generate and print a series of barcodes on A4-sized paper. Use Case Details: I need to generate barcodes specific dimensions (Xcm x Ycm) and a margin (Zcm)
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
Receiving "API request's body is either missing or incomplete." error
Hi, I am attempting to call the Creator API V2 Delete Records function from a CRM function and receiving the error " {"code":3020,"message":"API request's body is either missing or incomplete."}". Below is a code snippet with some URL variables removed:
Handwriting field
Hi all, Do you think this is possible in Zoho Creator in the future? There is a use case that people like to take a quick short note (using S-Pen, Apple pencil, etc.) in the application instead of typing in a tablet. In the era of AI, it more better that
Zoho Creator - [Free Webinar] Creator TechConnect Series - Custom widget/extension concepts - Part 1
Hello Everyone! About Creator TechConnect Series The Creator TechConnect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into key essentials and technical nuances while building
Creator Email on Submit- dynamic content?
Hi, I have created a stateless form with custom reports etc. There's a bunch of custom fields for one customer that I do not want sent to other customers, and these are hidden in the forms for people who don't need them when being filled out. Example-
Is there a list of Zoho Icons?
Is there a list of Zoho Icons you can reference: i.e. business-gold is <image marginRight='7px' color='#2A70E7' bgColor='#FFFFFF' width='52px' height='52px' type='icon' value='business-gold' size='24px' cornerRadius='26px' iconType='solid' /> Thanks!
Is there a way for Deluge to get the ID of a record submitted via insert into FORM_NAME
Is there a way for Deluge to get the ID of a record submitted via insert into FORM_NAME? i.e. I have: insert into Work_Order [ Added_User = zoho.loginuser Work_Order_ID = issueID ] I'd like to get back the ID of the record created so I can use it in the
On Load Action
Hi Everyone., I hope you are well I have a subform that has a "Total" Field that gets filled in on Load of the form. I have a "profit" field that calculates "Total" less "Deductions" . I have tried adding the formula for "Profit" on Load as wll but it
Implementing Oauth 2.0 for google API
I'm trying to access a Google API and need to use Oauth 2.0 to do so. I think I can use posturl to request the authorization code, but Oauth 2.0 requires a Callback url to send it to. How can I do this? Thanks Joe
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
Required Date Format dd-mm-yyyy
Hi I have a requirment where i need to send date format in API , and the format is dd-mm-yyyy. Is there any default date function which can give the date exactly in this format, i couldnt find any. Instead i tried to get date, month, year separately and
Side Menu Bar Hide / Show Option
Hi, How to hide/ show side Menu Bar??
Timeout in invoke URL SOAP request
I have a quite big XML to send through a SOAP request. Initially, this works fine when starting small (30 orderlines instead of 100 orderlines) but when scaling up, I get a timeout because the timeout limit of the API call is 40 seconds in Zoho deluge.
How to convert string to byte array
How to convert string to byte array : I want to convert string to byte array and but i can't find any option for conversion. I got array type in deluge script like list but byte datatype not found. Any one have this question answer then reply me ASAP.
Error at null with error.message or error.lineNo in workflows
All my code was working fine and try catch was fine but I want to match on users uploading too large of files since they're manipulated in deluge so I went to access the error message and am unable to save with an error at null warning. I started by cutting
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
Signature Field Issues on Mobile IOS and ANDROID APPS
1. I've been going back and forth with support about this, but as it stands, there is NO way to test if a signature field was filled or not out in deluge. I've tried everything, and I am getting silence from zoho support. 2. This is even worse problem on mobile, the signature fields do not commit to database if you are not an ADMIN user and you are using mobile app. you must have changed something in the code around the time you made signature pads bigger for the IOS and android devices, because
recordCursor not updating in V2 Bulk read download/result endpoint
Hello- I'm making calls to the V2 API using the bulk read on a report that's got over 1 million records in it. I'm able to successfully request, check status and download the first batch of records. The response object header in the first batch comes
[Free Webinar]Learning Table Series - Creator for the Retail Industry
Hello Everyone! The first step is the most important part of any endeavour—and with this fresh start to the year, we're elevating the Learning Table Series to new heights. Here's to more shared success in 2024! 12 months, 12 industries The Learning Table
Zoho Creator User Group meetups in APAC!
Greetings from the Zoho Creator team! We're excited to announce that we're hosting a series of Zoho Creator meetups in various cities across the Asia Pacific region. We invite you to join us for an exciting day of learning and fun. Our meetups are a great
Getting Duplicate record for only one value in label generator
Hello all, We have created a Label generator in Zoho Creator. The problem we are facing is a duplicate of a record for generating one label. If I have more than one label I won't get duplicate records. I want one record with one label to be generated.
Deluge script to change currency field's currency dynamically on form
Hi, I have a currency selection field based on which I would like to change another the field's currency. For eg I have 2 currencies say HKD and AUD and an amount field of type currency set to AUD (by default) wherein the user can input amount. So if a user selects HKD then I want to change the currency field to HKD from AUD for the amount field. Can this be done? If not what is the best solution. -Nitin
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
Variable not define
I would like some help with the following Deluge code that comes back with error " Variable not defined" if(row.Type_of_currentcy.Type_of_currentcy.contains("HT")) { row.Total_Resquest=row.Total_Price /Advance_Exchange_Rate; } The field "Type of currency"
Bug with dates and toString function?
I'm having a strange bug with my app that happens specifically when applying the toString function to the dates December 30, 2018 or December 31, 2018 the year is changed to 2019. It happens only with those two dates, any other date works fine, anyone else having this problem? It's breaking my app's functionality for today and tomorrow. Try this on any form OnLoad: alert now.toString("YYYY-MM-dd"); I'm getting today's date but with 2019 as year.
Urgent! - Error:7202 - Provided authentication token is invalid.
Hi, Yesterday, our Zoho Creator forms were working fine, but today we are facing an error on the following line: employeeRecords = zoho.people.getRecords("P_Employee",1,200); And the error is the following: {"code":7202,"message":"Provided authentication
Zoho Creator : Paint your records using Canvas Builder!
Dear Creators, We're thrilled to bring you an incredible new feature - the Canvas Builder, the solution that directly addresses the "user experience factor"! This cutting-edge tool is live now, and we are delighted to share how this feature will revolutionize
Sorting datasets from 3rd party
Hi there, I am getting data from a 3rd party like this: for each supplier in supplierList { listData.add({"name":supplier.getJSON("supplierName"),"sku":supplier.getJSON("supplierSKU"),"stock":supplier.getJSON("stock"),"status":supplier.getJSON("stockStatusText"),"rate":supplier.getJSON("price")});
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
Cancel Button Not working when editing a form opened from openUrl
I have a custom function to edit a form which I use in a button on a related report. It uses the "openUrl" task to open the form with the correct record id, and it sets up the View Link and and Next URL. Here is what that URL looks like: https://app.zohocreator.com/myloginid/myappname/#Form:Record_To_Edit?recLinkID=3208680000009414047&viewLinkName=Record_To_Edit_Report&zc_NextUrl=#Record_To_Edit_Report
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
Auto Filter Report Based on Action from a Page
Hi guys, Just wondering, are there any functions in Zoho Creator that enables us to open up a report but with a specific filter based on the action that we chose in a page? For example, for the same report, if I put in an action on a button to specify
New Time Field
Hi, The new time field is very useful for us. But i don't seem to be able to use it in a graph to show a total or in a page to show a total because its not a number field. Have i missed something or cannot this not be done? Many thanks
Definition of formula field by deluge
Hello everyone, first happy new year to all community members! Could you please help me with the script how I can define a formula field in a form. This form is for collecting data from general ledger. Data are uploaded (imported) regularly. I want to
Sage 50 Work Ticket process to Creator
We are currently using Sage 50 as our company accounting software, but we are in the process of migrating everything to Zoho for consolidation. Sage 50 has a work ticket process, which is crucial for our assembly and manufacturing operations. We urgently
Condition to Execute Deluge Script on Every Row of a Subform
Hi there, I am currently creating an expense request form that my employees can submit for their expenses. In the form, I created a Subform so that my employees can add multiple entries for their expenses. The thing is, our company's policy is to only
Zoho Creator Upcoming Updates - November 2023
Hello all! Improvement is a constant pursuit at Zoho Creator, and we're excited to bring you the latest developments and progress in our journey. Let's look at the features you can expect this month: Schedules settings in environments Image compression
Next Page