Zoho Creator - How to avoid multiple IF statements?
Hi All, Is there a way to avoid multiple if statements by referencing a map or similar? For example, I have dropdown list with 15 options. The input of this field will trigger different options in the form. I want to avoid 15 separate IF statements so
Need an Application to Creating Interview Tracker using information from Candidate Module and a custom module ( Interview information ) using Zoho recruit and Zoho Sheet
Hi Zoho team, I would like to have a online meeting with your creator team to make them understand my requirements, show them how we are doing and so that my requirements are captured and flow of development work can be defined, You may suggest a developer
How do I round up a number to the nearest 1000 or round down to the nearest 1,000?
For example: Round up the number 133,768 to 134,000 (nearest 1000) Round down the number 133,768 to 133,000 (nearest 1000) Thanks
Update production data from development environment C6
Hi guys, I am using C6 and one of my struggles is that I want to update some production data without needing to create a function and transfer this to the production environment to update some data. Little bit of elaboration: I have invoice lines in Creator
Material Reconciliation in Zoho Creator
I have created a Zoho Creator app for my purchase and production. Now I want to create ledger for material code that is Receipt and Consumption and Balance for a particular period. I don't know how to achieve this.
Recording values in different currencies
I have a creator form that we use for survey recommendations and, at the moment, the value saved is set up as £GBP. However we have some clients from other countries and would like to save a value as a different currency. It doesn't need to make any exchange
Hide sort & group options in mobile app
Hello. Is it possible to hide the grouping and sorting options in the mobile app in a report embedded in an html widget?
Royalty/Sum Calculation app based on uploaded statements.
Good afternoon. I'm relatively new to Creator but have adopted the software for my new business currently setting up. I plan work in music publishing and have the following question. Is it possible to build an App in creator where i can upload a royalty statement from a record label (as a .CSV or Excel File), align the columns and then calculate % splits and report out the new statements? Something similar to this - https://label-engine.com/record_label_accounting.php
How to protect my reports data.
I don't want anyone to copy my report data. For now able to select all and then copy hole data. How to stop Copying data.
hide formula field
Now that there is an option to show a formula field on a form we also need the ability to conditionally hide these fields. When I try to hide a formula field the following error message is displayed. hide/show/enable/disable fields is not applicable for formula field Herb Wexler
How to change the Permalink(Publish) Form- Width and height
Help me to change the Width and Height of the Permalink Form Which the Permalink is Published . Is there any way to change the Width and Height without customizing the fields in the Forms?
how to make creator widget sdk work on my localhost
Greetings i'm trying to connect my widget to my zoho creator app, what i have now in my code is the basic example: ZOHO.CREATOR.init() .then(function (data) { console.log(data); }).catch(err => { console.log(err); }); this code doesn't work locally, it
Zoho Creator Environments is an underdeveloped feature that is full of bugs
I have been using Zoho Creator for the past year and a half for developing and maintaining a custom business system for a client of mine. I want to start by saying, I think Zoho Deluge and Creator is general is a very powerful and useful tool. I have
Lookup Field Checkboxes
Hi, I have this problem currently in all my applications. To simplify I have created a Test application with the following form: form Untitled_Form { displayname = "Untitled Form" field alignment = left Checkbox ( type = checkboxes values = {"Choice 1", "Choice 2", "Choice 3"} ) Choices ( type = checkboxes values = Choices.ID displayformat = [ Single_Line ] sortorder = ascending searchable = true
Is there a way to have custom scriptable buttons in creator forms without being forced to resort to use stateless forms?
Greetings In my form i need a very simple functionality that is to have a button submit a record and then be redirected to another form, and another button to submit a record and reload form so a user can enter new records. the only way i found to be
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.
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
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
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 .
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,
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.
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.
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
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
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
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
Next Page