Basic question re option fields

Imagine I have a table ‘tasks’ with a field for ‘priority’ that I only want to be the options of Low Medium or high, what is the established way to to this in Glide so that add and edit forms work well.

I’d usually have table for options with a group, or just an enum if I’m working in SQL. I can’t see either is an option. are people just creating different options tables for each, so in this case, option_taskpriority with three rows? Or, is there a more elegant solution?

Start with this thread and follow the other thread I shared in there.


Thanks Jeff. Oddly comforting to see other people musing over the same things!


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.