How can I create an action that changes the value of one item in an EnumList but leaves other values intact?

jthurston
Participant V

Hello,

I am trying to use AppSheet to create an app that will help us manage student registration. There are multiple steps in the process, and I want to use an EnumList (“Progress” column) to keep track of which steps students have completed.

I was able to create an action that sets the value of the EnumList to “Test date scheduled”, which is one of the options available in the EnumList dropdown. I was also able to create a workflow that successfully triggers this action when a student submits a form. However, my action erases all of the other checks.

Is there a way to set up the action such that a specific item from the EnumList is checked while other items are unchanged?

Thank you,

Solved Solved
0 4 249
1 ACCEPTED SOLUTION

Try replacing the value here:

3X_6_9_69056fc9d3357c3437fced7492cddf8599d69106.png

with this expression:

SORT(
  [OO Progress]
  + LIST("4. Test date scheduled")
  - LIST("")
)
  1. [OO Progress] starts with the current list.

  2. ... + LIST("4. Test date scheduled") adds another item to the list from (1).

  3. ... - LIST("") removes duplicate and blank values from the list from (2).

  4. SORT(...) sorts the list resulting from (3).

See also:

View solution in original post

4 REPLIES 4

Steve
Participant V

Please post a screenshot of the action configuration.

Try replacing the value here:

3X_6_9_69056fc9d3357c3437fced7492cddf8599d69106.png

with this expression:

SORT(
  [OO Progress]
  + LIST("4. Test date scheduled")
  - LIST("")
)
  1. [OO Progress] starts with the current list.

  2. ... + LIST("4. Test date scheduled") adds another item to the list from (1).

  3. ... - LIST("") removes duplicate and blank values from the list from (2).

  4. SORT(...) sorts the list resulting from (3).

See also:

jthurston
Participant V

It worked! Thanks so much, and thank you for the helpful links as well!

Top Labels in this Space