connect
How can I restrict entries to my Form only from registered members?
The count function in Deluge Scripting enables you to count the number of records in a Form (table) that satisfies the given criteria. Using the count function, you can check if an entry already exists in a database. Let us illustrate this with the ...
How can I restrict entries to my Registration Form based on a given date?
Assume you have a Registration form to register for a specific course and the registration is open till 30th Dec 2009. To restrict entries from being submitted after this date, use the zoho.currentdate variable within the on add -> on validate block ...
How can I restrict the number of registrations to my form?
The following script added to the on add - validate block of the Script tab, checks if the number of records in the Registration form is equal to or greater than 20. Here, the count function is used to count the number of records in the Registration ...
How can I check for duplication of records using Script?
The following sample code added to the Form actions -> on add -> on validate block and Form actions. -> on edit -> on validate block of the Script tab, will check if the same team member is added more than once to the Team Member form. If true, the ...
How can I copy/duplicate a Form?
Right now it is not possible to duplicate a form directly. However, it is possible to do so via script. Click on "Edit this Application" and navigate to the particular form. From the top strip displaying the Form name, mouse over on "More Actions" ...
Is there anyway to calculate an exponent in a formula field?
You can use the "power()" function to calculate an exponent in a formula field. For example, to calculate simple interest with the following formula : (Principle * (1 + 0.08 / 365) + fee) ^ (Todaysdate - Issue_Date) use the power() ...
How can I write a script to select the checkbox options based on value selected in a list field?
Assume that "Options" is your picklist field and "Equipment" is your checkbox field. Copy code if (input.Options == "Tennis") { Equipment.deselectall(); Equipment.select("Racquet"); } else if(input.Options == "Football") { ...
How can I calculate the number of hours between two date and time fields?
To calculate the number of hours between two date and time fields, add a formula field and specify the formula expression as ((To_Date - From_Date) / (1000 * 60 * 60)) form Sample { FromDate ( type = datetime ) ToDate ( type = datetime ) Hours ( ...
How can I calculate the age of a person from a given Date of Birth?
To calculate the age of a person from a give DOB, add a Formula field and specify the formula expression as given below: ((zoho.currentdate - DOB) / (1000 * 3600 * 24 * 365)).round(2) Note: If you use a Formula field, the calculated age can be seen ...
How can I add days to a date field?
You can manipulate a date field by using the + (to add) and - (to subtract) Operators or by using the Built-in date functions. For example, if you would like to add 364 days to a particular date field, say StartDate and display it in another field, ...
How do I get the date and time and input it into a field upon success?
Every record in every table (form) has two fields (Added Time and Last Modified Time) that ZOHO Creator automatically updates when ever a Form is clicked on the Submit or Update Buttons, so you could elect to show these fields in your List ...
I want to calculate the sum of all the numeric fields in my form and its average. How can I do this?
To find the sum of numeric field values in a form, add a formula field with the expression (field1 + field2 + field3), where field1, field2 and field3 are deluge names of the respective numerical fields in the form. Let's consider a form containing ...
I have a form to enter my patient details. Can I create a unique code for each patient based on their DOB and Name combination?
To create a unique code based on the Date of Birth (DOB) and Name combination, add a Formula field with formula expression as given below, ((((DOB.getMonth())) + Name) + (DOB.getDay())) + (DOB.getYear()) where, - DOB.getMonth, returns a number in the ...
I would like to order the DOB field in my form, based on month and day. How can I do this?
To sort records based on custom value acquired from the DOB field i.e., month and day, you may add a formula field with below suggested sample expression, ((((((DOB.getMonth() / 100).round(2))) + "").getSuffix(".")) + "-") + ((((DOB.getDay() / ...
How can I calculate the number of days between two date fields?
To calculate the number of days between two given date fields, for instance, ServiceStartDate and ServiceEndDate, add a formula field to the form with formula expression as below. ((ServiceEndDate - ServiceStartDate) / (1000 * 60 * 60 * 24)) ,where ...
Is it possible to obtain month and day information from a given date field?
Yes, you can use the Deluge date function getDay() and getMonth() to obtain the day and month information. - getDay() returns the numerical day of the month for a particular year. The value returned will be between 1 and 31. - getMonth() returns the ...
Is there a way to get rid of the seconds in a Date-Time field value? For example Apr 02,2010 23:01:38 should be displayed as Apr 02,2010 23:01
You'll need to create a formula field in your form with a formula expression as below to truncate the value starting from the last ':' and display the resultant value in your view/form in that formula field. ...
How to get the Deluge name of a field
Deluge field names are often used in the following places. In the script To set values for the form field via URL To filter records from the View via URL You can get all the applications/forms/fields deluge names. For this, you can login and ...
How to dynamically filter a multiselect field
The method of filtering a multi-select field is very similar to dynamically filtering single-select dropdowns as described here. However, the problem with filtering a multiselect is that when you edit the record the filtered list is not shown and all ...
How to convert Date format in Deluge Script
To convert the date format from "DD-MMM-YYYY" to "YYYY-MM-DD", change the string with first format to date. Then convert that date object to a string specifying the second format. The below is the sample function which converts the format of the date ...
How can I display custom error messages in my form?
About the Application A Note field is used to display text or images that guide the user while filling the form. This field will not be displayed in the View. You can display custom error messages in the Note field based on user input, using Deluge ...
How can I get the values entered for certain fields via Deluge script?
How can I get the values entered for certain fields via Deluge script?
I have embedded the form in my website, How do I see the data that was entered in it?
Whenever data is entered into a form created by you, the data is automatically stored in Zoho Creator. To see the data that has been entered in a form: Log in into Zoho Creator using your Zoho Credentials. Click on the name of the application which ...
I have configured an "on success" script with the "send mail" task with "From" address as "zoho.loginuserid". But the send mail action fails to execute, why?
If your Form is accessed by users without logging in to Zoho Creator, the variable zoho.loginuserid will be set as "Public". As "Public" is not an email address, the send mail action fails to execute.
How can I send email to an address filled out by the user of the forrm?
To send email to an address filled out by the user of the form, set your To field as the email field in the form. For example, if the name of the email field in the form is emailid, specify the To address as input.emailid. Refer the Help topic Send ...
How can I send the URL of the uploaded file, in my e-mail message?
et the url/link of the uploaded file by specifying the url within the <a href> tag, in the following format. For example, in the sample message given below, File_Upload is the name of the file upload field, test is the application name ...
How can I send a URL in my e-mail message?
To send a link/url in your e-mail message, the actual link must be specified within the <a href> html tag and the actual link must be within single quotes, as shown in the sample below: on add { on success { sendmail ( To : zoho.loginuserid From : ...
How can I send only specific field values in the e-mail message?
To send only specific field values in your e-mail, use the input.<field_name> variable in the send mail task. For example, you have 3 fields (Name, Age, Email), and in the email message you want to send only the Name and E-mail field values. The ...
How can I send email message with Form Data?
You can configure to send e-mail message with form data either from the Form GUI or by adding Deluge Script with the Send mail task. 1. To configure email notifications from the Form GUI, refer the topic, Configure email notifications from GUI. The ...
How can I insert line breaks to my e-mail message?
A message could be sent as "Plain Text" or "HTML". Use <br> tag if the content is HTML and \n if the content type is "plain text". For example, on add { on success { sendmail ( To : zoho.loginuserid From : zoho.adminuserid Subject : "To insert ...
How can I send mail to selected records in a view?
You can send mail to selected records in a view by configuring Custom Actions. Refer the link Functions -> Custom Actions for more information.
How can I send mail with values selected in a multi-list field?
Refer the topic http://kbase.zoho.com/iterate-records/iterate-data-in-raio-buttons-and-checkboxes
How can I send mail to particular records using Deluge script?
You can send mail to specific records in a form by using the sendmail Deluge syntax within a for each deluge statement. Refer the link Fetch a collection of records and iterate over them, for more information.
How can I send mail when a field value is modified?
Assume you have a Feedback form with a Status field with values "Open" and "Closed". When a feedback/issue is solved, the status is set to "Closed" by the team member and a e-mail is sent to the person who had raised the issue. To do this, we have to ...
How can I add records to a form using Send mail task?
Every form in Zoho Creator has its own e-mail address. You can use this e-mail address in the Sendmail function to add a record to another form. Please refer the topic, Add records to a form using scripting for more information.
How can I use the Email ID field in Form A as the "To Address" of the send mail task, in From B?
About the applicationAssume you want visitors to subscribe to a newsletter through a subscription form and send mail to the e-mail ids of subscribed users. The application should also allow subscribers to unsubscribe from the news letter. The sample ...
How can I change the width of the Columns displayed in the View fields?
By default, the width of the columns in the view is set depending upon the contents of columns being displayed in the view. If there are a few columns, the width of the columns is adjusted so that the view fits into the browser. However when the ...
How can I allow one of my shared users edit the application?
For a shared user to be able to edit your application, he/she must be added as a developer under your account and the application must be shared to him/her. Once the application is shared to a developer, you can provide edit permission to him as ...
How can I copy/duplicate a Form?
Right now it is not possible to duplicate a form directly. However, it is possible to do so via script. Click on "Edit this Application" and navigate to the particular form. From the top strip displaying the Form name, mouse over on "More Actions" ...
How can I copy/duplicate my application?
ou can copy/duplicate the application in the following ways 1. From the Home page : In the Zoho Creator Home page, the application created by you will be listed one below the other. When you mouse over the application name, the options "Settings", ...
Next page