# Configuring the Formula Builder Using Label and Text Field Elements

Last Updated: May 24, 2022

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.

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

Column 1: Text Field

Place Holder: Value1

Input type: Number

Column 2: Text Field

Place Holder: Value2

Input type: Number

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.

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.

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.

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.

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.

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 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.

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.

#### 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

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.

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.

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.

##### 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.

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 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.

Updated on: 24/05/2022

Thank you!