All articles

How to Pre-Fill Forms with External Data Using APIs

Pre-filling a form means the form loads with fields already completed using data you already have, so the user only reviews and submits. No retyping their name, email, or phone number.

There are two ways to do it: pass the values in the form URL as parameters, or connect a live source like a CRM or spreadsheet through an API. This guide covers both, with a copy-ready example, and how to set them up in Formester even if you do not write code.

Formester does this through its auto-fill from external data feature, pulling from tools you already use like HubSpot, Google Sheets, Excel, Airtable, or Notion.

What Does It Mean to Pre-Fill a Form?

When a form is pre-filled, it pulls data your system already holds, like a customer's email or phone number, and drops it into the matching fields before the user ever sees the form.

The user opens the link, glances at what is already there, fills any gaps, and submits. Less typing, fewer typos, and a form that feels built for them.

Two Ways to Pre-Fill a Form: URL Parameters vs API

There are two methods, and they suit different jobs.

URL-parameter prefill

You pass the values straight in the form link as query strings. It looks like this:

  • https://yourform.com/contact?name=Jane&email=jane@acme.com&company=Acme

When someone opens that link, the name, email, and company fields are already filled. It is the fastest method when you build the links yourself, for example in an email campaign or a CRM workflow, and you only need a handful of fields.

API-based prefill

Instead of stuffing values into the link, you connect a live data source and let Formester pull the values when the form loads. Use this when the data lives in another system (a CRM, a spreadsheet, a database), when it changes often, or when you do not want IDs and emails sitting in a visible URL.

Rule of thumb: a few known values in a link you already send, use URL parameters. Data that lives in another tool and updates, use the API. The rest of this guide walks the API method, since that is the one most people set up wrong.

Why Pre-Filling Forms Is Worth the Setup

The payoff is simple: every field you remove is a field someone does not abandon the form over. Completion rate falls as forms get longer, from around 28% on a 1 to 2 field form down to roughly 11% once you hit 10 or more fields (form fill-rate benchmarks). Pre-filling lets you keep the fields you need while cutting the typing your user actually feels.

  • Fewer drop-offs, because the form looks shorter and easier the moment it opens.
  • Fewer errors, because the data comes from your records, not a tired thumb on a phone.
  • Faster turnaround on lead capture, hiring, onboarding, and repeat orders.
  • A more professional impression, since the form already knows who the person is.

How to Pre-Fill a Form With an API in Formester

Four steps, no code. The two-minute walkthrough above shows it end to end if you would rather watch than read.

Step 1: Open Your Form and Go to the Share Tab

  • Log in to Formester and open the form you want to pre-fill.
  • Click the Share tab.
  • Choose Pre-Fill.

Step 2: Select API Based Pre-Fill

Under the Pre-Fill options, pick API Based Pre-Fill. Formester hands you a ready-made API link.

Point it at the source your data already lives in: a CRM like HubSpot, Google Sheets, Excel, Airtable, Notion, or even another Formester form.

Step 3: Map Your Form Fields to Your Data

Now tell Formester which field pulls which value. Link the email field to the email column, the phone field to the phone column, and so on.

Map only the fields you actually have clean data for. A wrong value pre-filled is worse than a blank one, because people trust what is already on the screen.

Step 4: Share the Form URL

Share the form link. When your user opens it, their details are already in place.

They review, fill any gaps, and submit. That is the whole experience: less work for them, cleaner data for you.

Where Pre-Filled Forms Earn Their Keep

Pre-fill is not a gimmick. It quietly removes friction in the moments that decide whether a form gets finished.

Lead Capture and Quote Requests

A prospect's details are already sitting in your CRM. Instead of making them retype it, send a quote or inquiry form with the email, phone, and company already filled. They review and submit in seconds, and you look like you were expecting them.

Job Applications and Recruitment

If a candidate applied before or already sent a resume, pull what you have from a spreadsheet or an earlier form and pre-fill the application. The candidate skips the repeat data entry, and your pipeline stays tidy. The same trick works on any job application form.

Client Onboarding

First impressions stick. Send a new client an onboarding form with their basic details already pulled from your records. They fill the rest, and the handoff feels organized instead of bureaucratic.

Repeat Orders for Existing Customers

Repeat customers should never retype their shipping address. Send a reorder form with contact and delivery details already in place. Fewer mistakes, faster processing, and one less reason to abandon the cart.

Internal Team Workflows

Employee onboarding, IT requests, record updates: internal forms ask for the same details over and over. Pre-fill the known parts (employee ID, department, manager) and your team spends its time on the work, not the paperwork.

Build Your First Pre-Filled Form

Forms are part of doing business, but they should not feel like a chore for the person filling them. Pick the method that fits: URL parameters for a few known values, the API when the data lives in another tool.

Pre-fill works with the tools you already run, from your CRM and Google Sheets to Airtable and Notion, and you stay in control of the data. Need a starting point? Grab a registration form template and wire up pre-fill on it. Sign up for Formester free and set up your first pre-filled form in minutes.

Share this article
FAQ

Pre-Fill Forms FAQ

Ready to build your perfect form?

Formester is the easiest way to create forms, collect data and automate your workflow