I am sure this is going to be the first of many questions as I build my clinic CRM/Visit and inventory manager.
The first formula I’m looking for is providing my patients with a unique identifier. The autonumber or record ID isn’t appropriate.
The unique reference/ID I was looking to contain the following:
First and Last Initial
Date of birth (ddmmyy)
Incremental 3 digit number (001
So my record ID (Patient Record Number (PRN)) would be BB031200001
Any help is greatly received