Configuring the Formula Builder Using Label, Dropdown and Radio Button Elements
Last Updated: July 15, 2021
This element lets you provide a short label or description in your form. It also becomes associated with the Dropdown and Radio Button when you allow the Has Lookup function which calls the Formula Builder. You can use the Formula Builder to set up some calculations on your Form.
To set up the Formula Builder using Label and Text Field Elements, follow the steps below:
Step 1: Before we proceed with the Formula Builder, the first thing we have to do is to add at least two columns.
Step 2: Drag either a dropdown or radio button inside the columns.
Step 3: Allow the Use in Expression Builder function so we can use the data from our dropdown or radio button into the Formula Builder that we will set on our Label field. But for this example, let us use the radio button element for both columns.
Step 4: Add a Value to its option.
You can try using these Sample Column Configurations for this step:
Column 1: Radio Button
Place Holder: Sample Value1
ID: 1
Display Value: Option 1
Value: 100
Column 2: Radio Button
Place Holder: Sample Value2
ID: 2
Display Value: Option 2
Value: 200
Step 5: After configuring the first two columns, add another column and drag a Label element inside. Let us set the place holder of this column as Total.
Step 6: Activate the Has Lookup function and the Formula Builder will appear.
For the Formula Builder part, we need to have at least two expressions to call the Value of the columns where we allowed the Use in Expression Builder function before.
Step 7: Once the Formula Builder appears, click the (+) plus sign to add another expression.
Step 8: Then select the operator (Add, Subtract, Multiply, Divide) you want to use to determine how to get the total of the columns.
You can try using these Formula Builder Configurations for this step:
Expression 1: Sample Value1
Operator: Add (+)
Expression 2: Sample Value2
Step 9: Save the configuration you made once done, and try to see its desktop preview to test out how this actually works.
In this example, the value we set for Sample Value1 = 100, and the value we set for Sample Value2 = 200. So when we click the buttons for these fields, the system will automatically compute its total, and the output will be shown in the Total field.
PREVIOUS ARTICLE: 2.4.3. Dropdown, Radio Button and Checkbox Elements
NEXT ARTICLE: 2.4.3b. Configuring the Formula Builder Using Label and Text Field 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 the Dropdown and Radio Button when you allow the Has Lookup function which calls the Formula Builder. You can use the Formula Builder to set up some calculations on your Form.
To set up the Formula Builder using Label and Text Field Elements, follow the steps below:
Step 1: Before we proceed with the Formula Builder, the first thing we have to do is to add at least two columns.
Step 2: Drag either a dropdown or radio button inside the columns.
Step 3: Allow the Use in Expression Builder function so we can use the data from our dropdown or radio button into the Formula Builder that we will set on our Label field. But for this example, let us use the radio button element for both columns.
Step 4: Add a Value to its option.
You can try using these Sample Column Configurations for this step:
Column 1: Radio Button
Place Holder: Sample Value1
ID: 1
Display Value: Option 1
Value: 100
Column 2: Radio Button
Place Holder: Sample Value2
ID: 2
Display Value: Option 2
Value: 200
Step 5: After configuring the first two columns, add another column and drag a Label element inside. Let us set the place holder of this column as Total.
Step 6: Activate the Has Lookup function and the Formula Builder will appear.
For the Formula Builder part, we need to have at least two expressions to call the Value of the columns where we allowed the Use in Expression Builder function before.
Step 7: Once the Formula Builder appears, click the (+) plus sign to add another expression.
Step 8: Then select the operator (Add, Subtract, Multiply, Divide) you want to use to determine how to get the total of the columns.
You can try using these Formula Builder Configurations for this step:
Expression 1: Sample Value1
Operator: Add (+)
Expression 2: Sample Value2
Step 9: Save the configuration you made once done, and try to see its desktop preview to test out how this actually works.
In this example, the value we set for Sample Value1 = 100, and the value we set for Sample Value2 = 200. So when we click the buttons for these fields, the system will automatically compute its total, and the output will be shown in the Total field.
RELATED ARTICLE(S):
PREVIOUS ARTICLE: 2.4.3. Dropdown, Radio Button and Checkbox Elements
NEXT ARTICLE: 2.4.3b. Configuring the Formula Builder Using Label and Text Field Elements
Need more help? Send us an email at customersuccess@quickreach.co, or send us a message on the chat widget.
Updated on: 15/07/2021
Thank you!