- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2021 11:25 AM
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
Bri
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2021 03:25 PM
Okay, then you must adhere to even more stringent safeguarding of patient information and would be subject to GDPR as well as the Data Protection Act (DPA), right? That said, patient health information (PHI) in Airtable is probably not recommended because it is not HIPAA, DPA, or GDPR-compliant.
If this is the case, you have only one out - you must fully anonymize the data making it impossible to identify or associate any of the information with any specific patient. And if that’s your plan, then you should probably steer clear of any use of patient initials in the ID.
It’s possible to use Airtable for medical research, but if anything is identifiable, it’s likely to create a lot of legal issues.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2021 12:50 PM
Welcome to the Airtable community!
Notice that the incremental 3 digit number is basically the same as an autonumber. Assuming that the first name, last name, date of birth, and autonumber are all fields in your base, you can use a formula to put it all together.
LEFT({first name}, 1) &
LEFT({last name}, 1) &
DATETIME_FORMAT({birthdate}, "DDMMYY") &
IF({autonumber} < 10,
"00",
IF({autonumber} < 100,
"0"
)) &
{autonumber}
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2021 01:35 PM
Does the patient data fall under HIPAA compliance?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2021 01:51 PM
Thank you so much, a complicated formula but worked a treat.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2021 01:54 PM
We don’t use HIPPA in the UK.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2021 02:20 PM
You’re welcome. In the scheme of things this is a fairly straightforward formula. It just might look complex because it is spread out over a few lines.
I missed the part that said this is a CRM for a clinic. Glad that Bill caught that and that it isn’t an issue for you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 19, 2021 03:25 PM
Okay, then you must adhere to even more stringent safeguarding of patient information and would be subject to GDPR as well as the Data Protection Act (DPA), right? That said, patient health information (PHI) in Airtable is probably not recommended because it is not HIPAA, DPA, or GDPR-compliant.
If this is the case, you have only one out - you must fully anonymize the data making it impossible to identify or associate any of the information with any specific patient. And if that’s your plan, then you should probably steer clear of any use of patient initials in the ID.
It’s possible to use Airtable for medical research, but if anything is identifiable, it’s likely to create a lot of legal issues.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 20, 2021 06:33 AM
Many thanks, all points taken on-board :blush: