I’m using Airtable to build a list of donors for our non-profit organization. The records are identified by the name of the donor. Some donors make multiple donations throughout the year. How can I reflect these frequent donations without building a whole new record?
Thank you so much.
Best answer by kuovonne
You need two tables. A table for donors, and a table for donations. Join the two tables with a linked record field.
Each new donation gets a new record in the Donations table. If the donor already exists in the Donors table, link the donation to that donor. If the donor does not yet exist, create the donor record.
+27You need two tables. A table for donors, and a table for donations. Join the two tables with a linked record field.
Each new donation gets a new record in the Donations table. If the donor already exists in the Donors table, link the donation to that donor. If the donor does not yet exist, create the donor record.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
