Hi. I think there must be a simple solution to this, but I can’t quite get my head around it!
I have a make scenario that looks like this. The formula inside the Airtable ‘search records’ module is:
IF(OR({AssessorEmail} = '{{6.sender.emailAddress.address}}', {AssessorEmail} = '{{6.from.emailAddress.address}}'), 1, 0)
But every ‘search records’ run uses loads of credits (one for each record, - and I have over 300, as things stand).
I THINK I need to create a single text field somewhere, that lists all the email addresses in the email column so that I can search the text in that field for a match, using only one credit.

Is there a recommended or elegant way to do this, please? 😊
