How to filter Airtable fields <blank>

Hi

I’ve created a Airtable in which one of the columbs is “due date”

I want to run a shortcut that gives me all tje entries that are , ie no due date

This is what I’m doing.

Is there a better/more efficient way?

Thanks!

Assuming you don’t need to get all of the items for some other reason, you could actually filter using the API: https://support.airtable.com/hc/en-us/articles/223247187-How-do-I-sort-filter-or-retrieve-ordered-records-in-the-API-

One way to do this is to create a view in AirTable itself, and then filter for that with &view=noDueDate (assuming your view was called noDueDate).

1 Like

Thanks Rose. I’ll check that.

This is a shared airtable so a bit tricky if soneone changes the view. Hence I was hopping that Shortcuts could do the filtering…