How can I create a view in Zoho Creator which shows only the current record?

How can I create a view in Zoho Creator which shows only the current record?

To create a view which shows only the current record,

  1. Add a hidden field in your form to identify the current record based on some value. For instance, let us create a hidden field named TXT with default value as "new". When a new record is submitted, the TXT field will hold the value "new" 

  2. To update the TXT field of the previous record, with value as "old", write an Form Actions -> on add -> validate script as given below. The script will be executed when new form data is submitted. The script will fetch the record whose TXT value is "new" and update it with value as "old".

    on add -> on validate script


    if (count(Form1[TXT == "new"]) > 0)
    {
    dat = Form1 [TXT == "new"];
    dat.TXT = "old";
    }
  3. Create a view with criteria as [TXT == "new"] to display only the current record, as given below. 
    list  "Current Record"
    {
    show all rows from Form1 [TXT == "new"]
    (
    Name
    Number
    City
    )
    }

    • Related Articles

    • Linking Zoho Creator Apps with CRM

      Web tabs functionality can be used to access the applications created in Zoho Creator and link with the Zoho CRM data. In order to access the Creator application within Zoho CRM, design an application in Zoho Creator, add it as a web tab inside CRM ...
    • Import contacts from Zoho Creator

      Zoho Creator is an online custom apps builder through which you can create different applications using drag & drop feature. Any Zoho Creator will have a form, reports and pages and in reports section, you can view the contacts and other details. ...
    • Setting up Zoho Creator Integration

      Prerequisite Before activating, please make sure that you meet the required criteria mentioned below: You should be an Administrator in the Zoho CRM account. You should have a Zoho Creator account with any edition. If you do not have a Zoho Creator ...
    • Sync leads from Zoho Creator

      Zoho Creator is an online custom apps builder through which you can create different applications using drag and drop feature. Zoho Creator will have a form, reports and pages and in reports section, you can view the contacts and other details. These ...
    • Is it possible to integrate current MS Access db file with Zoho Creator?

      It is possible to migrate your existing .mdb database to ZohoCreator. For this, Go to Zoho Creator Home Page (http://creator.zoho.com) and click on Create new application. You will have a link to download the tool convert your *.mdb filed to Zoho ...