Change an Enum state using an Action

[Orion_Szathmary]

Rookie question but can’t find the answer. I have an Enum column with 2 states, “JR” and “SR”. I’d like to create an action that simply changes the state from JR to SR or SR to JR but can’t figure out how to toggle/change Enum values with actions.

I’m assuming this is dead simple but, hey, these are the kind of questions you get when you make an app for no-coders

[Marc_Dillon · Accepted solution]

And the expression that you can’t quite see in there is:

IFS(
[enum] = "JR" , "SR" ,
[enum] = "SR" , "JR"
)

replace “[enum]” with your actual column name.

help.appsheet.com

IFS()

First-match conditional evaluation

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

[Vapelynn]

@Marc_Dillon I'm running into the same issue as OP and am trying this solution but I'm not understanding what the virtual column is supposed to do. I made the virtual column and in the App Formula I put my enum column, which in this case is [Status]. However, Appsheet still isn't letting me select the virtual column from the "Set these columns" section when building the action. I am certain I'm using the correct table and built the virtual column in the correct table.

Edit: I should clarify, my initial issue is that the enum list isn't popping up as an option in the "Set these columns" section.

[Marc_Dillon]

There is no virtual column, that was just a poor example column because I probably took 5 seconds to create it, thus the markup text. If the enum column isn't showing as an option, that means it's not editable for some reason.

[Vapelynn]

Oh I see, thank you for explaining this. You were right about it being because it wasn't editable. I Googled that for like an hour and just couldn't figure that one out. Appreciate your help.

[Orion_Szathmary]

@Marc_Dillon, Extremely helpful. Thanks for the quick turnaround!