Last Updated: May 24, 2022

Label

This element lets you provide a short label or description in your form. It also becomes associated with Text Field when you allow the Has Lookup function which calls the Formula Builder. You can use the Formula Builder to set up number, date, and time calculations on your Form.

PREREQUISITES
Step 1: Before we proceed with the Formula Builder, the first thing we have to do is to add at least two fields.
Step 2: Drag a text field element for both fields.
Step 3: Configure both Text Fields (both text fields must be of the same Input Type to be computed):
Number
Date
Time

I. Formula Builder: Numbers

Column 1: Text Field
Place Holder: Value1
Input type: Number

Column 2: Text Field
Place Holder: Value2
Input type: Number

Sample Text Field Configuration

Step 1: Set the Input Type as Number.
Step 2: After configuring the first two columns, the next thing you have to do is to add another column and drag a Label element inside. Let us set the place holder of this column as Total.
Step 3: Activate the Has Lookup function and the Formula Builder will appear.

Formula Builder appears after toggling Has Lookup function

For the Formula Builder part, we need to have at least two expressions which will call the data of the columns upon filling-up in the form.

Step 4: Once the Formula Builder appears, click the (+) plus sign to add another expression.
Step 5: Then select the operator (Add, Subtract, Multiply, Divide) you want to use to determine how to get the total of the columns.

II. Formula Builder: Date
Column 1: Text Field
Place Holder: Start Date
Input type: Date

Column 2: Text Field
Place Holder: End Date
Input type: Date

This setup also works for System Date element

Step 1: Set the Input Type as Date.
Step 2: After configuring the first two columns, the next thing you have to do is to add another column and drag a Label element inside. Let us set the place holder of this column as Duration.
Step 3: Activate the Has Lookup function and the Formula Builder will appear.

Formula Builder appears after toggling Has Lookup function

For the Formula Builder, we need to have at least two expressions which will call the data of the columns upon filling-up in the form.

Step 4: Once the Formula Builder appears, toggle the Date radio button.
Step 5: Select the two date fields we just created and save the configuration.



Once both date fields are filled, the Label field automatically computes the duration in days.

III. Formula Builder: Time
Column 1: Text Field
Place Holder: Start Time
Input type: Time

Column 2: Text Field
Place Holder: End Time
Input type: Time

This setup also works for System Time element

Step 1: Set the Input Type as Time.
Step 2: After configuring the first two columns, the next thing you have to do is to add another column and drag a Label element inside. Let us set the place holder of this column as Hours.
Step 3: Activate the Has Lookup function and the Formula Builder will appear.

Formula Builder appears after toggling Has Lookup function

For the Formula Builder, we need to have at least two expressions which will call the data of the columns upon filling-up in the form.

Step 4: Once the Formula Builder appears, toggle the Time radio button.
Step 5: Select the two time fields we just created and save the configuration.



Time computation preview

Time is computed in decimals:
60 Minutes/1 hour = 1
30 Minutes = 0.5

ⓘ NOTE: Aside from the Text Field element, you can also configure the Formula Builder using the Dropdown and Radio Button elements. To learn more about it, click here.

RELATED ARTICLE(S):
PREVIOUS ARTICLE: 2.4.3b: Configuring the Formula Builder Using Label, Dropdown and Radio Button Elements
NEXT ARTICLE: 2.4.4: Scanner and Geolocation Elements

Need more help? Send us an email at customersuccess@quickreach.co, or send us a message on the chat widget.
Was this article helpful?
Cancel
Thank you!