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
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |