Airtable Forms: Know Who Submitted Without Asking (Prefill + Hidden Fields)

How to Prefill and Hide Fields in Airtable Forms

Have you ever needed to track which client submitted a form without showing them a list of all your other clients? You're likely using Airtable forms to collect information, but showing linked record fields can expose sensitive business data. The good news is that Airtable forms allow you to prefill information and hide it from view, so form submitters share data they don't even see. In this guide, you'll learn the exact steps to implement this powerful functionality in your Airtable forms.

Why Use Field IDs Instead of Field Names

When prefilling form fields, many users make the mistake of referencing field names directly in their URLs. The problem with this approach is that if someone later renames the field, all your form links will break. Instead, you should always use Field IDs, which remain constant regardless of name changes. You can find Field IDs by going to Tools, selecting Manage Fields, and adding the Field ID column to your view. This same principle applies to linked records—always use Record IDs rather than record names for more stable, reliable form links.

The Syntax for Prefilling Form Fields

To prefill a field in your Airtable form, you'll need to modify the published form URL with specific parameters. Start with your base form URL, then add a question mark to indicate your first parameter. The syntax follows this pattern: prefill_[FieldID]=[value]. For linked record fields, use the Record ID as your value rather than the record name. You can test this immediately by pasting the modified URL into your browser—the form should load with your specified field already populated with the correct information.

How to Hide Prefilled Fields from Form Submitters

Once you've successfully prefilled a field, you'll want to hide it so users can't see or modify that information. To do this, add a second parameter to your URL using an ampersand (since it's not the first parameter). The syntax is: hide_[FieldID]=true. If you wanted to show the field instead, you would use "false" instead of "true". When you test this URL, the form will load with the client information already captured in the background, but the field itself won't be visible to the person filling out the form.

Building a Dynamic Formula for Multiple Clients

Rather than manually creating URLs for each client, you can build a formula in Airtable that generates unique form links automatically. Create a formula field at the client level that concatenates your base form URL, the prefill syntax, the dynamic Record ID for that specific client, and the hide parameter. By structuring your formula with proper line breaks and tabs, you'll create a readable template that outputs a unique URL for each client record. This approach makes it easy to share the correct form link with each client, ensuring their submissions are automatically tagged to their account.

Practical Applications for Ticketing Systems

This technique is particularly valuable for building client ticketing systems where you want clients to submit issues without seeing your other clients' information. When a client clicks their unique form link, they can describe their issue and set urgency levels, while the system automatically captures which client submitted the ticket. You can share these URLs through automated emails from Airtable, embedding each client's specific link so they can submit tickets whenever needed. The result is a clean, professional form experience that maintains data privacy while capturing all the information you need.

Conclusion

You now know how to prefill and hide fields in Airtable forms using Field IDs and Record IDs for maximum stability. By mastering this URL parameter syntax, you can create seamless form experiences that capture critical data without exposing sensitive information to your form submitters. This functionality opens up powerful possibilities for client portals, ticketing systems, and any scenario where you need to know who's submitting data without asking them directly.

If you found value in this content, give us a thumbs-up and subscribe for more insights. Visit our website for a wealth of resources and continue your journey in building smarter solutions.