The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hey Nick,
The short answer is YES! It requires a 3 step Zap. Since you’re familiar with Zapier, I’m skipping some of the regular steps and focusing on the ones specific to this setup.
Setup Zapier webhook
Using Zapier, create a webhook
Select the C...
Ah, got it! They’ve actually written about this exact issue and how to work around it in this article.
Take a look and let me know if you still have any questions on how to implement it within your own base :grinning_face_with_big_eyes:
Hey Ivan, I may not be understanding you correctly, but it seems like you’re trying to filter on a field that can only include one Account ID at a time. Therefore, it wouldn’t be possible to have two Account IDs (Account ID 1100 AND Account ID 1110) ...
You could do it this way:
IF(
{Event Type}="Pickup",
IF(
DATETIME_DIFF({Event Date}, Today(), 'days')=0,
"P/U",
IF(
DATETIME_DIFF({Return Date}, Today(), 'days')=0,
"Ret",
"ABS"
...
Don’t worry Susan, I got you! I’ve chosen to compare the dates directly to simplify it a bit, rather than subtracting one from the other, but your way could work just as well. You may have just run into a syntax error.
Try this out and let me know if...