Hi, I am an inventory control consultant in hospitality & am looking to make a simple Glide app to help with day to day activities in the venues. Presently I have a Google sheets based recipe costing solution for my clients but want to migrate this to a Glide app. I am struggling with a simple concept 1) Is it possible to assign multiple prices to items in the “ingredient” tab of the sheet. Each venue has a different price negotiated with suppliers & I want to reflect the price relevant to the venue when they cost a recipe. I thought about having multiple Ingredient tabs for each Venue but that seems very inefficient if you can use relationships & user access control to show their own ingredients & pricing.
Thanks in advance for the advice.