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!