Auto Generate Field
The Auto Generate Field is for automatically generating data, for example invoice numbers, order IDs, dates, digits, counts, time + date and other various combinations. In the case of the counters, it works by checking the last entered value in that form and incrementing by 1.
Available Formats (Initial Field Parameters)
| Format | Description |
|---|---|
Full Timestamp | Full Date and Timestamp in the following format: 2021-03-04 16:22:06 |
Time | 16:22:06 |
Date | A selection of Formats available: DD/MM/YYYY DD.MM.YYYY YYYY-MM-DD YYYYMMDD Single Week - DD/MM/YYY - DD/MM/YYYY Day, Month 00th Year |
Number Increments | Pure digits, e.g. 0439, choose the starting number, e.g. 0000 and choose the length of digits (i.e in this case the length is 4) |
Text and Number Increments | Similar to Number Increments but you can append a piece of text at the start. E.g. INVOICE00543 |
Date and Number Increments | Similar to Text and Number Increments but you can choose today's date to be appended at the start, e.g. 202104010004 |
Text, Date and Number Increments | A combination of all of the above 3 |
(Optional) Choose another field to use to count against | See details below for this parameter |
(Optional) Choose another field to use to count against
It is possible to reset the autogenerate field count based on another value of a field in the bloc.
For example, supposing you want to do a counter of fruit, you could have a field called Fruit: Apple or Pear. You could then have an autogenerate field the gets the last value for the particular chosen fruit as opposed to the last value in general. This way the autogenerate field can give different results depending on values of the other field.
Last updated
