Bulk update field in record for a grid when filtered by that field

[stevenjo57]

Here is the situation and thanks for all help in advance.

I have a grid view where the primary filter is to only show records where a date field is empty.  This could be as many as 50 records at any one time.

I'd like to add today's date to all records in the found set (empty dates) in fell swoop.  Of course, if I add the date to the field, it drops off the found set. This means I have to select todays date in 50 records with the awkward disappearing record.

So an automation that will update the date field in all records in the found set might work.  I played around with an automation to do this, but couldn't figure out how to do it.

I am open to alternative ideas.  Essentially, I have a set of 50 records that have an empty date and I want them to disappear from the list when a date is put in the empty date field.  But I'd like to automate it somehow.

Hope that makes sense.  I have two attachments. One a screenshot of the found record set.  Notice that the QB? field is empty. That is the field that needs a date to take it off the filtered group.  I also attached the filter setup.

Thanks again!

[ScottWorld]

The easiest way to do this would be to use Airtable’s Batch Update extension.

Hope this helps! 

- ScottWorld, Expert Airtable Consultant  

[TheTimeSavingCo]

Hm, try:
1. Click one of the cells in "QB"
2. Key in a date
3. Hit CTRL/CMD+C
4. Click on the field header (That record should now filter out)
5. Hit CTRL/CMD+V

Link to base

 

[Alexey_Gusev]

Hi,
adjust filter, copy-paste date to the whole field, click thrash can to return previous filter state (and see all records are filtered out)