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
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
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
[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,
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
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
Print Using Record Template
Hi, I can use the record template using the Report Properties->Print & PDF options. However, I want to create a button to print my custom template on the same report. I want to maintain 2 different report format, one for the Detail View, and one custom
Fill a related field in a lookup field
Hello, I have an "order" form with a lookup field "client" that select a client in a client form. The lookup field search the client by it's name an shows the name in the lookup field. I also would like to pick the telephone and email in the "client"
List records based between 2 dates and do math
I have 3 forms, LOADS, DRIVER, CREATE SETTLEMENT. The LOADS form has following fields: Load # Driver Name (look-up from DRIVER) Driver Pay Delivery Date DRIVER has the following fields Driver Name In CREATE SETTLEMENT I want to be able to 1) select a
Validation, Subforms and Note Fields
We are attempting to put some validation on a few Subforms on a fairly large subform as the dropdown values are conditionally populated based on other fields in the form. As a protection against any edge case or bugs we might discover after this goes
Subforms sorting rows
Is it possible to sort the rows in a subform? I have an application where the user uses a subform to record the steps in a process. They enter the details of Step 1 , later they add the details of Step 2 and so on for step 3, 4 & 5. When I edit the form the rows in the subform are in a random order. The best solution is for the rows to show in the order that I specify in the subform view. The second best is to use the date & time each row was entered as the default sort order. Any work arounds? Herb
Save PDF with a field as the file name.
We currently have to save and rename all the PDF's we store for sales documents. Is there a way in creator to have these default to a particular field in the form?
Offline Zoho Creator
Hello Everyone, My client's office is in a region, where the internet quality is very poor. He would like to run his Zoho Creator inventory app offline, on his servers. Is it available by now at Zoho? Thanks George
aggregate records of each calendar year
Hello, could anyone help me with the script ho to aggregate monthly revenues in a yearly revenue field? I have three fields date field monthly revenue yearly revenue I'd like the script to work on user input of monthly revenue field, and want to aggregate
Adding fields dynamically to a form using deluge
Greetings In my project i'm going to have an initially empty form that has an on load workflow that reads records from a report somewhere else in the app and then add input fields to the empty form based on these records. i was wondering if it's possible
Cannot change japanese text font when doing pdf export
I use openUrl to export my report with specific ID, but the Japanese font does not look clean when exporting. I have tried changing the font within my RTF, but no luck. Any idea on how to fix this?
User-defined global variable
Is there something like a user-defined global variable that can hold values among forms and pages within an application? I would like to do the followings: When accessing the application for the first time, Deluge script run and store the values to user-defined global variable. While the access, the user-defined global variable can be used in all forms and pages.
SalesIQ Bot Not Getting Zoho Creator Page URL
How can I pass the Zoho Creator page url into SalesIQ...it seems it is passing something related to the Page Element or Javascript widget. I really need to be able to identify what page the user is on to implement a useful Bot. A snip of the url that
Form in Page
I know you can input a form into a page using the HTML insert that is built into the Page HTML options. But is there a way to insert form fields individually using HTML into a page? For example, I don't want the entire form on the page. Using HTML I want
Autocomplete addresses
Is there a way, script or otherwise, to autofill addresses in a creator form based on Google or similar maps app?
Refer to url parameters on form load
Greetings in my app i redirect the user to a certain form and include query parameters in the url: openURL("#Form:Ideation?projectId=" + input.ID,"same window"); i want to create a workflow action that would run on form load to use the projectId parameter
Allow user to add/remove certain fields dynamically
Greetings I'm working on an app that's going to contain a form to describe acts of a story, i want the user to be able to add and remove acts as they see fit. something similar to what subform field in zoho forms offers (attachment ss) with one exception
Is it possible to add custom submission buttons to creator forms?
Greetings I was wondering if it's possible to add custom buttons to my forms in zoho creator. so beside the default submit and reset buttons i'd also create a "submit and new" button that has custom action. is that possible? Thanks
How to add Invoice in my Zoho Creator Custom App.
Hello, please i am finding it hard to add Invoice to my Zoho Creator App. Any help on that?
Next Page