I’ve some issue with my app. Maybe I use wrong way to do things.
I’ve 2 tables : USERS and CATEGORIES. In the USERS’ table, there are 10 column with same name and numbered (CAT 1 CAT 2 CAT 3 etc) that are populated by an arrayformula in Google Sheet, like this :
Because users fill a Google Form, writing in the E column with multiple choices, comma separated.
In this USERS table, Glide nicely create a Relation column named CAT.
In the CATEGORIES table, I’ve created a list of those same categories, with a Relation Column.
So I can display in Glide a list of Categories, based on the CATEGORIES table, and when users click on a category, they see all users in this category.
Everything was OK since I decided to add a new category, so a new row in the CATEGORIES table.
The CAT column in USERS table is well update, users choose a new category, and I see it in this auto-generated column, however, the row of this new category in the relation column in the CATEGORIES table does not update with users ID
So for now, I can’t display users in this new category…
Maybe I do something wrong. I try to create a new relation column in the CATEGORIES table, the old rows are all well populated but not the new cat row…
Hope I can find some help here !