I have a categories sheet and a products sheet, every product belongs to a certain category,
what I would like the app to do is that when the user modifies the name of a certain category in the categories sheet, the category of all related products will change accordingly in the products sheet.
I feel there is an easy way to do it but I can’t grasp it. Thanks if you will help
What are you looking to change specifically? Can you give us a specific scenario—there are a few solutions depending on what you’re looking to do.
Thanks for answering;
I would like that when the user modifies the name of a certain category in the categories sheet, the category of all related products will change accordingly in the products sheet
To do that, you’d probably really need two “categories” a unique category ID (the one that works behind the scenes as the true “category” and then a category display field that’s what’s seen by the user. Any other than this will break relations between the sheets when the category is renamed.
I think I’d have the user that created the category to manually insert the category two times in that case, and in the products category display it would be a look up?
correct.
Hey MaxB, I made a request to the Glide team to make a native many-to-many relationship if you could give it an up vote we might be able to actually see this feature come to life 