Hi Airtable Community,
I have an Airtable base for Health & Safety for an event. I have an Airtable form which is populating data in a table called "Declarations" (these come from a subset of our stakeholders). I have a second table called "Inductions", which is being populated via an integration with a Jotform form. This second base includes a broader set of data, but critically everyone who completes the Declaration form also needs to complete the Induction form.
I want to create a third table which summarises who has completed which of these forms, using email and/or company name as the common field.
I'd also like to check this data and link it against other lists in other bases (eg Volunteers, Suppliers), using their contacts to sync data.
I am still something of an Airtable rookie, without coding skills, so looking for an explanation that is accessible please - i want to learn a solution, so i can use it across my Airtables.
Thanks!