Generated Number


#1

I am looking to create an ID for our records that combine the first Three letters of one column (TEM for example) with a generated date and time code that can be inserted into a barcode (02222018182947 - February 22nd, 2018 6:29:47pm). A completed code would look something like TEM02222018182947. the end result is to have this code converted into a barcode
We have tried record ID but did not like the results as it is too random and does not tell us certain things we would like to know.

We have also tried combining a text field with the input time and date field, but the extra characters are not compatible with barcodes.


#2

To get the date and time code in your desired format, use this formula:

DATETIME_FORMAT(Date,'MMDDYYYYHHmmss')

Your complete field config, then, would be

LEFT({Column1},3)&DATETIME_FORMAT(Date,'MMDDYYYYHHmmss')