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.
+21Welcome 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.
+21Ok, 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.