Hi all!
I’m new to appsheets and this week was able to build three useful apps for a non-profit benefiting kids in foster care to help manage our volunteer team.
I would like to add two things to the new volunteer management app.
#1- I was able to make a field for the volunteers background check results to be uploaded as a PDF. Is it possible to add a field that would save the timestamp of the upload so I could add formatting to highlight the volunteer two years after the background check. This would give us a visual of when volunteers need to be rechecked.
#2- I’d also like to add a field for events the volunteer has been involved in. Every event has a Google form sign up and subsequent Google sheet and volunteers are prompted to use the same email address on every form that they used in their volunteer application. I’m hoping to use the email address as a key and use lookup formulas to find their email addresses in sign ups and somehow list on their card in the app which events they’ve signed up to attend.
Any help bringing these imagined app features to life is much appreciated!
One option maybe to have a Volunteers table that has one record per volunteer in that table, something like a Users table.
Then each of those Events tables could be child table of the volunteer table. With this arrangement the Volunteers table can list the events of each volunteer as child records.
2 Likes
I bet that would work perfectly! Thank you so much! I’m having a hard time understanding how to make a data source a child table to a different data source. Could you explain or point me to a tutorial video? Thank you again!
This does help so much, thank you!
This is probably such a newbie question, but we onboard new volunteers pretty much constantly. Right now I have it set up that when a new volunteer finishes the application process their new row atomically populates in several apps. (Volunteer directory, volunteer hours log, and now this volunteer management app for admins to see all their records in one place.)
If I set up this parent/child table relationship when a new row populates for a new volunteer will it automatically start searching for their email and showing their events?