It should be pretty straight forward for the user to view their own vendors using per user data as @George_B pointed out as long as the user’s email is on each vendor record.
A few questions I have are:
- Do you plan to allow vendors to edit their own data?
- Will the user be the only one editing data, or is everything view only?
- What will a user or vendor first see when they open the app?
For a vendor to see all other vendors under the parent user, then, assuming you have a vendor email and a user email in each row, I would create a second sheet that is a copy of the first sheet. Name your email columns ‘Email 1’ and ‘Email 2’ on the primary sheet, which will create an array ‘Email’ column. Using per user data (using the virtual ‘Email’ column), the user or vendor will be taken to their own Detail record (This would require the user to also have their own record in addition to vendors. Under there I would create an Inline list and use a relation to link the ‘Email 2’ (User email) column to the ‘Email 2’ (User email) column on the second sheet. This will allow everyone to edit only their own data, but be able to view a list of all related vendors under that user in View Only mode. Now depending on your answers to the questions above, this could change quite a bit, but hopefully this gives you a general idea of how to accomplish this.