Updating Empty Fields Through a Form
I was wondering if anyone has advice on updating some fields in our system?
We currently use Airtable to record a register of attendees for some community group work sessions we run. We are needing to see the countries of origin that are represented in our sessions, but due to changes during the pandemic this information was not always able to be collected.
I would like to see if there is a way to gather this information as and when participants attend our sessions in the future through the attendance register we have set up.
We take registration using a form that links to our participants list, which needs to stay exactly the same for ease-of-use by our staff.
Is there a way that when a participant’s name is selected on the attendance form (using the Add+ field under ‘Student Name’, pictured below), a second window can open requesting their Country of Origin if the field for their record is blank?
This would need to be separate to the form as there are multiple participants per session being submitted on the same form. And I would like to see if this could be an option for all of them as and when their names are selected. Again, only if their respective ‘Country of Origin’ field is blank.
Any suggestions or thoughts would be appreciated, thanks in advance fellow AirTablers :slightly_smiling_face:
