This app was populated with a lot of old data from an Access Database that had it's own numbering system. I use another field to determine if an old number exists or not. If an old number does not exist, than it uses the new auto generated number value with the Record ID. Below is a list of field names and what they do.
List of Field Names:
OId ARB # - this is a text field only populated if it was from the old database, blank otherwise
Auto ABR# - this is a formula field that concatenates Location and Record ID together
New True ABR# - this is a formula field that looks for a value in Old ABR #, otherwise returns Auto ABR#
ABR Number - this is just a text field that waits for the dynamic form rule to "stamp" the value in the New True ABR# upon save. This is my primary key.
