Overview
A record picker links entries from one database to another, so you can see related information in one place. Think of it like linking two pieces of a puzzle, instead of copying data from one table to another, you just point to it. For example, you have a Projects database and a Clients database. With a record picker, you can link a project to a client without retyping any client info. Everything stays connected and up-to-date automatically.
- Keeping your data organized
- Avoiding duplicate entries
- Making it easy to navigate between related records
How to pre-fill a record picker
You can pre-fill a record picker using the record’s Airtable Record ID. In this video, we show how to pre-fill a record picker using a URL parameter.Prevent respondents from changing the record picker
You can choose to always conditionally hide the record picker.Reference fields from the chosen Airtable record
Personalize your form by referencing fields in your form.Related articles
Pre-fill fields
Pre-populate fields based on previous inputs and more.
Hide fields
Hide or show fields based on answers, URL parameters or data.