Good afternoon, I am just starting with Glide and I would appreciate it if you could help me.
The project is to enter stock for different products in various stores, for example:
=I have the “products” table, previously entered
=I have the “addresses” table for the different stores
Through the app, how can I access the window for store N1, add the existing products from the “products” table, and have it only display the products I select for store N1 (allowing them to be entered with images and additional data)?
And the same if I access the window for Store 2, the data comes from the same ‘products’ table, but the display and data should only belong to the entered store.
Glide documentation is very good in my opinion. Best to start there I think or with a template from the template store. Good luck 
- Add a collection for stores.
- Add a column to the “Products” table to determine which store the product belongs to (collect the Store IDs here).
- If you plan to have a product for multiple stores, you can do that as well. Use a choice component and it will be stored as a comma-delimited list.
- Create a Split Text column to split the Store IDs into an array.
- Create a relation from the Stores table to the Products table using the rowID column > array column, make it multiple matches, and then use that relation for displaying a collection inside the store’s details view.
2 Likes