Skip to main content

I use Integromat to automatically get the records, and I’m trying to create a search formula to get the list of records that have a birthday a week from now. Here’s the filter:


Where {{Birthday}} is within the next number of days '7'


How can I make a search formula based out of this filter? I like something from the FROMNOW(Ndate]) which Birthday is the column, but there’s no integer to mark the days. Hope to hear back soon.

Welcome to the community, @Michael_Harris! :grinning_face_with_big_eyes: This topic came up almost a year ago, and generated some interesting discussion. You should find what you need in this thread, which I dug up by searching the forum for “birthday”:


Welcome to the community, @Michael_Harris! :grinning_face_with_big_eyes: This topic came up almost a year ago, and generated some interesting discussion. You should find what you need in this thread, which I dug up by searching the forum for “birthday”:




Ok, but I’m looking at a search formula, especially for a automation API (like Zapier, IFTTT, Integromat etc) that does not use a <TriggerValue>. What I tried is using the formula DATEADD({Birthday},-7,'days', but unfortunately formula is not valid. Where Birthday is the column.

Ok, but I’m looking at a search formula, especially for a automation API (like Zapier, IFTTT, Integromat etc) that does not use a <TriggerValue>. What I tried is using the formula DATEADD({Birthday},-7,'days', but unfortunately formula is not valid. Where Birthday is the column.


Sorry. I somehow missed your mention of Integromat in your original post.


If you read that thread I mentioned, you’ll find a formula that puts an emoji into a field if the birthday is seven days away. In Integromat, use a formula in your trigger module to look for anything in that field. To do that, all you need is the field name. If you named this Airtable formula field {BDay Trigger}, then the formula in Integromat would be:


{BDay Trigger}

If the formula returns an emoji because the birthday for a given record is 7 days away, that record would be picked up in Integromat.

Reply


Terms & Conditions