Users only able to see specific data when they log in

Ask the community
1

Hello everyone, I am new to the community and to Softr in general. I am building a marketplace/inventory management app for a client. Specifically its a Auto Fair where people can upload their vehicle information.

The current issue I am facing is that I want a user to be able to sign up and upload their inventory, but I want them to be able to login and only see and edit their own inventory. Right now i can only get it to show all uploaded inventory. I am using Google Sheets as my database and I have 2 sheets labeled “Users” and “Vehicles”. When they sign up, their info goes to the “Users”, and when they fill out the info to add a vehicle, the info goes to the “Vehicles” sheet. I am just not sure how to associate the specific vehicles with the specific users so when they login to their profile, they can only see/edit their own vehicles.

Apologies if it is something simple or been addressed here before. I have read countless topics here that are closely related, but I have been unable to find an actual answer. Thanks so much for your help!

2

Welcome!

You’ll need a third table (a junction table):

Example Structure:
• Sheet1: “Customers” (Column A: CustomerID, Column B: Name)
• Sheet2: “Products” (Column A: ProductID, Column B: Product Name)
• Sheet3: “Customer_Products” (Column A: CustomerID, Column B: ProductID, Column C: Purchase Date)

Check this out

And this

1 Like
3

Thank you so much! Super helpful and I’ve got it working how I intended. Thanks again!

1 Like