Prefilling AND Autosubmitting an Airtable Form

[DavidVM]

Does anyone know if it’s possible to generate a url in Airtable that would both prefill fields AND autosubmit the form.

I would like to be able to send a client a link (generated from an Airtable formula) via e-mail, that once clicked, would submit an Airtable form automatically with prefilled information. In other words, clicking the link would take them directly to the form submission confirmation page. All they have to do is click the link (or button in the e-mail) and their form is automatically submitted.

I know that this is now possible using Stacker.app, but I was hoping for a similar solution simply using e-mail. In Stacker.app they add "&autosave=1 at the end of the url, but this doesn’t seem to work for me outside of that app.

I’m guessing that this can probably be done using a e-mail button or link with a Zapier webhook, but I was hoping to avoid that if possible. If there is something similar to the “&autosave=1” feature, that would be ideal.

Thanks!

[ScottWorld]

If you want the form to autosubmit, it doesn’t actually sound like you want a form at all (which is designed for user input).

It sounds like you simply want an action to take place in your base — such as adding a new record with some predefined data — which is a completely different thing.

You can just do that with webhooks in Integromat or Zapier, for example, and then present them with a webpage that confirms their action.

There are also other tools that can do this for you as well, such as this one:

miniExtensions

Create Airtable Records Using a Webhook URL - miniExtensions

Create new records by scanning a QR code. Or allow users to click on a link to create a new record. Or integrate the generated URL with other apps.

[DavidVM]

Thanks for the input Scott. I realize that this isn’t normally what a form is for, but I was hoping to have information added to my base without the need for client action (other than clicking a button to confirm the information is correct), and wanted to avoid using third party solutions such as Zapier and Integromat which require additional work and maintenance on my end.

The “autosave=1” feature in Stacker seemed to be a good solution for this, but only if the client clicks on the button from within Stacker. If this was an option with a standard Airtable form, I could prefill and submit a form using only Airtable, thereby adding a new record with some predefined data with a single click, and without the need for a third party service.

I’m always trying to automate and simplify things, but sometimes I guess we need to settle for what works. The solutions you mentioned will definitely do that.

Thanks for your input.