Check if the number of characters in the specified text fields is within the specified range.
This feature is almost identical to the “Character count” feature in the “Text” field. In the Kintone app, the character count does not strictly count characters; it considers emojis as two characters. In this “Check Number of Characters” action, each emoji is counted as a single character.
Unlike the check feature in the Kintone app, this allows for more complex checks by combining multiple conditions.
If the number of texts in the specified fields is outside the acceptable range, a list of corresponding field codes for those fields will be provided. If all fields are within range, the result will be an empty list. If a field is specified in the table, the action’s result will only apply to the last row of the table. The results of other rows are not reflected, so caution is necessary.
Set Field, Min, Max, and Error Message.
Select the field that should be checked.
When you select multiple fields, it checks each of those fields individually.
The following field types are selectable.
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 value will be set only for those affected by that Condition.
In a Text area field, the newline code counts as one character.
The Rich text field needs special attention. The data of the Rich text field is represented in HTML format internally. In “Check Number of Characters”, the HTML tag is not counted as characters. In HTML, characters are represented by code, and it’s important to note that the entire code segment counts towards the character length. For instance, while “&” represents the character “&”, when counting characters, “&” is considered to be five characters long.
Enter the minimum number of characters for the field.
Enter the maximum number of characters for the field.
Enter an error message to display if the number of texts in the specified fields falls outside the acceptable range.
The action is supported only under the following conditions:
You cannot check more than one field for out-of-range values at the same time. The check for out-of-range values will be displayed in the most recent in the krewSheet.
The selectable fields are limited to one of the following field types:
Internet Explorer 11 is not supported.