Hi Awesome Airtable folks,
I am a fairly competent basic Airtable user - basic integrations and data moving between bases, however not a full coder (so need an easy solution that is easily passed on to others please). I would love your advice on the best approach for this: -
We have an event, and we have 2 different H&S forms that we require our various stakeholders to complete. Each area (trade, volunteers etc) has its own base in Airtbale
Form 1 - Declaration
A simple airtable form, no images. Built in Airtable, communicates directly back to base. Worked well last time.
Completed by - trade only
Form 2 - Induction
- Needs to contain imagery. This is where we came unstuck last year as Airtable Business doesn’t have imagery in the forms, so we built with an integration in Jotform. This created data and sent it back to the airtable base, but we struggled to integrate it with existing data so had to manually audit it.
- We also have people attending who will complete this form that we do not have existing data records for - i.e. the individual staff of a stall holder, or a volunteer for a community group
Completed by - trade, volunteers, staff
Really it is form 2 we need a fix for. The options seem to be:
- Upgrade to Airtable Enterprise? Unsure if the functionality is there or if the cost is worth while, but it would be ideal to stick with a single provider
- Rebuild the Jotform form with better integration - have data selection links that pull back to existing bases. However the issue of data collected from new poeple not already in our system still needs to be resolved.
Ultimately we want to be able to send these forms out, and with no extra steps be able to use our existing bases to audit who has and hasn’t completed them
Thanks for you help!