Sections
Profile Picture of the author

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).          



Generate Text