System Variables
This guide will help you with the following:
1. Date Variables - zoho.currentdate
- zoho.currenttime
- zoho.loginuserid
- zoho.adminuserid
Date Variables
zoho.currentdate
Returns the current date in the format as specified in the Application Settings dialog.
- info "zoho.currentdate "+zoho.currentdate;
zoho.currenttime
Returns the current date along with the time value.
- info "zoho.currenttime "+zoho.currenttime;
Example 1:
To get the current date and time and input it into a field upon success,
- Create a Date-Time field, for example, named TimeStamp
- In the onAdd ->on Success section and on Edit ->on Success sections of your Form, add the following script code, where zoho.currentime is the Deluge system variable which returns the current time. The current time will be updated in the field named TimeStamp. You can also disable the field so that it is not edited by users.
- input.TimeStamp = zoho.currenttime;
Every record in every table (form) has two fields (Added Time and Last Modified Time) that ZOHO Creator automatically updates when ever a Form is clicked on the Submit or Update Buttons, so you could elect to show these fields in your List View. Refer the topic Display username and time for more information.
String Variables
zoho.loginuserid
Email id of the logged in user is available as Zoho variables in all the applications created using Zoho Creator. The variable zoho.loginuserid can be used in scripting to write logic based on the user viewing your application. For example: You can have an application in Creator where you have data related to all your customers but you can make sure that each customer is able to view only those records that belong to him, based on their logged in emailid.
The table given below lists the zoho variables and value returned by the variables in a private and public application.
Example 1:
In the following sample code, userid field will display the current login email id of the user.
- userid
- (
- type = formula
- value = zoho.loginuserid
- )
Example 2:
In a leave application, users will submit their leave in the leave form. When a user logs in, he will see only the leave details belonging to him.
- list "My Leave Details"s
- {
- show all rows from emp_leave_form [Employee_email == zoho.loginuserid]
- (
- Employee_email as "Employee email"
- Leave_type as "Leave type"
- From_Date as "From Date"
- To_Date as "To Date"
- Reason
- )
- filters
- (
- Leave_type
- From_Date
- )
- }
Code Explanation:
[Employee_email == zoho.loginuserid] - The filter to display only the leave details of the current user
where,
- 'Employee_email' is a field in the form emp_leave_form
- 'zoho.emaild' is the deluge variable.
- 'zoho.emaild' is the deluge variable.
zoho.adminuserid
The variable zoho.adminuserid returns the emailid of the application owner. It can be used in scripting to write logic based on the user viewing your application. For example, you can make sure that certain views can be accessed only by the admin user (application owner) by adding the following criteria to your view:
show all rows from <form_name> [<email_field_name>l == zoho.adminuserid]
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
System Variables
System variables are a special class of predefined variables, which are already defined by the system, and values are assigned by the system it self. These variables are read-only. They contain values that cannot or should not be changed by the ...Variables
Overview A variable is the address of a temporary value in the computer memory. Every time we declare a variable with a value, it gets stored in a certain address in RAM. And the variable name is the usual way to refer to the stored value. How is a ...Developing Third-party Integrations - Custom Variables
The guide will help you with the following: Create a custom variable The Variable VariableMap Example Create a Read-only custom variable Create a Hidden custom variable Custom variables are global variables that store information in your CRM. These ...Integrating with third-party applications
Each industry comes with a unique set of problems to solve. To accommodate this diversity within the business world, we've created the Zoho Developer console, which allows you to integrate almost any third-party application with your CRM ...Building a Real Estate CRM
Zoho Developer Console allows developers to transform your CRM into an industry specific CRM solution. A real estate CRM needs to manage comprehensive and comparative details about properties, offer ease in handling Buyer and Client data and provide ...
New to Zoho LandingPage?
Zoho LandingPage Resources