Remove blank spaces, tab characters, and line feed characters in the specified fields.
Depending on the type of the selected field, whether to remove line breaks varies.
In the Text area and the Rich text fields, the original line breaks are preserved, and only spaces and tab characters are removed. In other fields, line breaks will also be removed.
Records saved through standard UI operations do not contain line breaks in the Text fields. However, in the case of records created with customization, there may be line breaks. “Remove Blanks Spaces” can eliminate line breaks that have been created through such customization.
Set Field.
Select the field from which to remove whitespace. You can select multiple fields. When multiple fields are selected, the Action will simultaneously process all selected fields.
This parameter accepts the following field types:
If you select a field that is inside a table, the Do will process all rows of that table. See *1 for exceptions to this behavior.
*1: If you set a Condition that only applies to some table rows (such as the Condition “When Fields Value Changed”), the value will be set only for those affected by that Condition.
This action is designed to work seamlessly with krewSheet.
However, it does not support fields that serve as Lookup sources.
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 .