Zoho Creator generates a unique ID (unique across your account) for every record that is added to the database. The ID can be displayed in your view by selecting the "ID" field from the "Column Properties" of the Report Settings, in Edit mode. The Record-Edit feature supports editing individual records via its Record ID, by displaying the form with the record details. This makes it easy for users to edit records without having to display the report, navigate to the desired record and then requesting to Edit it. The Record-Edit feature is generally used in the following scenarios:
The URL to view and edit individual record using its record ID is given below. This will display the zoho creator form in edit mode.
<userName> is the application owner name
<applinkname> is the application name
<formlinkname> is the name of the form in which the record exists.
<viewlinkname> is the name of the report.
<recordID> is the ID of the particular record to be edited (field name ID). The variable record ID (ID) is a default field in Zoho Creator that is automatically inserted for every record.
zc_NextUrl - optional parameter that specifies the url to which the user should be redirected to on success. Just append this parameter to the 'edit - record url' as /&zc_NextUrl=http://mail.zoho.com"
The following URL will open the form Commissions with the record details of record id 89597000010683429 as shown in the screenshot below.
Alternatively, you can also use the default functionality of Zoho Creator to view and edit individual record using its record ID. The following url will display the form alone without displaying top header and other application components.
The URL mentioned below will open the form Commissions with the record details of record id 89597000010683429 without displaying top header and other application components as shown in the screen-shot below.
From Deluge script, you can programatically invoke a form in Edit mode using the openurl deluge task. For example,
+ input.ID + "/","same window");
zoho.adminuser - is a zoho variable that returns the username of the application owner.
zoho.appname - is a zoho variable that returns the application name
input.ID - fetches the ID of the current record .
To fetch the ID of a specific record in the database,
//fetch the record with any criteria
rec = test_form[<any criteria>]
//Now the rec.ID will return the record id(ID)