1. To set default values for form fields
The default values for form fields can be set by passing additional parameters to the form URL. For example, to automatically load a value for Employee ID field in http://creator.zoho.com/zchelp/employee-manager/#Form:Employee the default values is passed as querysting(Employee_ID=1234) to the url, where Employee_ID is the script name of the field in your name.
The form url with query string will be,
http://creator.zoho.com/zchelp/employee-manager/#Form:Employee?Employee_ID=1234
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/<zoho username>/<applinkname>/#Form:<formLinkName>?recLinkID=<recordID>&viewLinkName=<viewlinkname> |
Refer the topic Editing Records via Record ID for more information.
3. To set criteria for a view
The
criteria for a view can be passed as part of a query string to a view
url. Multiple criterias can be specified by appending it along with the
URL using '&'
The URL format for setting criteria with "=" (Equal) operator is given below:
| http://creator.zoho.com/<zoho userName>/<applinkname>/#View:<viewlinkname>/<FieldName1>=<FieldName1 Value> &<FieldName2>=<FieldName2 Value> |
where, FieldName1 & FieldName2 are the Deluge script names for the field in the form and multiple criterias are specified by appending it along with the URL using '&'
Example:
The view http://creator.zoho.com/zchelp/employee-manager/#View:Employee_View lists all the records in the Employee View. To view records with Name EQUALs Henry and Employee ID EQUALs 1234, we need to pass the field name and value as querystring.
The complete url for this example is,
http://creator.zoho.com/zchelp/employee-manager/#View:Employee_View?Name=Henry&Employee_ID=1234
The URL format for setting criteria with operators other than "=" (Equal) is given below:
| http://creator.zoho.com/<zoho username>/<appLinkName>/#View:<viewLinkName>/<FieldName1>=<FieldName1 Value> &<FieldName2>=<FieldName2 Value>&<FieldName1_op>=<constant>&<FieldName2_op>=<constant> |
where,
FieldName1 & FieldName2 are the Deluge script names for the field in the form.
FieldName1_op & FieldName2_op are parameter names for the operator (fieldname appended by _op).
constant is the value assigned for each operator. Refer the table to view the list of all operators and their constants.
Example1:
The view http://creator.zoho.com/zchelp/employee-manager/#View:Employee_View lists all the records in the Employee View. To view records with Employee ID GREATER_THAN 1235, we need to pass the field name, value, parameter name for the operator and its value as querystring. The parameter name for Employee_ID is Employee_ID_op and the constant for GREATER_THAN is 21.
The complete url for this example is,
http://creator.zoho.com/zchelp/employee-manager/#View:Employee_View?Employee_ID=1235&Employee_ID_op=21
Example2:
The URL to view records with EmailID ENDS_WITH zoho.com and Roles CONTAINS Supports,
http://creator.zoho.com/zchelp/employee-manager/#View:Employee_View?EmailID=zoho.com&EmailID_op=25&Roles=Support&Roles_op=26
Note:
For some operators like EMPTY, NOT_EMPTY, YESTERDAY, TODAY,
NEXT_YEAR, TRUE, FALSE, etc. the criteria value need not be specified.
For example, the following URL will display records from the
"Employee_View" whose "Date of Joining" falls on the "CURRENT_YEAR".
http://creator.zoho.com/zchelp/employee-manager/#View:Employee_View?Date_of_Joining_op=52
(posts) (comments)
