LinkedIn
Twitter
I have created linked tables in Appsheet with the "ref" primary field. When a user scans the order ID, the items sold under that order ID are displayed. However, I have created a barcode scanning field in expanded view so that the user can see which items are sold under that order ID and scan it. Post scanning I have created a "Status" field with a formula that would show the user "โ
" if the item he has scanned matched with the item in the list.
But, for instance, If order ID - 1111 has 3 items, and when the user clicks on any of the three items the view displays only the first entry even if clicks on the second row. Refer to the attached screenshots to get an idea about the error.
Table - AppSheet_Order_ID and AppSheet_Order_Details are linked with the key field (ref)
