I have a home based business, and I don’t know much about databases in general, and no next to nothing about Airtable specifically. I am a fast learner, but this is a little over my head and don’t know if Airtable can even do what I want.
Here is what I want:
Setup a database of customers and their orders. I sell clothing, and use a code - like TOP1S (Top, style 1, size Small) - so each style and size has its own unique code.
I want to be able to see what each customer has purchased over a period of time, and who has purchased each style/size. As well as knowing how each style is doing in sales over a period of time.
Then, I want to be able to automatically update this database by forwarding an email that will have a receipt with a new order - it would need to match up the customer or add a new customer - by email, as that would be unique. The style code would not be included though - It wouldn’t say TOP1S - but it would have a line with Top 1, size Small. I already have a spreadsheet with the codes and the styles and sizes matched up.
Then - bonus points - it makes a to do list to follow up 2 weeks after the purchase.
I figure 1 and 2 can be done fairly easily. But I don’t know if Airtable can even do 3 & 4. And before I get too deep down the rabbit hole, I need to find out if it’s even possible.