Auto Generate Field
Last updated
Last updated
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.
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.
Parameters | Description |
Compare to the highest value number | For example, if you are incrementing a counter, it will start to increment from the highest value number in the records instead of the most recent record to get the next value. |
Force to empty value after form submission or editing | This is now disabled and will be removed in future releases. |
Never Trigger while hidden due to Conditional Visibility | |
Never Trigger if value already exists while editing | An autogenerate field never triggers while editing regardless of conditional visibility settings, however with "Trigger the Autogeneration if this appears during editing due to Conditional Visibility" it can trigger a new one. This parameter restricts this new trigger only to situations where there is no value already there and "Trigger the Autogeneration if this appears during editing due to Conditional Visibility" is turned on. |
Trigger the Autogeneration if this appears during editing due to Conditional Visibility | By default, the auto generation will not trigger if it appears while editing, this setting overrides this and will trigger one. |