Trying to understand best practice in terms of how I can keep a linked record field automatically in-sync. Here’s some context and how Im currently accomplishing it:
I have two main tables:
Each student will be put into one of the following classes based on their "comfortability with the force"
The goal: Keep each class list of students updated without having to manually select or put them in that table.
How Im currently accomplishing it:
I have a column that is filled via a form (scale of 1-5) and then I have an automation running that simply says:
- When record matches condition: Comfortable using force level = 1 (#1 in screenshot)
- Then: Update that record as someone for the beginner class (#3 in screenshot)
This then updates the link record field in my
Is this best practice in terms of how to keep my class roster/table automatically updated? It feels a little clunky. Thanks! Any help you can give is super appreciated