Apr 15, 2020 10:48 PM
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([date])
which Birthday
is the column, but there’s no integer to mark the days. Hope to hear back soon.
Apr 15, 2020 11:57 PM
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”:
Apr 16, 2020 01:13 PM
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.
Apr 16, 2020 08:19 PM
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.