How to set calculation values for product dropdown in Input Table.

I have products listed and prices listed in separate columns.

How do I get 1 price for the product to show up in the prices column, when I choose a product in the products column?

Howdy regisrhonda,

Unfortunately what you're asking for would require Calculation Values to be applied to the Dropdown field, which is not possible with the input table. You can use Calculation Values with the Input table, but it can only apply to the Radio or Checkbox field types.

However, you can include the price information in the Product name and calculate your Total price with only the Quantity and Product information.

This works because the Calculation is ignoring the text information and only calculating the numbers available in the Product name. This means that your products can't contain numbers other than the price.

You may clone this Demo Form that I have created to further investigate the settings. Otherwise, here are the 3 conditions that are working on each row.

And here is an example of the full condition affecting the 3rd row.

Please let us know if there's anything else we can help you with!