Automatically number multiple records at once and input them into specified record fields.
When executing an Action with this Do, Customine communicates with gusuku’s server to set the values retrieved in the specified field.
In the case of “Auto Numbering”, one numbering is performed per action, so even if you try to perform multiple actions to number consecutively, the numbers may skip if interrupted by other numbering processes. In contrast, “Auto Numbering Multiple Records at Once” can always get consecutive numbers.
Since this process involves network communication, depending on your network connection, it may take some time for the values to populate the fields. During communication: “Numbering…” will be displayed, and values cannot be input.
“Auto Numbering Multiple Records at Once” does not save the records by the action itself. If necessary, please set up an action to save the record, such as “Export Records to App.” Conversely, when numbering the records obtained by “Retrieve the Records Saving with krewSheet,” krewSheet will save the records as they are, so there is no need to export them in this action.
Set Record, Field, and parameters to define the numbering rules.
Select the records to set the auto-numbered value.
Select the field to set the auto-numbered value.
The field values are formatted, such as being padded with zeros.
This parameter accepts the following field types:
Selecting a Number field and adding a prefix or suffix will trigger an error during execution.
Select how to handle cases where the specified “Field” of the specified “Record” already contains a value.
In the case of “Overwrite”, even if there is a value, it will be overwritten with the numbered value.
In the case of “Keep original value,” it is kept as the original field value without being overwritten. In this case, the rows with values are not subject to numbering. For example, if 5 records and 2 already have values, the assigned values will be 3, and these 3 will be consecutive numbers. There will be no missing numbers for the records already entered.
Selecting “None” will generate sequential numbering for the entire domain.
Selecting “Numbering by application” will assign separate sets of sequential numbers in each app.
Selecting “Use” will pad the value with zeros if it has fewer digits than the value you specified in the “Zero padding digit” parameter.
If you select “Use”, the value in the “Zero padding digit” parameter must be “1” or higher.
Example: If the retrieved value is “1,” zero padding is enabled, and the “Zero padding digit” is “8,” the value “00000001” is set to the field.
Specify the maximum number of zero-padded digits. This parameter is ignored if zero padding is disabled.
Note that this action does not discard digits, even if the resulting number exceeds the limit set by this parameter. Example: If the “Zero padding digit” is set to “3” and the retrieved value is “1234,” the number will remain as “1234” instead of being adjusted to “123” or “234.” The generated value is exported to the field unchanged.
Use this parameter to attach a specific string to the start of every number.
Use this parameter to attach a specific string to the end of every number.
Selecting “Nothing to do” will not reset the numbering.
Selecting “monthly” will reset the sequential numbering to 1 each month.
Selecting “yearly” will reset the sequential numbering to 1 January 1st each year.
Selecting “fiscal yearly (staring in April)” will reset the sequential numbering to 1 April 1st each year.
When selecting a numbering cycle in the “Numbering cycle” parameter, choose the “Time Zone” parameter to indicate the timezone that should be used for managing the numbering cycle based on the specific country or region.
Set this parameter to set the own numbering key. This parameter is optional.
When using multiple Actions, each running its instance of “Auto Numbering,” if you leave the “Numbering Key” parameter empty, all fields will be identified by the field code specified in “Field Code” as part of the same numbering group, generating sequential numbering in this group. If you specify a “Numbering Key,” that key will identify all fields as belonging to the same numbering group and generate sequential numbering local to that group.
自動採番がどの範囲で連続性をもつのかどうかは「フィールド」「アプリ単位の採番」「採番キー」の組み合わせによって変わります。以下の表を参考にしてください。
| フィールド | アプリ単位の採番 | 採番キー | 採番の範囲 |
|---|---|---|---|
| 指定なし | なし | 指定なし | 同一アクション番号 |
| 指定なし | なし | 指定あり | 同一採番キー |
| 指定なし | アプリ単位で採番 | 指定なし | アプリ内の同一アクション番号 |
| 指定なし | アプリ単位で採番 | 指定あり | アプリ内の同一採番キー |
| 指定あり | なし | 指定なし | 同一フィールドコード |
| 指定あり | なし | 指定あり | 同一採番キー |
| 指定あり | アプリ単位で採番 | 指定なし | アプリ内の同一フィールド |
| 指定あり | アプリ単位で採番 | 指定あり | アプリ内の同一採番キー |
特に、この３つのパラメーターを全て省略した場合、kintoneサブドメイン全体での広い範囲の連番になるのではなく、逆にそのアクションのみの狭い範囲の連番になる点に注意してください。アプリを横断してkintoneサブドメイン全体での連番を行いたい場合は「アプリ単位の採番」を「なし」にして「採番キー」を指定してください。