Multiple choices input (like enum list) for a Ref type column

I know how to create a ref type, choose input as dropdown, and add “allowed values” with a validif constrain.

My question is basically how to choose the input type for the form view as an enum list (thus allowing me to choose multiple options), while still referencing another table?

The use case is assigning tasks to team members, in case it helps.

So is there such a thing as maybe "reversed references?

The reason for not simply going with the “enum list” column type is because I want to have a “related tasks” under my “team members” table view

Solved Solved
1 36 7,242
1 ACCEPTED SOLUTION

I was able to find the error, thanks. I named a form in the UX same as I had in the sql and that was the error. Moving forward, I now need to query, what they are are looking for is indeed available and then save the record.

View solution in original post

36 REPLIES 36
Top Labels in this Space