Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

First Airtable... help appreciated

Topic Labels: Base design
564 1
cancel
Showing results for 
Search instead for 
Did you mean: 
jeeny
4 - Data Explorer
4 - Data Explorer

Hi,

I am completely new to Airtable and, tbh, to any form of database and analysis. I am working as a writer and coach.

One company I work for has some trouble with its organization. A few things go wrong in administration, and we are trying to track them to the best of my abilities.

Usually, it starts with an appointment (name of customer + date of his appointment). Then the contract has to be sent out, be signed, come back. A first payment has to be made. Some customers reschedule. We have to send out additional material after the appointment, plus an invoice, and that should be paid...

I am not sure what (exactly) to track, and how to analyze my data afterwards. (i.e. would it be better to just have "invoice" yes/no, or should I have the date it was sent...?)

Since we are not sure where problems could lie, I am not sure what to track.

On the other hand it seems that my objective is not a beginner's task (I want to track the customer's journey on one hand, and the appointment's on the other ... if customers reschedule, we try to fill there appointment, and that works sometimes, and sometimes it does not.)

Is there anybody here who can point me in a helpful direction? I am willing to learn, I just don't even know what words to search for 🙂

Thanks, jeeny

1 Reply 1
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

Jeeny,
What you're wanting is not difficult at all, and only seems overwhelming because you're just starting out. I'd be happy to talk you through the concepts on a video conference. (After that, if you decide it's beyond your skill or time constraints I can also be hired to build it for you.)

Another possible option is to go through the templates at https://www.airtable.com/templates and see if there's one that gets you 90% of the way there. It'd be easy enough for us to adjust and make it fit your specific situation.