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)
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 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
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
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
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
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
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")});
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
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
Create an html button in an html snippet that will invoke a function
On a Page, is there a way to create a button in an html snippet that will invoke a function?
Get Form Access
Hi all , Im working on zoho creator for month , i had a problem in report generating with the count of data in the record submission,I can get choices from record with submitted data but i need show the un submitted choices in the radio fields to the
Add items to dropdown list as new records are added
I would like to add items to a drop-down list as new records are added to my database, as follows: 1. Start entering new record 2. Is the value I want in the drop-down list? If so, select it. If not, select 'Other' and type it in 3. Save record 4. Go to add new record. Click on drop-down list and see the item that I entered in step 2, along with the ones that were there previously. Is that possible? Thanks, Jon.
Converting numbers to text
Dear all, I was trying to convert such an amount to a text string but I couldnt figure it out. Can you please guide me step by step how to handle it? Regards, Nafe
Duplication Bringing Lookup Linked Records to New Record
Hi All I have a form that is essentially a schedule of courses and dates (which displays these courses on a calendar). I then have a booking form that has a lookup field that is populated with the record ID of the selected course date. This enables me
Integrate SalesIQ into Zoho Creator App
Hi, How can i do that? Or what other possibles do u know to put a chat in a zoho creator page o portal customer?
PDF TO DATA BASE
Hi I am have a PDF document received from a bank and once i upload it in zoho creator i want the data to be stored in the data base . Is there any way to do it
Sub form unique entries for specific colum and filtering drop down list.
I have a sub form. One of the fields is a drop down list. I want users to only be able to add a new row with a unique value selected in the drop down list. Ex: Drop down list contains: Red Blue Green A user can add a new record to sub form but can only add Red, Blue, and Green once. For example, they could not add multiple sub form records with Red selected in drop down. I'm just not sure how to check to see if another record has already been added and prevent selecting the same drop down value.
FETCH DATA FROM SUBFORM TO FORM
Hello, I have the form named "Loan application", and another form "Client's transactions" hosting sub form named "Group members." Loan application form has the field called "Account Number" and a sub form "Group Members" has the field called "Account."
How to update image in a Zoho Creator report through widgets (JS API)
I need help with how to transfer an image file from one report to another in Zoho Creator using widgets (JS API). Say I'm fetching a record from the All_Products report. And this report contains a Product_Image field. I then want to transfer this Product_Image
Make a link between 2 reports
Hello, I have 2 search values in my report, one is linked with the target (customer) but the other search value (offer) is not linked with his target. Is there is something special to do to make a link on all the search values ? Thx
How to compare old value and new value on Create/Edit Record
I have a custom module[Project], there is a Lookup Field[Contacts]. I want to change more than 10 Fields from [Contacts] Fields to custom module[Project] Fields when the Contact ID changed. I try to use Automation Workflow Rules Function whenever a [Project]
Next Page