Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Using Filters to auto-fill fields with data

6701 5
Showing results for 
Search instead for 
Did you mean: 

Hi! So I recently noticed that if I am creating records in a filtered view that all NEW records added in that view will automatically get the same values that are required by that filter.

Screen Shot 2017-06-30 at 12.43.22 PM.pngScreen Shot 2017-06-30 at 12.42.55 PM.png

This is pretty AWESOME! Ive been itching to get new records to auto-fill and this helps me get toward that goal.

Feature request… If you could attach a form view to create records in a specific view, that would ROCK! However, I do also use the ‘prefill’ in the URL option to do that.

5 Replies 5

It also works when you group records!

Thanks for this suggestion. Unfortunately, it does not work for Linked Fields

Any word on when this will work with linked fields? We currently have a workflow that depends on filtering records with linked fields, and resorted to creating a dummy variable column that’s a 1:1 copy to autopopulate records so they don’t get filtered out

Hello! I’m having an issue with a certain field autofilling to a view. We have older (read: “less tech savvy”) employees, and I have the views filtered by their name in a hidden field for “Assigned To.” But, if she’s filling a row and only gets one or two cells in and accidentally clicks somewhere else, the row she was working on is not autofilled to her view, and therefore filtered out so she starts again. So there are duplicates of tasks where she wasn’t able to complete the row before it was filtered out. Any suggestions?

We recently launched a new feature that allows you to prefill ‘filters’. It forces linked fields to only show limited records on the form.