In a form, I have a column that is of enum type. The values are Single user, Multiple user, and Multiple users with different access permissions. I then have a number type column to capture how many users there are. Is there a way to set the number column’s value based on the dropdown’s value? E.g, If Enum Column = Single user, Force number column to equal 1?
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
4 |