Zoho Creator Help Center > Editing Records via Record ID

Editing Records via Record ID

Tags:

Overview

Zoho Creator generates a unique ID 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 View, in Edit mode. The record-edit feature supports to edit 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 view, navigate to the desired record and then requesting to Edit it.

Syntax

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.

http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname>

where,
<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 view.
<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"

Example

The following url will open the form Students_Mark_Sheet with the record details of record id 20881000001004007

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.

http://creator.zoho.com/<userName>/<applinkname>/<formlinkname>/record-edit/<viewlinkname>/<recordID>

Example

The following url will open the form Students_Mark_Sheet with the record details of record id 20881000001004007 without displaying top header and other application components.

Invoking the url from Deluge Script

From Deluge script, you can programatically invoke a form in Edit mode using the openurl deluge task. For example,

openurl(http://creator.zoho.com/"+zoho.adminuser+"/"+zoho.appname+"/add_contact/record-edit/contact_view/" 
+ input.ID + "/","same window");

where,

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)

The record-edit feature is generally used in the following scenarios:

1. When only a single record needs to be edited in a view that is shared but hidden.
2. To open a form in a new tab with pre-populated data without having to traverse to the view and then edit the record.

Access Pemissions

1. If the user is not the App admin, the view has to be shared and permission to edit record has to be provided to the user. If accessed through #, the form also should be shared.

2. To edit a record that would normally not be present in a view with a specified Criteria or hidden fields, the master view must be shared and edit permission provided.

1 Comments Show recent to old

pastorsearch, 228 - days ago

I really want the details on "building a Custom Function that composes the url for you" and possibly some use cases!