Hello! New Glide user here.
I’m built a small food diary app. It has a main table (Entries).
When adding a new entry, I can select the “meal type” (e.g. “Breakfast”, “Lunch”, …) and a “feeling” (e.g. “Good, no negative effects”, “Bloated”, etc).
The meal types and feelings each have their own table.
Everything is working correctly, but the other day I decided I wanted to change the “feelings” labels to have different emojis so they’re more visually distinct (e.g. change “ Good, no negative effects” to “
Good, no negative effects”).
I thought that, since the “feeling” column in my “Entries” table was getting the selected value from the “Feelings” table, when I updated the “Feelings” table value it would automatically update all the relevant entries already in the “Entries” table. But instead, it only applies the change to newly added entries.
How do I make it so that, when I update a value in the “Feelings” table, that value is updated in all existing entries in the “Feeling” column (in the “Entries” table)? And same question for the meal types.
A couple of screenshots of how this looks in the app:
Any help is appreciated, thank you!