Data Lookup
This element allows your customers to enter two inputs and based on those inputs the calculator will look up the value from a table and use it in a formula.
You can also use the inputs as values in the formula and not only the matched value.
Step 1: Add the element
Drag and drop the lookup element to your calculator canvas.
Step 2: Update the properties
Each Data Lookup element has two number inputs. For each you can control the name, minimum value, maximum value and number of decimals allowed to input.
Minimum Value: this value will be set depending on the first number inserted to the table. These are the values of cells B1 and A2.
Maximum Value: this is set on the properties of the element. Any value inserted between the final number in the row/column to the maximum input allowed will match the data against the last column/row (more information and examples below).
Formula based values: You can toggle on the formula option for each input if you want the number input to be based on an input from another element. If you select this:
It will disable the conditional display for the data lookup element
The input will be hidden from the calculator as there is no longer any input needed
Step 3: Update the data values
Click on Update Data and table input will appear. You can then paste data from Excel or Google Sheets or manually type them in.
Row 1: In each column of row 1 insert the values that will be matched against your customers first input (Input Box 1)
Column A: In each row of column A insert the values that will be matched against your customers second input (Input Box 2)
Ranges:
The input values will be matched against the data in a range. Examples from table below:
Any number input by your customer between 10-19 (including) will be matched against the values in column B.
Any number input by your customer between 40-49 (including) will be matched against the values in column E.
Any number input by your customer between 90 and your maximum allowed value (including) will be matched against the values in column J.
Note: Same logic applies for Input 2
Your customer's inputs will be matched against the values of the table. Here are some examples based the image above:
Step 4: Add the element to your formula
To add the matched value to your formula all you have to do is insert the element name. You can also use any of the two inputs inserted by your customer to you formula by doing the following:
ELEMENT LABEL [INPUT 1 NAME]
Just don't forget to use "[XX]"
Note: Same logic applies to Input 2
You can also use the inputs as values in the formula and not only the matched value.
Step 1: Add the element
Drag and drop the lookup element to your calculator canvas.
Step 2: Update the properties
Each Data Lookup element has two number inputs. For each you can control the name, minimum value, maximum value and number of decimals allowed to input.
Minimum Value: this value will be set depending on the first number inserted to the table. These are the values of cells B1 and A2.
Maximum Value: this is set on the properties of the element. Any value inserted between the final number in the row/column to the maximum input allowed will match the data against the last column/row (more information and examples below).
Formula based values: You can toggle on the formula option for each input if you want the number input to be based on an input from another element. If you select this:
It will disable the conditional display for the data lookup element
The input will be hidden from the calculator as there is no longer any input needed
Step 3: Update the data values
Click on Update Data and table input will appear. You can then paste data from Excel or Google Sheets or manually type them in.
Row 1: In each column of row 1 insert the values that will be matched against your customers first input (Input Box 1)
Column A: In each row of column A insert the values that will be matched against your customers second input (Input Box 2)
Ranges:
The input values will be matched against the data in a range. Examples from table below:
Any number input by your customer between 10-19 (including) will be matched against the values in column B.
Any number input by your customer between 40-49 (including) will be matched against the values in column E.
Any number input by your customer between 90 and your maximum allowed value (including) will be matched against the values in column J.
Note: Same logic applies for Input 2
Your customer's inputs will be matched against the values of the table. Here are some examples based the image above:
| Input 1 | Input 2 | Returned Value |
|---|---|---|
| 10 | 1 | 1 |
| 15 | 1 | 1 |
| 43 | 13 | 55 |
| 1500 | 1 | 113 |
| 9999 | 5 | 117 |
Step 4: Add the element to your formula
To add the matched value to your formula all you have to do is insert the element name. You can also use any of the two inputs inserted by your customer to you formula by doing the following:
ELEMENT LABEL [INPUT 1 NAME]
| Name | Description |
|---|---|
| ELEMENT LABEL | The label name your provided for the Data Lookup element |
| INPUT 1 NAME | The you chose for your input. This is what is actually displayed to your customers. |
Just don't forget to use "[XX]"
Note: Same logic applies to Input 2
Updated on: 04/08/2022
Thank you!