Deluge code formatting
Hello Zohoholics I'm trying out Zoho Creator and there is a lot to like. Coming from a programming background I'm enjoying the productivity gains in Creator. But, as a low level coder the Deluge editor is reformatting my code! It removes spaces and moves my braces placement. This is not good - any way I can turn this off please! Also is it possible to theme the Creator itself (not the application) to have a dark background (or at least the code editor). Thanks in advance. David.
Feature Request: Dynamic Field Names/Labels
I would like to suggest a feature that allows us to flex the Display Name (sometimes referred to as Label) of a Form Field. Example: Lets say I have two clients using the same Zoho Creator Form to input employee names. The Form has a hidden field called
Referencing a filw in Workdrive
Hi, I'm building a form where the user will need to reference (not upload) documents hosted in our workdrive. I thought about using the Upload field, but this would copy the document from workdrive to Creator. Not reference it (is permalink it) Using
Lookup returns ID not value
I've created a sales order form, and when I select the account for the sale via Lookup it returns the ID for the Billing Country, Billing State, Shipping Country and Shipping State instead of the value. Here's the code I am using to pull the account information into the order form: selected_Sold_To = Account [ID = input.Sold_To]; input.Billing_Street = selected_Sold_To.Billing_Street; input.Billing_City = selected_Sold_To.Billing_City; input.Billing_Country = selected_Sold_To.Billing_Country.toString();
check vacation request on other form
Hi all, Could anyone help me what's wrong with this code? My intention is if the assistant set vacation status on the Timesheet form the script should check if the employee has a valid vacation request for the certain day on Vacation form. checkvacreq=Vacation[ID==input.Name];
Update account on inventory bundle
Could someone please give me the deluge code needed to change one of the account numbers on the accounting transaction that's created when you create a bundle? Specifically, the entry is: DR Finished Goods CR Uncategorized expense And I want Deluge code
Subform details in a email
I have read the following: https://www.zoho.com/creator/help/forms/creating-subforms.html#To_send_subform_details_in_an_email and tried putting this into my form: message=""; for each item in Progress { message=message + item.Progress + "<br />"; } But this is getting ALL the items in progress, but I just want the ones that have been added as subforms to just the current form. How do I do this? Is there a way to identify in the subform what mainform ID is associated with it?
Dynamic Population of Subform Dropdown
On the user input of a field in the main form, I want to auto create subform rows (based on records in another form) and populate a dropdown field in each based on a third form. I've been able to dynamically populate subform row dropdown fields on the
Zoho Creator : Changing owner of esablished app
We have several apps and analytics dashboards/datasources that were created by the owner of our company. He now longer has the time to maintain the system and wishes to hand ownership over to the head developer. I believe that several elements of creator
Allowing customers to add tags without enabling full edit permissions
Hello! I am trying to understand whether there is a way to allow portal customers to have the ability to edit a single property (i.e., not enabling full edit permissions for a given object). I would like to allow our users to create and assign their own
I can't get NFC tag info.
Hi Support, The following tag is my NFG tag read result. My Page set up like following After I execute Creator APP to detect NFC tag. APP already detected the NFC and jump to Form.But got nothing in AssetID field. Please give me a advice .
Where is the template for "Thank you for signing up"
I can see in the cutomer portal there are templates for Login Page Signup Page Reset Password Page However I am looking for the screen that displays when someone has hit the "Sign Up" button. On my system it looks like this : I would like to change the
Lookup ID field reverts to Zoho ID
I'm having trouble selecting a lookup field link other than the .ID when linking forms. When creating the relationship in form-builder, I am presented with a choice for which field will be the link. In the past, I would select my own ID field (e.g Program.Program_ID) instead of the Zoho ID field (e.g. Program.ID). On these older forms, this definition show as I created it in the workflow->Form Definitions as well. ( values = Program.Program_ID ) Recently, I tried to create another form with a lookup
Need to Filter Report on Multi Select Field via URL
Hello all, I am trying to filter and embed a HTML Creator report in a Page and filter based on the selections in a multi select picklist. Here is what I am trying to accomplish but I cannot seem to get the syntax right for the "OR" portion of the URL.
Lookup on Dropdown presents ID Number not String Value
I know this has been addressed in at least these two posts: https://help.zoho.com/portal/en/community/topic/how-to-get-result-string-from-lookup https://help.zoho.com/portal/en/community/topic/formula-field-displaying-long-id-instead-of-string-value ... but the offered answers don't seem to address/remedy my situation. I have two forms: Agents and Agency. Agents has a dropdown that lets you select available Agencies. Using the following code in the Agents form under Field Actions>Agency>On User Input,
Import Error
I try to import a .ds file from the workspace, to create another application in the same (workspace). But while importing the .ds file this type of error occurred "same application name already exists".So I change the Application name and try to import
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
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
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
Next Page