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...