Pre-fill information in a form / autopopulate

[Zoey_Sloate]

My organization is looking at using Airtable for our yearly enrollment process. Every year, members renew, and some new ones join. We would love it if renewing members could put in their business name into a form view, and their information from last year would auto-populate, and they only had to review information (rather than enter it all over again).

Can this please be done with Airtable? If Airtable doesn’t do this in the program itself, what third-party programs can I link to Airtable to make this happen?

Any and all help would be appreciated!

[SDOK_Blog]

Hello.
Unfortunatly you can’t fill forms after the form is already opened.
As a solution I would suggest:
You can prefill forms including the fields in the URL. For example:
https://airtable.com/shr4Q3u14unzvPDUH?prefill_Name=new&prefill_Notes=new2,
where Name and Notes are fields in Airtable.
So, if you have a base is Airtable, you could create a formula field where the URL is generated.
Then, if you have their emails, email them this url. When they open the form, the fields will be prefilled.
I would do the form in another table that would be automatically linked to the original, as a form submition creates a new row, not updates the current.
For new members just a simple form.
P.S. the emails can be also automatically sent to members using Integromat.

[Moe]

Zoey_Sloate:

If Airtable doesn’t do this in the program itself, what third-party programs can I link to Airtable to make this happen?

We built a tool that allows your members to review/update their information without having to re-enter it all over again. Our tool generates for each record a unique URL. When the user opens it, they’ll get your Airtable form with all existing data auto-populated.

miniExtensions

Update Existing Records with Airtable Forms - miniExtensions

This tool uses Airtable's native form and allows users to see existing data before editing. It doesn't require setting up a mirror table nor using Zapier.