Not quite. I was trying to point out that there are many ways of going about finding the records you want. You also didn’t say how you determine which month is the month you want.
You can limit the records in a view by filtering based on AND or OR conditions, but not both. If you want to find all the records for Dave in the month of December 2020, you could have a filter using AND conditions.
Name contains “Dave”
Date is on or after Dec 1, 2020
Date is on or before Dec 31, 2020
This method uses only the filtering for the view, but you mentioned wanting a formula, so it wasn’t clear if you wanted to filter the view with or without a formula.
By the way, you say that you’re working on an Integromat integration. You haven’t said how you are searching for the records, but it seems like you are trying to limit records to a view. If you are trying to control the search from the Integromat side, please post more details.
Now that I’ve had time to become more familiar with Airtable, I have come to realise that the search conditions are achieved within the view filters and formulas, which is what you were suggesting! Now that I appreciate this, it makes a lot more sense :slightly_smiling_face: I’m all good on this question now.