I have columns named 'product' and 'price', both of which are included in my input.
Here's how it's supposed to work: each product comes with a preset price, but users have the option to change it. Therefore, once I select a product from the input, the corresponding price should automatically populate within the input field."
Put [ref to product].[price] in the suggested value of your input field. You should get the price listed in the products table and the user can change it if desired.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |