Here’s my project:
Trying to help someone transition from using a very old, (as in it can legally consume alcohol now), locally hosted database to Airtable.
They run a hotel that rents suites by the month for business travelers. Currently, they enter, let’s say, John Doe into suite number 1 for a month. While John is here, he also subscribes to their featured cable tv package, subscribes to their faster internet connection and requested room service several times. Their current database has fields for each choices listed above and I can pretty much duplicate that part.
Now here’s where things have been going South for the owner over the years. Their old system did not retain John Doe’s records after he was check out, they were auto deleted , so as to show suite 1 is available again.
The owners would like to switch to Airtable because of it’s massive flexibility AND retain John Doe’s past history with them, so that when he comes back for another stay, they have a history to refer too.
I have gotten the basics figured out about creating the base, creating tables within the base for each “item” that John could have purchased while here and even set the first row of the base to auto Generate a unique number for tracking purposes.
But now, how do I configure this set up so that when John checks out of suite 1, suite 1 will show as either reserved, available or out of service AND the database retain John’s past history?
I totally understand snapshots and the backup scheme. We are looking at the Pro Plan because it looks like they will have about 4500 unique records per year in a database. That said, when John comes back through this territory in a year and a half for another stay, do we (Airtable) still have his past history immediately available to the clerk or has it been overwritten on the Airtable servers? And if it does get over written, how can we retain that past customer history on our end?
Thank for the hand holding! I have been reading the Airtable docs online for DAYS and I am learning a lot, but need answers quicker than that