Hello, I hope someone could help me. Here is my problem:
I have a delivery App, I have one sheet for PRODUCTS (contains Product, Description, Kilogram Price, Unit Price, etc), one sheet for ORDERS, and one sheet for ORDER DETAILS (in this sheet I have all the products that belong to the order).
My ORDER tab is a Detail TAB, it contains all the orders of the current signed in user. When you clic an order it shows data from the order and also an Inline List pointing to a relation to the ORDER DETAIL to show the products. Also I have an “Add Product” button that calls a Form to write data in the ORDER DETAIL sheet.
In that Form I have a Choice component that shows all the products of the Vendor, this choice component points to a relation column, this relation columns matches all the products that belong to the Vendor.
So, when the user selects a product (from my choice compoent) I need to show information from the PRODUCTS sheet like product Price, BUT the product Price belongs to my PRODUCTS Sheet. My question is, How to show a column of another sheet in my Form? I only need to show the price, it won’t be a text entry column.
Any ideas please?
Here is my app if you want to look at it: https://enel54.glideapp.io/