I need an attendance tracker for nonprofit organization that organizes different extracurricular activities throughout the year. I'm working on a generic form that the coordinators of each activity would use to report the activity, time, description/impact, and attendance. The attendance is linked to a table that compiles the beneficiaries of the different activities that are run by the Non-profit.
We already have some beneficiaries or previous participants in this table and so some of the attendees are already in our records, but when we have new attendees, I would like to be able to generate a new record from a form. I am able to add a new record in the grid view, but not in the Form. I have already tried to use the link to the form, not the form builder view and it was still not allowing me to add a new record. Is this even possible? or am I missing something? The objective is to be able to have a beneficiary registry or a complete list of beneficiaries to report to our donors every year (also to be able to track, those who participate in several activities, or those who come back year after year). If you have any other ideas to do this I would really appreciate it!
If you’re using a linked record on a public form, Airtable doesn’t allow your form-filler-outers to add new records to that public-facing form.
One solution would be to create an interface for your coordinators instead of having them use a form. With an interface, you can give the coordinators permission to create new beneficiary records when they need to.
If you're viewing the linked records in a Grid layout, you can't add new records. You need to choose the linked record from the 'Add Element' section of the interface and then choose the Field element. Then you should see a list of attendees for any given activity. On the right side of interface, where the element options are, scroll down until you see Permissions. That's where you can set the options for your users to add new records to the attendee list.