Hey everyone! I’m trying to pull email addresses from an email field in Airtable using the Search Records module. I’m able to select the field as an output field but when I run the module, it doesn’t return the email field. I’ve also created a new field to convert the email address to a string just in case that was an issue. The module doesn’t pull that field in either. What am I missing?
I’ve figured it out. I have a formula {Onboarding Survey Date}=‘{{formatDate(now; “YYYY-MM-DD”)}}’ to filter out records. For some reason, removing that formula allows the module to pull all of the fields I’ve asked for. Anyone know why this could be?
Hey @cheneric86,
Welcome to the 
community.
Airtable Search is working with FilterByFormula.
I’ve already given multiple answers on this topic about how to use Airtable FilterByFormula with Make.
Please check these answers, where I’ve also attached multiple related to it.
Hi @dilipborad, thanks for the welcome!
The filter that I used {Onboarding Survey Date}=‘{{formatDate(now; “YYYY-MM-DD”)}}’ actually works in filtering out records I don’t want pulled. However, my issue is that the formula is somehow preventing all the fields I need from that record.
In this example, I have the filter pulling records where the Onboarding Survey Date field contains today’s date. When I run the scenario, it properly pulls the 1 test record that has today’s date in that field. However, in my scenario, I ask the Search Records module to pull fields A, B, C, D, and E but somehow only fields A and C get returned. When I remove the filter, the module correctly pulls in all records from the base and all fields.
I looked through the posts you linked and I think they only address the correct use of FilterByFormula which I think I’m using correctly. Am I misinterpreting your reply?
Thanks again for helping, by the way.