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!