What is the Regex expression to validate a phone number in the format 999-999-9999?

The following regex expression is used to validate the phone number in the format 999-999-9999

errors = List:String();
e = input.no;
if(e.matches(“[0-9]{3}-[0-9]{3}-[0-9]{4}”)== false)
{
&

…

How can I get the time portion from a date-time string?

Time portion string can be obtained from date-time value using toString() function, as shown in the below code.

a = ’01-Oct-2010 10:11:12′ ;
alert a.toString(“HH:mm:ss”);

…

How can I extract date from a date-time field?

Use todate() built-in function to extract date from a date-time field. For example, the following code will fetch the date from the date-time field named “DateTime” and update it in the variable named “date”

da…

How can I display custom error messages based on user input to your form?

You can display custom error messages in the Note field based on user input, using Deluge Scripting. The sample application Update Note in the following link demonstrates how to display customized text in a Note field

…

How can I delete records from my database?

You can remove old or
unwanted records from your database by directly deleting them from the View or by executing Deluge Script or by using Zoho Creator APIs. Once a
record is deleted, you cannot retrieve the data it contained.

…

Is there a bulk delete option to empty my database (i.e) all the records in a view?

As
of now, Zoho Creator does not support emptying an entire View. However, as a work around, you can create a copy of the Form ( based on which the view is created) and then delete the original Form, which in turn will delete the corresponding vi

…

What is the URL pattern to generate the data of the view in the specified export format.?

The URL pattern to generate the data of the view in a specified export format is given below:

http://ceatorexport.zoho.com/<zohousername>/<applinkname >/<export type>/<view link name>

where, &lt…

You can display unique records using the distinct() Deluge function. This function returns the distinct values of a field 
in a form.

For example, assume the field "ProgramCodes" is a lookup to the "ProgrameName" field of the "Program" for

…

Is it possible to hide a form field based on a given time?

The sample code given below will hide the field named “Name” if the currenttime is past 5.00 pm.

hr =zoho.currenttime.toString(“HH”).toLong();
min =zoho.currenttime.toString(“mm”).toLon

…

Is it possible to add multiple attachments to a record?

Yes, you can add multiple attachments to a record, using Subform feature. Create a form with a single “File Upload” field type and add it as a Subform field to your primary form, to add multiple attachments per record.…

Modules: General