Is it possible to have an app formula on a list of Enum values i.e. a formula that selects the Enum values for you or does it have to be text?
I have a form that requires users to go in and request approval - to request approval the Enum value is selected.
I have a reset on edit condition based on whether this approval is rejected/accepted. If the rejection is accepted I want them to be able to edit the form again but I can’t do that when the value has been reset to blank.
I would like certain users to be able to select certain enum options if thats possible even?
So something like this as the suggested and valid if
IF(
[ColumnA]=“foo”,
LIST(“A”,“B”,“C”),
LIST(“D”,“E”,“F”)
)
If I had two users i.e. User A and User B
So User A can see “Pending Approval”, “Approved”, “Rejected” as enum values.
User B can only see Pending Approval.
Can I apply an app formula so that the button auto selects the right option.
I want user B to be able to request approval when they open the form but I can only do that if I can reset the value in some way, the value cant be blank because then it cant be edited
Sorry the explanation is poor
You might need to tick “Allow other…” as well
IFS(
UserEmail()=“john@doe.com”,LIST(“A”,“B”,“C”),
UserEmail()=“john@smith.com",LIST(“D”,“E”,“F”)
)
The display of different Enums seems to work fine, but I can’t get the app formula to update the enum selection automatically unfortunately
