I currently have a Client Database which stores client info and automates scheduling.
What I would like to do is create a Client History which would store past appointments, how much clients spent, how much they tipped etc.
I’m thinking the way to do it would be to create a separate synced database which would use Their Appt Date/Time at the Primary field. So then when I confirm an appt with a client on the CLIENT base, Airtable creates a new record in the HISTORY base, and this new History Record is associated with the client.
Does that seem like a sensible way to do this?