Functionality based URLs

Overview

In the topic Zoho Creator URL Patterns we learned about the default URLs to access a Zoho Creator Application and its Forms, Reports and Pages. In this topic, we will learn about the Functionality based URLs to set default values for Form Fields, edit individual records by passing record-ID in the URL, set criteria for and print Reports and Pages.

Permalink of Forms, Reports and Pages

You can also access the components (Forms, Reports and Pages) in your Zoho Creator Application using their permalinks. As the word suggests, a permalink is a permanent link; it refers to the URL of a particular webpage (a Form, Report or Page, here). 

The format of permalinks of your app's components are as given below -

Permalink of Forms 
https://app.zohocreator.com/<app_owner_name>/<app_link_name>/form-perma/<form_link_name>

Examplehttps://app.zohocreator.com/sampleapps/employee-manager/form-perma/Basic_Information 

You may embed your Form in your website, blog, etc. by using the below given format,

<iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://app.zohocreator.com/<app_owner_name>/<app_link_name>/form-embed/<form_link_name>'></iframe>
Permalink of Reports ​ 
https://app.zohocreator.com/<app_owner_name>/<app_link_name>/view-perma/<report_link_name>

Examplehttps://app.zohocreator.com/sampleapps/employees/view-perma/All_Employees 

You may embed your Report in your website, blog, etc. by using the below given format,

<iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://app.zohocreator.com/<app_owner_name>/<app_link_name>/view-embed/<report_link_name>'></iframe>
Permalink of Pages 
https://app.zohocreator.com/<app_owner_name>/<app_link_name>/page-perma/<page_link_name>

Examplehttps://app.zohocreator.com/sampleapps/employees/page-perma/Complete_Employee_details

You may embed your Page in your website, blog, etc. by using the below given format,

<iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://app.zohocreator.com/<app_owner_name>/<app_link_name>/page-embed/<page_link_name>'></iframe>

where,

<app_owner_name> is the Zoho user-name of the application's owner 
<app_link_name>is the Link Name of the Zoho Creator application 

<form_link_name>
<report_link_name>
<page_link_name>

is the Link Name of the component (Form, Report, Page), respectively
Note:

Functionality based URLs for Forms

To set default values for Form Fields

The default values for Form Fields can be set by passing additional parameters in the Form's URL. For example, to automatically load a value for the Field Employee ID in the Employee Manager Application, the default value is passed as query string (Employee_ID=1234) in the Form's URL, where Employee_ID is the Deluge script name of the Field in the Employee Form.

The Form's URL with query string will be in the below formats:

  1. Accessing within the Application:
    https://app.zohocreator.com/zchelp/employee-manager/#Form:Employee?Employee_ID=1234
  2. Accessing via its permalink:
    https://app.zohocreator.com/zchelp/employee-manager/form-perma/Employee?Employee_ID=1234
  3. Accessing a Form, which is embedded in another webpage:
    https://app.zohocreator.com/zchelp/employee-manager/form-embed/Employee?Employee_ID=1234

For Multi Select Fields like Check-box, there can be need for having more than one value selected by default. For this, the values that are to be passed should be separated by a comma. For example, if the values "Manager" and "Programmer" are to be set for the Field Roles in the Employee Form (of the Employee Manager Application), the URL will be - https://creator.zoho.com/zchelp/employee-manager/#Form:Employee?Roles=Manager,Programmer.

Note: The values that are passed (as query string in the URL) will be set when the Form is loaded, i.e., On Load.

To load Form without Field-focus

You may note that when you access your Form in your Zoho Creator Application, the focus gets set on the first Field of the Form, i.e., the cursor appears on the first Field of the Form.

Assume that you have a website or blog, in which you have embedded your Form. When your webpage is accessed, this default auto-focus behaviour will scroll your webpage to where your Form is placed. This may hinder a user's experience as the content present above the embedded Form gets skipped. To handle this, Zoho Creator provides a parameter - zc_Focus.

Value forzc_Focus  Intended behaviour
true
false

Note: This parameter (zc_Focus) can be used only by the Zoho Creator accounts created after April-2014. It is not supported for the older accounts.

To edit individual records by passing record-ID in the URL

The URL to view and edit individual records using their record-ID is given below. This will display the Zoho Creator Form in Edit mode.

https://app.zohocreator.com/<user_Name>/<app_link_name>/#Form:<form_link_name>?recLinkID=<record_ID>&viewLinkName=<report_link_name>

Refer the topic Editing Records via Record ID for more information.

Functionality based URLs for Reports

URL format to set criteria for a Report

The criteria for a Report can be passed as query string in a Report's URL. Multiple criterias are specified by appending them to the URL using the "&" Operator.

List of Operators and their Constants -

