Customize

Remove Option Values From Multiple Choices Allowed Field

Summary

In a field with multiple selectable options, deselect the current items.

How to use

For example, suppose the field is a checkbox, and in the app settings, there are four options set: “breakfast”, “lunch”, “dinner”, and “supper”.

When the user selects both “breakfast” and “lunch” on the record editing screen, and then takes an action to remove “breakfast,” only “lunch” will remain selected.

There will be no error even if the option specified in the “Value to Remove” field is not selected in the given field. In the above example, if the user tries to deselect “dinner” while having “breakfast” and “lunch” selected, no error will occur, and the selection will remain as “breakfast” and “lunch.”

Parameters

Set Field and Value to Remove.

Field

Select the target field.

This parameter accepts the following field types:

  • Check box
  • Multi-choice
  • User selection
  • Department selection
  • Group selection
  • Category

If you select a field inside a table, all rows of that table will be processed. For exceptions: See (*1)

*1: If you set a Condition that only applies to some table rows (such as the Condition “When Fields Value Changed”), the Do will only process the rows affected by that Condition.

Value to Remove

Specify the value to deselect.

You can deselect multiple values using expressions like the following:

=["Breakfast", "Lunch"]

If the field is the User selection field, specify the login name. Do not use the Display name.

For the Group or Department selection field, specify the group or department code.

Compatibility with krewSheet

This action is designed to work seamlessly with krewSheet.

Fields retrieved through a Lookup are not supported.

The following field types can be supported only at the timing of record saving (e.g. “Before Record Saved Excluding Deleted”): If you want to gain more technical knowledge, refer to the krewSheet documentation .

  • Fields not included in the krewSheet view’s columns
  • Fields set to read-only in krewSheet