I have 3 sheets in my Google Sheet: Sellers, Products, Offers.
In the App, I have 2 tabs: one with the list of sellers and one the per-user data view.
I would like to allow each seller to update its products and offers. I used the seller sheet on the per user data tab view, which is nice because I can update the information displayed in the sellers sheet.
Then I used 2 inline lists to display:
- The list of products related to the seller
- The list of offers related to the seller
When I click on one product in the list of products, it displays the details of the product. I activated the edit mode there. (Path: Per user data tab > List of offers (Inline list) > Product A)
Unfortunately, it also activates the edit mode when this page is accessed from the global list of sellers. (Path: All Sellers tab > Seller 1 > Product A). This means that any user would also be able to add and edit the product details of any seller.
Do you know how I could allow the edition based on the seller email address for the products and offers and seller details (ideally on the same page)?
Thanks in advance for your help!