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
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
Age Calculation
I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.
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
Zoho Creator : Updating Records via Import. Can't use Autonumber or ZohoRecordID ?
Hi, I am trying to use the function to update a report with an import. I'm running in to the error : "unable to update because the form has no column with unique values" In the release notes it says Only field with unique values can be used to compare
Multiple images
Hi Is there a way to insert multiple images in one image record or any way that instead of one image, I could upload 5 to 10 images together. Looking forward for a solution. Regards
Global variables in Deluge
2023 Release Projection 1 announced Global variables in Deluge for Q1. Was it released?
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
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?
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