Remove a value from a checkbox?

I’m using the following formula attached to a button in a view to add the value “Corolla” to a checkbox (Enter choices - one per line, Multi-value) if it’s not a member already:

FIELD cars := @If(@IsMember(“Corolla”;cars);cars;cars:“Corolla”);

Now I need to find a way to remove the value “Corolla” from the field but retain any other values in the checkbox. How is this done?


If the checkbox doesn’t contain multi-values, it’s very easy:

FIELD cars = “”;

but I need to retain the other values.

Thanks,

Paul.

Subject: Remove a value from a checkbox?

Have a look at @Replace - you can replace a value with “” which removes it from the list.

Stephen Lister

Subject: RE: Remove a value from a checkbox?

Thanks Stephen. @Replace did the trick!

Paul.

Subject: RE: Remove a value from a checkbox?

Happy to help Paul :slight_smile:

Stephen Lister