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?
Nested Sub-forms (Subform within subform)
Hi Team, Whether there is any possibilities to add sub-form with in another sub-form like Main Form -> Sub form A ->Sub form B If we tried this, only one level of sub form only working. Any one having any idea about this? Thanks Selvamuthukumar R
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]
update new field to a default value on old records
Hi, I would like to add a new field to my forms and automatically update it to a default value on my old, previously created records. I have 100 clients, and I would like to add a flag field on all of them to a default value of "NO", retroactively to all of my clients. I know there is a way to do so without a loop - by using the "required field" functionality. Somehow it worked for me a few months ago, and the fields were well updated. I don't know why, it doesn't work anymore. How do I do
How To Create A JSON Request With More Than One Array Element?
Hi, I am using the postURL functionality. JSON Request body contains more than one array element like shown below, Original JSON Request Body Format To Be Used: { "Name": "Hello World", "Roles": [ { "Profile": "asdf", } ], "Description": "sent" } This is my code used for creating above JSON request using "map()" functionality, myMapData = map(); myMapData.put("Name", "Hello World"); myMapData.put("Description", "sent"); // I used the following code for creating "Roles"
Dynamically set allowed days for a date field
Greetings! Is there a way to dynamically set allowed days for a date field? My application includes a scheduling tool that I need to control what days of the week can be selected based on availability in a provided zip code. For example: Dispatch Calendar:
Another IP blocked by Spamhaus.
Hi, In addition to my other ticket about Spamhaus, the below different IP is also blocked. Our project launces very soon and the sending of scheduled emails it important to the project. Can you please advise? Reason: uncategorized-bounce Message: 5.7.1
How image in a published page show up to external users (when they view the page using the page permalink)
Hi. I have created a page in Zoho creator. This page contains zml snippet which contains line of code for displaying product images from a particular report. What is the syntax I need to use in order for the external users to view these images inside
getting invalid client
getting invalid client
Lookup field in iOS has no search ability
I have a simple form with a lookup field. When I access the form with my iPhone or iPad, the lookup has no search mechanism. It just disappeared! Strangely, when I access the form with another phone using Android, the search appears. Again with my iPhone,
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
Next Page