Dear friends, it's days I'm trying to create a database to store information about my patients and their follow-up, but I am having big troubles in understanding how to do it with airtable. Anyone willing to help?
Thank you 🙂
Database creation for patients follow-up?
+2
+31What issues are you facing with doing it so far?
+2So far, I created a main table with the list of patients, their demographics and a unique ID for each patient as 1st column. Now, I need to associated for each patient one or more events, that could be surgeries and follow up visits. Each patient can have more than 1 event, but each event can be associated to only 1 patient. Accordingly, I created some tables for the events and linked them to the main table. However, it seems that each event must have a unique identifier (first column), while I'd just need to visualize in the main table the number of surgeries and the date of the last one. How can I do that?
+31So far, I created a main table with the list of patients, their demographics and a unique ID for each patient as 1st column. Now, I need to associated for each patient one or more events, that could be surgeries and follow up visits. Each patient can have more than 1 event, but each event can be associated to only 1 patient. Accordingly, I created some tables for the events and linked them to the main table. However, it seems that each event must have a unique identifier (first column), while I'd just need to visualize in the main table the number of surgeries and the date of the last one. How can I do that?
Sorry, I'm not too sure what you're asking. Are you asking how to create a unique identifier for the first column? If so, try making it an "Autonumber" field
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.