How can I force select one of the choices of an enum, based on another choice from a different column?
To be more specific; I have two different enum column.
One of them lists different grades: 1st grade, 2nd grade, 3rd grade etc, all the way to 8th grade.
The second enum lists the book different grades work on: Book Level 1, Book Level 2, Book Level 3.
Now the way this works is that students from โ1st grade-3rd gradeโ work on โBook Level 1โ.
Students from โ4th grade-6th gradeโ work on โBook Level 2โ
Students from 7th grade-8th gradeโ work on โBook Level 3โ
How can I implement an action, where if I select a specific grade, it would automatically select the correct Book from the enum. For example, if I selected a student from 5th grade, it would automatically select โBook Level 2โ. That way I would be able to make the book level enum hidden, and users wouldnโt have to select it because it would happen automatically.
If anyone has a tutorial or explanation, I would greatly appreciate it. Thanks!
LinkedIn
Twitter
