Say I have an Enum column in a table with options A,B,C,D. Record creation for this table happens in two different ways; manually by the user, and automatically via a button press. I only want the user to be able to select from A and B, but want the auto-creation to be able to use C and D. I do NOT want options C and D to even be seen in the dropdown to the user.
I have actually solved this problem by experimenting with different things while typing up this post, although Iโm not positive Iโve done it in the best way. It was an interesting situation to solve. I donโt want to sway anybodyโs thought processes, so Iโll delay posting my solution for a bit
Assuming the user would only be editing the column value from a form, try a Valid If expression of:
LIST("A", "B")
+ IFS(
("form" <> CONTEXT("ViewType"))
LIST("C", "D")
)
OK, cool, thatโs exactly what I did.
User | Count |
---|---|
43 | |
29 | |
23 | |
20 | |
13 |