Append Value to Enum List Column?

What is the correct action/procedure for adding a value to a column? The column in question is an Enum List type, and I want to create an action that adds the value “CCM” to the column in question.

I don’t think I can use the “set value of column” action, but then again, perhaps there is an expression I can use to append a value to the current values?

UPDATE: I think i may have found an answer. Trying

([NonMedical Flags]+LIST(CCM))

2 Likes

This worked, though i did need to ensure that the column was actually an Enum List and not an Enum :joy:

2 Likes

Indeed: list math is a thing in AppSheet

FYI: You can also remove values from the list just as easily as you added them

2 Likes

thank you, i found that as well and added an inverse action. This is great for locking down the finer details of a column but allowing specific users to only adjust specific things.

1 Like