Blog categorized as Zoho Creator

Scheduler is a powerful feature in Zoho Creator that allows the application owner to create timed actions without any user input. These timed actions can be executed periodically based on the date and time values present in your form or on fixed date and time.

Zoho Creator supports three types of sch...

The Problem:

 How can I make it so when a phone number (String) is entered in a form like this:9876543210 it automatically formats it to 987-654-3210

list  LogHistory_Report
{
    displayname = "LogHistory Report"
    show  all  rows  from  LogHistory [(Added_Time < '10-Nov-2015' && Added_Time > '01-Jun-2015')]
    (
        Added_Time as "Added Time"
        Added_User as "Added User"
        Activity
        ...

Write the following code within the on add -> on validate block of the Script tab. In the following deluge code, the value of the field PatientID is calculated based on the form values specified for the First_Name and Last_Name and the value returned by the variable zoho.currenttime.

on add
{
on val...

Geofencing is the practice of closely targeting users based on their current location. To improve customer experiences and offer them better location services-based benefits, you can make use of geofencing. It combines awareness of the user’s current location with awareness of the user’s proximity t...

To Edit Multiple Records,

1. Select the records to be edited and click on the Bulk Edit option displayed below the Report header. For shared users, the Bulk Edit option will be displayed only if access permission is provided by the application owner.
2. In the Bulk Edit dialog, select the column whose value...

In a view, the columns are displayed in the order the corresponding fields in the form were created. It is, however, possible to rearrange the columns in a view. To do so:

• Click on "Edit this application" and navigate to the required view.
• From the left pane, from under "Display" c...