Remove Select List Item

1

I would like to delete a select list item from all rows. For example, let’s say that Colors is a multi-select list column with the entries “Red, Green, Blue”. Thus, each row can have zero or more of these values selected.

Now let’s say I want to remove “Blue”. I can remove it from the column’s select list, but it still remains in all rows previously containing “Blue”. How can I remove this value from all rows without destroying the other values for that row. For example, if a row is marked as “Red, Blue”, it should end up being just “Red”.

My plan is to use a FormulaMap inside a button, but I am not sure how to “subtract” a value from a select list within a row. Something along the lines of:

Rooms.FormulaMap(
  CurrentValue.ModifyRows(Rooms.Colors, CurrentValue.Colors - "Blue")
)
2

Hey! The easiest way is to do it like:

Rooms.FormulaMap(
  CurrentValue.ModifyRows(Rooms.Colors, CurrentValue.Colors.Filter(CurrentValue != "Blue"))
)
1 Like
3

Perfect. Note that I had to add a filter before the FormulaMap to avoid errors on blank entries:

Rooms.Filter(CurrentValue.Colors.IsNotBlank()). FormulaMap(...)