keyboard_arrow_left Back to Knowledge Base

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.

Correctly prepared first row and A column: Table row and column

Correctly prepared spreadsheet: Final table

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

Build calculator for free!