Legacy ID for existing records
Good Morning Admins!
My company will be migrating our existing procurement application from a Microsoft InfoPath form into an ODA with Archer; I am attempting to come up with the best solution by which I may be able to import the existing records within Archer without losing the legacy id's (attached). I don't mind if this is either a custom field utilizing the Content ID or if this is based upon the Application's ID; any suggestions are greatly appreciated!
I would approach this by creating a new field in the ODA called "Legacy ID", and putting the Tracking ID data from the old system in there.
Then create another field in the ODA called "Tracking ID", and make it calculated such that if "Legacy ID" is populated it uses that value, otherwise it takes the Archer System ID.