How to get ID of item after being redirected to a new form using a button
Hello, I am new to Zoho Creator and Deluge script, hoping for some assistance. I have created a report where I added a "Notes" button. I have created a workflow where the "Notes" button should redirect me to a new form below. My question is how can I
Merging Ticket upon successful submission of the form
Hi Zoho Team, Requesting you assistance again. I'm creating an automation workflow that on every successful form submission, the email notif will send to Desk then merge the created ticket. I came across to this command: zoho.desk.ticket.merge My code
How to return the content of a Lookup field rather than the ID
I wish to use Setvariable using the content from a lookup field but i am only getting the ID. A method? Gosh I wish there was some really basic resource with lots of examples to facilitate learning Deluge . Deluge for Dummies - I like the alliteration.
External CSS. Is it possible to <link> to external CSS from a HTML View?
External CSS. Is it possible to <link> to external CSS from a HTML View?
How to pass dynamic parameters directly in the publish url zoho creator.
Hello I need some help. I am publishing a page. When I publish a page it ask for parameter which I had define in Page argument. When i pass Hardcore value it show its published page preview. But When I pass parameters like input.id and so on. It shows an error in preview. Please tell me how can i pass parameters value during publishing my page.
change to Title case
Is there a way to change the case of a field to Title case? I found the deluge functions toLowercase and to Uppercase. But I have for example a Town or Name fields that always need to start with a capital, i.e. titlecase. If not available yet, please make it a feature request. Would be very useful. Both as a deluge function and as a field feature that will auto-correct on add or update.
Does Zoho creator has any Upsert functionality ?
Hi I have requirement where I need to update the record if data already exists in database, else if data not there then only create new record. Can anyone suggest the solution. Thanks
Create new record if Form has subforms. Is it possible with Deluge only to create/insert a new record if the form it is based on has a subform? No UI form involved
I'm trying to transfer records from an old application to a new one, so I am creating a function that can iterate over the records in the old application and create them in the new one. The target form has several subform fields (some are lookups but
Zoho Creator Shortcuts
In 2023, Zoho Creator will be getting a lot of new features. Like Canvas and the advanced Deluge Editor, which will improve Zoho Creator's functionality and give developers a fresh experience. I'll shed some light on shortcuts so that you can utilise
Form Name and Form Link Name cannot be changes
Hello, I am going through my existing application and cleaning up some of the Form Names and Form Links to make them more consistent and organized. I was able to change the form name for most of my forms, except for one. On one of the forms, when I click
Portal permissions
I have recently adapted the Fleet Hub Management app within Creator for our team to use. I have locked down certain parts of the app for the Admin only to have access to and have created a separate profile for drivers (Zoho One users) to use which only
Amount round off
I have a two fields : 1. Total Amout[Single Line],which will fetch from master as "INR 300" 2. Paying Amount[Decimal line],which the user will enter in form. I can validate if both the values or not same. But I can't validate the decimal amount in Total
Expected data type BIGINT found dataType STRING
I have an application where i have a drop down field where the options are numbers 1 to 5, a current date field and a return date field, what i want to do is add the number of days selected plus the current date field and set them as the return date date field. I had success using the addDay function and a static number This works: ReturnDate = input.Delivery_Date.addDay(3); input.Return_Date = ReturnDate.toDate(); However because i need to use a dynamic number based off a field what i actually
Deluge access to profile/personal information/full name
Using Deluge, how can I retrieve a user's full name from his/her profile?
Auto populate record on a sub-form
Hi Zoho Team. Requesting for your help regarding on this issue. The workflow that I've made supposedly will auto-populate record base on user-input of a field under a sub form however, it will only work on the 1st row entry but when I try to add new,
Zoho Sheet in Creator
How can display one or more of my zoho sheets as part of my zoho creator application? Thanks in advance.
Returning collection from function -- need to access field value before returning, otherwise empty?
I have a function in appA that returns a collection. In appB I am executing the function and attempting to read the values from the fields. If I simply iterate over the records and insert then into the return collection, when I try to read the field values
Nice way to persist params across page changes & note about hash URL's.
Zoho Creator uses Javascript's hashchange event, window.addEventListener("hashchange") or $(window).bind("hashchange"), to perform actions when a url's hash is updated. When a link like <a href="#View:my_view">My link</a> is clicked the window's hash is updated triggering the hashchange event. Then ZC uses AJAX to load in the html for the desired view. (Obviously not in view-perma mode). Anyways, usually you see demos of params being added to urls like so.. http://creator.zoho.com/zoho.adminuser/zoho.appname/#View:testing?param1=testing¶m2=testing
Recalculate every row in the subform
Hello, Can anyone help me with a script, please? I have an issue. Sometimes it happens, that in a multi row subform one of the rows show an incorrect row total value. Not really understand how it can happen, if I have a 20 row subform, 19 rows show correct
Reducing lag caused by workflows
Workflows have caused a considerable lag in one of my applications. I would love to hear feedback about how people are resolving such issues. The app is being used to manage security camera orders. The main form is an order form, and I have a subform
Loop through a list of fields
Hi there, I was wondering if there is a way to create a list variable of field names and then loop through them? Something like this... rstypes = typesfrm [ID == input.Bid_ID]; x=List(rstypes.supplieschk,rstypes.furniturechk,rstypes.ITchk,rstypes.staffchk); for each y in x { if(y==true) {show y;} else {hide y; y.clear();} } Regards, Will
I keep getting this Error message
Error details: Error in executing On User Input script of the field, Items. Null value occurred while performing Addition operation. Line:(18) this is my script. it will be something simple i know //Link the Item_Name field in subform to the Item_name field in Items Form; selected_item = Items[ID = row.Item_name]; //Set the quantity of the selected product to 1 by default, if no quantity is declared if(row.Quantity = null) { row.Quantity=1; } if(row.Quantity > selected_item.Quantity) { alert "Please
Footer in PDF template doesn't stay at the bottom of the page
When setting up a PDF template there is an option for a header / footer. The header stays at the top of the page however the footer does not. It appears the footer actually serves no purpose as it seems to rise up to underneath the header (see image). Is there a way to lock the footer to the bottom of the page? Otherwise what is the point of it? Image demonstrating what I mean. https://ibb.co/cJY1xZ4
Clearing Input Fields if Ticket not Found
Hi Zoho Team, Requesting again for your insights/tips for the workflow that I have made recently here's the code: I'm still new to deluge and Zoho API so I need some help here. Since our team has multiple department and what I'm trying to achieve here
Calendar view and .ics file in Email
Hello to the community, Using Zoho Creator with the Calendar Report posisibility, I'm wondering if someone can tell me how to send an Email containing an .ics file with the necessary data to integrate it in the recipient's calendar. I know how to send
Zoho creator updates field Zoho CRM
Hello In Zoho Creator we make a report and select an Account (that comes from the Zoho CRM) by a lookup field. We have a picklist field below with 3 options "Account Status" When we select an option in the "Account Status" it's important that this option
showing popup/modal on a form
Greetings i was wondering if there was a way to create a customized popup/modal and be able to show it on a form using some sort of button triggers or so. i'm having a form where i want to include explanations and instructions on how to fill it and i
Possibility of having version control for stored records
Greetings I was wondering if it was possible to have version control for records, something similar to the version control we have over deluge functions but for stored records. basically if a user edits/updates any record they would be able to view older
Search for Ticket Number then populate fields
Hi Zoho Team, I would like to verify if this code is possible or what could have gone wrong. What I'm trying to achieve here is to create a report that the user only inputs a ticket number then if record from desk was found, records will then be populated
splitting form in 2 columns makes fields and notes fields between the columns asymmetric
Greetings I'm working on a form where i need to show some explanatory text next to each form field, i did that by having a note field right next to each form field splitting the form into 2 columns which looked like what i want in the form builder (image
What is the "backend" or server side database for Zoho Creator?
Is it a common SQL database or a special home-grown one? I am wondering about the ability to take a database from another place and put it on Creator or even taking a database designed in Zoho Creator and migrating it to another DB. Brent Jones, in Oak Park, IL USA
Report summary header and footer??
Hi there! I´m building a report summary to export as PDF. I had set up the page size as A4 and enabled the header and footer. But when the pdf is exported, instead of puting the header and footer on every page, it just puts the header at the beginning of the first page and the footer at the end of the last page... How can i make them to apear as header and footer of every page??? Tanks!! =D
The new Creator 6 - How to migrate?
Greetings, I hope find all well and safe! Last days I have seen some social media posts about Creator 6, from Zoho, as an example this website link: https://www.zoho.com/creator/whatsnew/creator6.html But when I log in to my account (inside Zoho One)
[Suggestion] Visual indicator of comments in report
To enhance the usability of comments, it would be very usefull to display a message icon for each records in reports. This way, users can be sure to know that this specific records might have more relevant information in the comment section. Not urgent,
How to input all values from a Fetch Record and return to a Multi Line field
Hello Everyone, I'm having an issue I can't understand. This formula is working. The info statement shows me that all the proper records were retrieved and can be returned. for each r in Workout_Tracking[Single_Exercise_field == varSW] { input.test_report_text
Zoho Creator - [Free Webinar] Creator Tech Connect - JavaScript Widgets in Zoho Creator - An Extensive Outlook
Hello Everyone! Gear up for our next session in Creator Tech Connect Series ! About Creator Tech Connect Series In Creator, when we have to handle a complex business logic, we go for the combination of workflow and deluge scripting. To develop those business
Zoho Creator - [Free Webinar] Learning Table Series for Retail
Hello everyone! The most pivotal part of building any application is to understand the industry, business operations and standard features/functionalities that are required to get the operations going. Industry is the key here and every feature that we
Zoho Commerce and Zoho creator customer portal
hi, is it possible to integrate Zoho Commerce and Zoho creator sharing the customer id? I.e. as if Zoho Commerce provides an alternative to customer portal autentication process? Or else how can I bring a customer from commerce to creator without having to authenticate twice? What would be the subscriptions required for this to be possible? thanks Luis
How do I change a Zoho Creator Form's styling with CSS?
Hi there, I have built a form with zoho creator. I'd like to change the field labels to be consistent with the website to which it will be embedded. What's the process for specifying web fonts and changing sizing, colours etc? Thanks
Are there page rules in zoho creator to hide/show elements?
Greetings i'm looking for a functionality similar to what we have in the creator forms where we show/hide certain fields based on actions/conditions. for example i have an HTML snippet in my page and button, when i click the button i want to toggle the
Next Page