You sound very knowledgeable about Airtable. I’m new at this and a veterinarian by training so I don’t have a lot of experience with database software. When you refer to an Updates table, are you referring to a new field in the patient’s record or starting a new Base? Not sure about formulas either.
If you would consider a phone consultation, I am willing to offer to pay for some help. I live in California and most evenings are free (6:30-10pm PDT). Perhaps there’s a way to share the database online to explain things. If not, I appreciate your input.