New app in the Airtable Marketplace: Formula for a Prefilled Form

I have a new app on the Airtable Marketplace!

Have you ever wanted to prefill a form will data that already exists in your base, but found building the url to be difficult? My new marketplace app, Prefilled Forms, creates a formula that calculates a prefilled url for a form for each record in a table.

You don’t have to write any code–just point, click, copy, and paste.

Use case 1: Create prefilled links for clients You already have a table of client information, and you have an onboarding form, questionnaire, evaluation survey or other form for them to fill out. You want a to email each client a link to the form prefilled with the client’s name and other details. Use the Prefilled Forms app to build the formula to for each client.

Use case 2: Click a button to create records with defaults New records tend to have several fields that always have the same combination of values. For each combination, use a button field with the url for the form prefilled with that combination. Click the button to launch the prefilled form and have less to fill out.

You can read about my app (and several other custom apps) in Airtable’s blog post. Mine is the 3rd on the list.

You can get my app here.


Note about emailing prefilled links with automations If you are using Airtable automations to email the url, you must escape the underscore character or the Airtable automations will think that you are trying to include italic text. The workaround for this is to create a second formula field that escapes the underscores, then use the escaped url in the automation email:

SUBSTITUTE({Original Url}, "_", "\_")

If you have spaces in your field names, use this formula:

SUBSTITUTE(
  SUBSTITUTE(
    {Òriginal Url}, 
    "_", 
    "\\" & "\\" & "_"
  ),
  "%20",
  "\\" & "\\" & "%2520"
)
4 Likes

Here are links to videos on the two uses cases

2 Likes