Creator Scripts.
Smart Software For Maverick Entrepreneurs

By: CreatorScripts | January 31, 2018


You can add the below script On Add On Validate or On Add On Success. Just replace the name of the input.Phone_additional field with the name of your phone field in your zoho form.

//Update Phone format
if ((input.Phone_additional.getAlphaNumeric().length() != 10) && (input.Phone_additional != ""))
{
errors = List:String();
errors.add("Phone Number is not a 10 digit number.");
}
else if ((input.Phone_additional != "") && (input.Phone_additional.getAlphaNumeric().length() == 10))
{
input.Phone_additional = thisapp.Update.PhoneFormat(input.Phone_additional);
}
else
{

}

The script above calls a function to update the Phone string. You can name your function the same as the one in this example so you can only cop...

By: CreatorScripts | January 25, 2016

Inside Report Settings ----> Summary --->Criteria  you can set the "OR" or "AND" operators to limit the records you display on a view.

Creator-Scripts-Zoho-Criteria-Operators