Add and manage fields
Understand expression
Understand formula field's expression The formula field's Expression is what defines the value it will store and display. For example, the Amount field in an Order form is usually a result of multiplying the values in Unit Price and Ordered Quantity ...Understand Formula Field
The Formula field enables you to automatically generate a value for each record in your form, based on a predefined expression. Let's take an example. The Total Amount in an Order form is calculated based on the Unit Price and Quantity of the ordered ...Manage filter
You can configure your lookup field to display specific data - data that satisfies certain conditions. For this you need to set a filter on it. Refer to the following sections: Set filter for a lookup field Modify a lookup field's filter Remove a ...Enable alphabetical record sorting
Open the form builder. Select the required lookup field. Navigate to the Field Properties > Choices section on the right. Check the checkbox next to Alphabetical Order : Related Topics: Understand lookup field Configure unidirectional relationship ...Allow New Entries and Set Value While Adding New Entries
Allow New Entries You can choose to allow the addition of new entries in a lookup field using a looked-up form. Follow the below steps to configure this: 1. Open the form builder of the target form. 2. Select the required lookup field. 3. Navigate to ...Customize display fields
Customize display fields of a lookup field You can customize the data that a lookup field displays. You can: Select the required fields from the target form (the form that the lookup field displays data from). The lookup field can display data from ...Configure bidirectional lookup field
To configure bidirectional lookup: Navigate to the form builder. Drag and drop the lookup field. The Lookup field window appears. Select the Form from which you need to fetch data. Select the Field . Click the toggle button to Enable bidirectional ...Configure unidirectional relationship
To configure unidirectional lookup: Navigate to the form builder. Drag and drop the lookup field. The Lookup field window appears. Select the Form from which you need to fetch data. Select the Field . Select the appropriate Display Format for the ...Relationship between forms
Relationship between forms A relationship in your Zoho Creator application refers to the link that is created between the data in different forms so that you can achieve a certain level of co-ordination, leading your data to interact with each other. ...Unidirectional and bidirectional relationships
Unidirectional and Bidirectional relationships Relationships can be configured as one way and two way relationships. A unidirectional relationship means that the flow of data is just one way. For instance, you have an Employee Management app with ...Understand Lookup Field
Understand Lookup Field The lookup field enables you to create a relationship between forms. Using this relationship you will be able to lookup data from another form in the same application or from a form in a different application in your Zoho ...Limit maximum entries
Limit the maximum number of entries for subform Open the form builder. Select the required subform field. Navigate to the Field Properties > Display Type section on the right. Check the checkbox next to Limit maximum entries and enter a value of up ...Set default entries
Set the default number of entries for subform field Refer to this page to learn about the SubForm field. Open the form builder. Select the required subform. Navigate to the Field Properties > Display type section on the right. Check the checkbox next ...Customize field width for subform
Open the form builder. Select the required subform. Navigate to the Field Properties > Field width customization section on the right. Select the required choice. If you select Adjust field width manually , you will need to set the field width in ...Add subform field to your form
Open the form builder. Add a subform field to the form. (Refer to this page to learn how to add a field to a form) If your app does not have any additional forms, Zoho Creator will add a blank subform If there are forms in your app, Zoho Creator will ...Understand subform field
The subform field enables you to display a form within a form. The form in which you add a subform is referred as the main form. Refer to the following sections to learn about subforms: Appearance When to use this field Understand adding a subform ...Signature
The signature field allows a user to draw their signature and thus enables you to collect electronic signatures. This field comes in handy when you require your users to authenticate (by signing) the data they submit through your form. Features With ...Set duration
Set duration for video field Refer to this page to learn about the Video field. Open the form builder. Select the video field. Navigate to the Field Properties > Duration section on the right. Set a duration of up to 5 minutes: If you set a duration ...Understand video field
When accessed via your iOS devices' browsers, you can upload video files but you cannot record them via the video field. This is because media objects are not supported by iOS. When accessed via Safari browser, you can upload video files but you ...Set duration for audio field
Set duration for audio field Refer to this page to learn about the Audio field. Open the form builder. Select the audio field. Navigate to the Field Properties > Duration section on the right. Set a duration of up to 30 minutes: If you set a duration ...Understand audio field
Understand audio field When accessed via your iOS devices' browsers, you can upload audio files but you cannot record them via the audio field. This is because media objects are not supported by iOS. When accessed via Safari browser, you can upload ...Set browse options for file upload field
Set browse options for file upload field Refer to this page to learn about the File upload field Open the form builder. Select the required file upload field. Navigate to the Field Properties > Browse Options section on the right. Check the required ...Understand file upload field
The File Upload field enables your users to upload a file while submitting their data through your form. Your users can select the file either from their device (in the device's local storage) or from any of cloud storage services we support. The ...Image properties
Set image properties for image field Refer to this page to learn about the Image field The image field allows you to perform the following customizations for the user experience of the image field in your form: Aspect ratio Compression Browse options ...Mobile properties
Set mobile properties for image field Refer to this page to learn about the Image field. Edit your app. Open the form builder. Select the image field. Navigate to the Mobile Properties section, then select the required properties: Set the Default ...Understand image field
When accessed via your iOS devices' browsers, you can upload images and attach image URLs but you cannot capture them via the image field. This is because media objects are not supported by iOS. When accessed via Safari browser, you can upload images ...Enable entering link name and title
Enable entering link name and title in URL field Open the form builder. Select the URL field. Navigate to the Field Properties > Appearance section on the right. Check the check boxes next to Link Name and Title : Related Topics: Understand URL field ...Set target
Set target for URL field Open the form builder. Select the URL field. Navigate to the Field Properties > Appearance section on the right. Select the required choice from the dropdown next to Target : Related Topics: Understand URL field Enable ...Understand URL field
Understand URL field The URL field enables your users to enter a URL (Uniform Resource Locator) - the link to a website or web page. Below is how a URL field looks on a form: When a user accesses from a web browser: When a user accesses from a phone ...Add auto number field
Add an auto number field to a form Open the form builder. Add an auto number field to the form. (Refer to this page to learn how to add a field to a form) Enter the required number in the window that appears, then click Done . Note: The Start Index ...Understand auto number field
Understand auto number field The Auto Number field enables you to associate a sequential numeric value to each entry your users submit through your form. The number held by this field is automatically assigned immediately after your users submit an ...Set display format
Set display format for currency field Refer to this page to learn about the currency field's Display format property. Edit your form. Select the required currency field. Its Field Properties will appear on the right. Select the required value from ...Set currency type
Set currency type for currency field Refer to this page to learn about the Currency field. Open the form builder. Select the currency field. Navigate to the Field Properties on the right. Select the required choice from the dropdown next to Currency ...Understand currency field
Understand currency field The currency field enables your users to enter a monetary value. It displays a currency symbol and allows entering a decimal value. Below is how a currency field looks on a form: When a user accesses from a web browser: When ...Understand percent field
The percent field enables your users to enter a percentage input. It displays the % symbol and allows entering decimal values. Character limits The percent field can accept a number that contains a maximum of 19 digits. This is inclusive of the ...Understand decimal field
The decimal field enables your users to enter decimal values, for example: -544.78, -23.3, 0, 889, 14324.225, etc. Character limits The decimal field can accept a number that contains a maximum of 16 digits. This is inclusive of the decimal point and ...Understand number field
The number field enables your users to enter an integer value, for example: -544, -23, 0, 889, 14324, etc. Below is how a number field looks on a form, When a user accesses it from a web browser: Character limits The number field can accept a maximum ...Set minutes interval
Set minutes interval for time and date-time fields Refer to the following pages to learn about the Manage seconds property in the context of the time and date-time fields. Open the form builder. Select the required field. Its Field Properties will ...Manage seconds for time and date-time fields
Refer to the following pages to learn about the Manage seconds property in the context of the time and date-time fields. Open the form builder. Select the required field. Its Field Properties will appear on the right. Navigate to the Time Picker - ...Set allowed hours
Set allowed hours for time and date-time fields Open the form builder. Select the required field. Navigate to the Field Properties -> Validation section on the right. Set the required hour range (in the 24-hour time format) using the dropdowns below ...Next page
Access your files securely from anywhere
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 Bigin?
New to Zoho Survey?
New to Zoho LandingPage?
Zoho LandingPage Resources
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
Zoho Creator Resources
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?