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
OnSubmit workflow won't run when record is added with ;insert into' through another form?
Form A has a workflow that triggers on successful form submission but most of the time, records are added with an insert into function in a different form. Should the workflow for on successful form submission still work if records are being added this
Zoho Channel/Reseller Portal
Does anyone know is there a good package available that is built on Zoho for managing channel partners (deal registration, support tickets, Marketing document access, and a dashboard)? I would be open to Zoho but their portals seem very limited and can't
Creator theme menu levels possible?
Hey, Is there a way to get a second level to the menu structures in zoho creator? I have too many tabs to fit on screen and too many views already in the tabs I have. i could easily have 25+ views and forms in an admin tab but they would stretch well beyond the page limits. How can I add a second level of menus? Currently it seems I can only do 2 levels. For example Admin Parts Part ID Part Categories Users Rolls .. and 30 some odd other admin related items.
Hide 'Add' button on a report
Hi All I have created a report using the summary view for use as a settings page, where I have added decision boxes for things like notifying users by email when a record has ben added. If the field is checked, an IF statement checks the condition of the decision box before sending the email (email is sent if decisionbox is true/not sent if decision box is false). I have limited the number of records in the report to one, however, my question is, can i disable or hide the blue 'Add' button on the
Sample code for passing parameter to a widget. And code for fetching record in a look up field.
Hi! Im trying to create a widget but I didnt know how I can pass paremeter? There isnt much documentation avaialable? If I have the widget in a page and this page has parameter. How can I pass it to the widget? Also how can I get record from a look up
Is it possible to disable add entry feature when clicking on date grid in calendar report
Hi, I am having a calendar report. The event records are added using deluge to the form associated with the calendar report. Basically, I want to use the calendar report only for viewing. But, clicking on the date grid brings up the corresponding add
Zoho Developer Creator Privately Published app, cannot remove clients?
When creating an app through the creator developer space and publishing it privately to a client, is there no way to remove clients? View clients from the developer dash shows the clients but no way to remove them? Deleting the app to effectively “remove”
Conditional script for whether a user is currently logged in
I have a table in my app that holds records my organization's users. I want to write a function that will set an Available field to false if they are logged out, and to true if they are logged in. Is there some way for me to do this in deluge?
Multiple Instances of the Same Application
Can I have multiple instances of the same application and update each one from a master application. For example I build an application called Test, I know I can duplicate that application, let's say I create two copies called Cust1 and Cust2. Cust1 and Cust2 are now used and data is entered by my users into these two applications. I continue to develop the Test app with new tables, new views, charts etc. Now I want to copy these updates to Cust1 and Cust2 - how do I do that?
Make A Different Row for each Multi-Select Item Selected/Submitted
I'm trying to get each item selected in a Multi-Select field added to a record, but have each selection be it's own row on the spreadsheet instead of all the selections be inserted into one row as a list. What can I do to achieve this? Thanks
Error message
I am trying to add field actions to the ORDER_TYPE field in the NEW TELCO ORDER form at https://creator.zoho.com/essistmgmt/form/1696/scriptbuilder. I have tried in both the old & new script editor When I add some code, I get the following error Error at line number : 10 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression When I remove the new code & try to save, I still get the error It relates to this row of code if (input.ORDER_TYPE != null) Why am
Fetch data from form and put in list !?
I want to fetch all the data in a form and put it in a list (or array) for further handeling. How can this be done easily? "Values = FormName" That only give a list of ID's for each row, not containing the actual values stored in form. An alternative is to make a loop with For each x in Values ...., That seam like a lot of work for something there might be a function for. Any suggestions, something similar to toJSONlist() or other? Thanks, Larry
Deluge script for inserting url into image field
I want to insert a url in an image field, looking like this test value record.photo="<a href='https://www.google.com/images/branding/googlelogo/2x/googlelogo_color_92x30dp.png' target='_blank' title='test'>Test</href>"; The value is inserted into the table with the script with this line: photo="<a href='https://www.google.com/images/branding/googlelogo/2x/googlelogo_color_92x30dp.png' target='_blank' title='test'>Test</href>" I'm using a custom script for this. The script itself runs without errors
Form fields in an email are not popultaing
Hi all, I am having a bit of a problem with form fields not populating when I send emails. I have the following code that runs when a form is submitted: from :zoho. to :zoho.adminuserid bcc :EmailAdd subject :"New Production Added" message :"<div>A new
Reducing Image File Size Using On Added or On Edit Deluge Script
Is there currently a way to reduce the size of an image upon upload using deluge script? If not, is this something being considered for the future?
Function specified in criteria has returned null value and it cannot be evaluated
Im trying to evaluate if a variable is null. It doesnt matter if i use .isBlank() or .isNull() the line always returns: "value cannot be evaluated". I dont know how to handle this type of scenario. Error: Function specified in criteria has returned null
Single select dropdown field to match selections from a multiselect lookup field
Is it possible to input the selections from a multi-select look-up field to be the only choices available in another field (single select dropdown field). Please see the below image for further explanation.
Next Page