Hey, I playing around with Glide to learn it. I want to use the per-user data option but with column other than email. For example, I have an inventory tab, I want all users in Company A to see their inventory and Company B to only see their inventory. How can I accomplish this?
I would first create an Inventory sheet and a User sheet. In both sheets, create a column called ‘Company’. In the Data tab of the builder, create a Relation column in the Inventory sheet that links the Company to the Company in the User sheet. Next create a Lookup column in the Inventory sheet that uses the Relation you just created, and retrieves the Email from the User sheet. This Lookup column of emails is what you will use for Per User Data.