Automatically number multiple rows at once and input them into specified fields in the table.
When executing an Action with this Do, Customine connects to gusuku’s server to set the values retrieved in the specified table field.
In the case of standard “Auto Numbering,” numbering occurs with each action. This means that if multiple actions are performed simultaneously or in quick succession, the numbers may skip due to interruptions from other numbering processes. In contrast, “Auto Numbering Multiple Rows at Once” enables the generation of consecutive numbers all at once.
However, since this process triggers network communication, it may take some time to export the values to the fields, depending on your network connection. During this communication, the message “Numbering…” will be displayed, and you will not be able to enter any input. This is a precautionary measure to prevent potential malfunctions that may occur when manipulating the table during communication.
Define the numbering rules by setting the field in the table and specifying the relevant parameters.
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 proceed when the specified “Field” in “Field in Table” already has 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 rows 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 rows already entered.
Selecting “None” will generate sequential numbering for the entire domain.
Selecting “Numbering by app” 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サブドメイン全体での連番を行いたい場合は「アプリ単位の採番」を「なし」にして「採番キー」を指定してください。
This action does not support krewSheet.