Customizing a Value Lookup element

The Value Lookup element is designed to simplify calculations by finding a value from a spreadsheet table based on the user input values. It eliminates the need to complex conditional formulas by allowing you to import a CSV file with your data.

1. The Element Label input field lets you name your element and the toggle beside it controls whether the title is visible or hidden
2. The Element Tooltip is a text field that lets you give more context to each element or explain what information you require to input. Once enabled, it will appear as a small info icon next to the element title.
3. The Import CSV button allows you to browse files on your device.
4. Check columns and rows selectors control which elements’ input values are used to look up imported table data.
5. The Display Value toggle controls whether the element is visible or hidden.
6. The Show value only in email notifications toggle allows hiding the element from a calculator but includes its value in email notifications (using the Mail Results or Order Form tools).
7. The Reveal value after submission toggle makes the value will appear only after a successful submission is made via Order Email or Mail Results elements
8. The Decimal Places slider lets you choose how many numbers are visible after the decimal point for a more accurate result.
9. The Prefix input field lets you choose what you want to be written before the result.
10. The Postfix input field lets you choose what you want to be written after the result.

How to prepare a CSV file?

CSV file has to be prepared in a specific in order to correctly import into the Value Lookup element.

• The first row’s and A column’s data in the file will be used to find the value from a table.
  • The first row’s data corresponds to the element’s value selected in the Check columns selector.
  • The A column’s data corresponds to the element’s value selected in the Check rows selector.
• The first row’s and A column’s data can be expressed as a range or specific value. Then expressed a range, the cell has to maintain the x to y format; the word to must be used between two values. E.g. 1 to 10
  Two ranges should not overlap or share the same range’s start/end value. Example of incorrect ranges:
  1 to 5 and 3 to 10
  or
  1 to 5 and 5 to 10

Correctly prepared first row and A column:

• The decimal separator must be a period (or full-stop) symbol for any value in the spreadsheet.
• The value table must contain numeric values only - any text usage might result in an error.

Correctly prepared spreadsheet:

Once the spreadsheet is prepared correctly, export/download it in CSV format and import it to the Value Lookup element.