Hello Airtable community! I founded an all-volunteer project to help street cats on the island of Vis, in Croatia, and design a calendar every year to raise money for the project.
Last year was my first year dealing with calendar orders via Airtable, and I thought I had a clever set-up where people could fill out a form to order. It DID work for that one year, but I don’t think I designed the base correctly, because it’s not sustainable year-to-year.
The base is called CALENDARS+ (in case we start to sell any other fundraising items in the future) and all the data I collected lives in a table called 2022 calendar. Each name entered via the form becomes a record, with the person’s preferred language, email address, postal address and the number of calendars they want.
If I do this again for the 2023 calendar, there will be lots of duplicate records, so it’s obviously wrong. I need the people’s data to live in one place so that in following years when they come back to buy another calendar, they can say if they’re a new or returning customer, and if returning and their info is still the same as the previous year, they could just skip to telling us how many calendars they want.
Is this clear? Should I be thinking of this as a DONOR (or customer) table, knowing that for people coming for calendars there will be that added info, as opposed to other donors throughout the year who give one-time donations, usually when they’ve brought a needy cat to our attention?
The first base I built for the project is an expenses and income base, and I have a DONORS table in that base. But since I built the calendar base separately, I have donor overlap, and want to fix this before this next fundraising drive (to sell the 2023 calendars).