S. NoOperatorConstant
1EQUAL18
2NOT_EQUAL19
3LESS_THAN20
4GREATER_THAN21
5LESS_EQUAL22
6GREATER_EQUAL23
7STARTS_WITH24
8ENDS_WITH25
9CONTAINS26
10NOT_CONTAINS27
11LIKE28
12EMPTY29
13NOT_EMPTY30
14YESTERDAY31
15TODAY32
16TOMORROW33
17LAST_7_DAYS34
18LAST_30_DAYS35
19LAST_60_DAYS36
20LAST_90_DAYS37
21LAST_120_DAYS38
22NEXT_7_DAYS39
23NEXT_30_DAYS40
24NEXT_60_DAYS41
25NEXT_90_DAYS42
26NEXT_120_DAYS43
27LAST_MONTH44
28THIS_MONTH45
29NEXT_MONTH46
30CURR_PREV_MONTH47
31CURR_NEXT_MONTH48
32TRUE49
33FALSE50
34LAST_YEAR51
35CURRENT_YEAR52
36NEXT_YEAR53
37PREVIOUS_2_YEAR54
38NEXT_2_YEAR55
39CURRENT_PREVIOUS_YEAR56
40CURRENT_NEXT_YEAR57
41BETWEEN58

URL format to print a Report

The URL format to print a Report is given below:

https://app.zohocreator.com/<app_owner_name>/<app_link_name>/print/<report_link_name>

Examplehttps://app.zohocreator.com/zchelp/employee-manager/print/Employee_View

URL format to print a Report with criteria

Functionality based URLs for Pages

Pages can also accept URL parameters. You may access the below given URL as an example (parameter emp is being passed a value).

https://app.zohocreator.com/sampleapps/employees/#Page:Complete_Employee_details?emp=support@zohocreator.com

To print a Page with parameter

The URL format to print a Page with parameter is given below,

https://app.zohocreator.com/<app_owner_name>/<app_link_name>/print/<page name>?<paramName>=<paramValue>

where,

paramNameis the name of the parameter defined in the Page
paramValueis the value passed to the parameter that is defined in the Page

Example: The URL to print a Page named "TestHTML" with paramName "dept" and paramValue as "Engineering" is given below. Here, the paramName "dept" is the name of the parameter defined in the Page to fetch records with the specified paramValue.
https://app.zohocreator.com/zchelp/employee-manager/print/TestHTML?dept=Engineering

To convert Page to PDF

The URL formats are as given below -

  1. The URL format to convert a Page to PDF is given below:
    https://creatorexport.zoho.com/<app_owner_name>/<app_link_name>/pdf/<Page link name>

    Examplehttps://creatorexport.zoho.com/sampleapps/customer-support/pdf/Most_Recent_Solution

  2. The URL format to convert a Page to PDF with output file name is given below: 
    https://creatorexport.zoho.com/<app_owner_name>/<app_link_name>/pdf/<Page_link_name>/&zc_FileName=<output_file_name>

    If the parameter zc_FileName is not passed to the URL, then by default the Page's display name will be chosen as file name.
    Examplehttps://creatorexport.zoho.com/sampleapps/customer-support/pdf/Most_Recent_Solution/&zc_FileName=DownloadReport

  3. The URL format to convert a Page to PDF with parameter, where, paramName is the name of the parameter defined in the Page and paramValue is the value passed to that parameter.
    https://creatorexport.zoho.com/<app_owner_name>/<app_link_name>/pdf/<Page_link_name>/&<paramName>=<paramValue>

    Example: PDF Link with arguments: https://creatorexport.zoho.com/sampleapps/customer-support/pdf/More_Details_Html_View/&ticketID=104, where, ticketID is the name of the parameter defined in the Page.
    Example: PDF Link with arguments and file name: https://creatorexport.zoho.com/sampleapps/customer-support/pdf/More_Details_Html_View/&ticketID=104&zc_FileName=ReportFor_Oct26, where, ticketID is the name of the parameter defined in the Page.

  4. The URL format to convert a Page to PDF with the PDF's orientation value is given below. The orientation value can be landscape or portrait. The default value is portrait.
    https://creatorexport.zoho.com/<app_owner_name>/<app_link_name>/pdf/<Page_link_name>/&zc_PdfOrientation=<orientation value>

    Example: PDF link with orientation value as landscape: https://creatorexport.zoho.com/sampleapps/customer-support/pdf/Most_Recent_Solution/&zc_PdfOrientation=landscape
    Example: PDF link with orientation value as portrait: https://creatorexport.zoho.com/sampleapps/customer-support/pdf/Most_Recent_Solution/&zc_PdfOrientation=portrait

  5. The URL format to convert a Page to PDF with the PDF's size is given below. Thevalues can be Letter, A4, Legal, Executive, with default value as Letter.
    https://creatorexport.zoho.com/<app owner name>/<app link name>/pdf/<Page link name>/&zc_PdfSize=<size value>

    Example: PDF link with orientation value as landscape: https://creatorexport.zoho.com/sampleapps/customer-support/pdf/Most_Recent_Solution/&zc_PdfSize=Letter
    Example: PDF link with orientation value as portrait: https://creatorexport.zoho.com/sampleapps/customer-support/pdf/Most_Recent_Solution/&zc_PdfSize=A4

Limitations

  1. Div embedded Forms/Reports inside Pages is not supported as already discussed in this Forum post. (This will be done only after we provide #include support, i.e., server-side include directive in Deluge. Users will have to change to the new implementation once done to enable PDF output). Refer the Limitations page for more details.
  2. Any authenticated content like images/CSS that requires your current credential will not be supported, i.e., any link/embedding in the Page to be converted into PDF, should be public content.
  3. Any CSS/images and other links to be rendered have to be specified in full path. For example, /images/xyz.jpg will not be properly rendered.
Note: Refer this page to see how to Show or Hide the PDF export option in your Page.