Sections
Replace UUIDs with Smart Record Labels
on 04-05-2024 07:43 PM by Ted Battreall
613
Replace UUIDs with Smart Record Labels
To display records with something other than a Universally Unique ID (XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX). Select another field as the record label on the object.
In many cases you might want to set this to be a simple number representing the index of the record.  To do this choose index as the record label.   In other cases you might want to add have a fomula for the record label. To do this create a new text field and set the initial value to a formula. For example, if want a record label in the format APP-000001 you would create a field with the the following formula in the initial value.  
=CONCAT("APP-",FORMAT_NUMBER("[[_index]]", "{:06.0f}"))   
The format number function will ensure you have leading zeros to support consistent numbers. While the outer concat function concatenates "APP" with the result of the format number expression (e.g. 000001).