Hello, I'm brand new here. Air Table was suggested as a good option for what I need to do, but I need some guidance. (I can do basic things on google sheets or excel.)
We're creating a church directory. We've gathered info from families, and someone typed them up in a doc... (Kicking myself for not having made a digital form to begin with!)
What I will need to end up with is a database of families with adults and children, mailing address, phone and email (sometimes both for 2 adults), and birthdays and anniversaries. Also, a place to check if they will have a photo in the book, and a place to check that we've verified their info to be correct before including it in the directory.
I will need to output 3 different things:
The names of the family members to go under their photo. (Family name and individuals with adults named first)
The directory contact info listing (Family Name, individuals, contact info)
A calendar list of birthdays and anniversaries by month
Side note: We do have some different families with the same last name.
Thank you for any advice or guidance you can share!
Attaching just my quick note of the 3 outputs I would need for the family info.