Comment on page
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.

Just some examples of our ever-growing auto generate options.
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 |
| |
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.

In this example, the counter is 003 because Apple is chosen, if you clicked Pear, the Counter value would change to 007.
Last modified 1yr ago