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 of complex conditional formulas by allowing you to import a CSV file with your data.

Customizing a Value Lookup element

  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.

How this works?

Value Lookup element looks up a value in a CSV file based on two values. One from the first row and one from the first column.

For the value lookup element to output a result, it needs two values that will be taken from your calculator elements. These values can be static or dynamic based on the customer’s choices.

Here is an example of a correctly prepared sheet for a wallpaper price calculator:

Correctly prepared spreadsheet

The calculator has two input elements, one is used for the customer to input the product width and another to input product height.

Calculator inputs

Value Lookup element in this case is used to find the price for the specific dimensions. One element is added to check the columns, and the other to check the rows.

Finding a value in a spreadsheet

A correctly setup Value Lookup element settings:

Correctly setup element settings

Once the customer inputs Width value to be 60 cm and Height value to be 170 cm, the Value Lookup element finds and returns a value of 305 from the file.


Build calculator for free!