Generate a string with a random sequence of characters.
To set the generated string to another field, enter the target field into the parameter “Target Field (Optional)”.
Use formulas when using the result for other actions without setting it immediately.
The generated string will be set as a result of the action. To access the conversion result, use a formula to reference this action in other actions.
For example, if the action of “Generate Random String” is the first action, you can set the value in the parameter “Set Field Value” as follows:
=$1
then you can retrieve the result.
Set Character Type, Number of Characters, and Target Field (Optional).
You can choose between “Alphanumeric” and “Alphanumeric and Symbols.”
When “Alphanumeric” is selected, the following characters are used:
abcdefghijkmnprstuvwxyzABCDEFGHJKLMNPRSTUVWXYZ2345678
When “Alphanumeric and Symbols” is selected, the following symbols are added to the above characters.
!#$%&+-=?@^_
As can be seen from the above, not all characters are used. It is designed not to include characters that may be confused with others when viewed (such as “1” and “l”).
Enter the number of characters to be generated in the string.
A maximum of 1000 characters is allowed. Specifying a value of 1001 or more will result in a runtime error.
Use this parameter to set the results to another field. You can omit this parameter if you do not set the results directly in the field but use it in another action.
This parameter accepts the following field types:
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.
This action is designed to work seamlessly with krewSheet.
However, the following restrictions apply to the parameter “Target Field (Optional)”: