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
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."
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,
Pass values from stateless form into function
I have a function w/ a list of dates and a list of strings that populates a bunch of data in form1 - it works when executed. I want to use statelessForm inputs dateField and dropDown to populate dateList and genreList in the below function and run it.
Is this hacky solution for admin filtering records in a report safe?
Portal users need to be able to see and edit some records other portal users create. Admins should be able to see and edit all records. I haven't seen any solution that doesn't involve adding some field to every form that is some kind of admin check.
success message <expression>,<duration>
Hello, I created a Auto Number field to let system auto create a unique number for each record created in a form. Is it possible to a) display this auto generated number at the time user is entering the record, or if not possible b) allow to show to user the auto number within the Success Message once user clicks on Submit button. Your assistance is much appreciated.
Retrieving value from inventory API getRecord gives null
Hi all, I have an issue with my platform I am building. I would like to fetch a list of all my sales orders that are pending shipment from zoho inventory into zoho creator as a list. This is my code for now. When running the script, i get a null value
problem exporting/reporting on Rich Text fields
I have a view based on a form that contains a rich text field. Works fine for editing in the form, but all export options for the corresponding view (PDF, XLS etc.) show embedded html in the text, things like <BR> for line breaks and for spaces. I cannot produce proper output from this view and that is a huge problem! I could convert the field to multiline plain text without a huge loss of functionality, but it's my understanding that Zoho would throw away the data in doing so. That is
Error in syntax parser involving invokeUrl and workdrive upload file
I wasted way too much time and haven't even bothered to get this working yet but it all should be simple after debugging this issue. I see literally no different results between the two syntaxes and have seen no one else talk about this issue but it just
Timing on Success Message
Is there a way to edit the length the success message stays up after a user submits the form? It disappears in about 3 seconds. please let me know if there is a solution for this.
Zoho Creator - [Free Webinar] Creator Tech Connect - Release Update Series - Part 3 - 2023
Hello Everyone, We are constantly working towards the platform features to optimise the user experience and to increase the value of the product. As always, our utmost precedence has always been on educating and keeping the users informed about newly
Change Label Name with script
Hello everyone, Is there a way to change the Label Name with script?? I would like to have the option to change the language of the application, so I was thinking if this could be done? Besides that, is there a way to know the user that is Sign In? Because I could automate the language function if the principal question were responded. Thank you very much for your help and sorry for my grammar English errors.
Zoho Forms: "Save Progress" or "Continue Later" ability
So I've created a rather long form that could take some time to fill out. Is there a way the user can save their progress and come back to their work later? I know it's possible for Zoho Survey (https://help.zoho.com/portal/en/community/topic/can-zoho-save-progress-and-continue-later) but couldn't find a way to make it work for my form. Does anyone know whether or not it is possible? Thank you!
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
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
How to connect to the Braintree API from creator?
I'm attempting to connect to the Braintree API from deluge and I'm having some problems. I'm trying to use Braintree's graphql to do this. https://graphql.braintreepayments.com/guides/making_api_calls/ I'm able to set up a basic query but I'm having
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.
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
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
Next Page