I know there is a similar thread out there (https://community.zapier.com/topic/show?tid=609&fid=3https://community.zapier.com/topic/show?tid=609&fid=3), but it was closed 2 years, so I thought there might a solution meanwhile.
My customer is a money exchange office and we have the following challenge:
We need to track how much money a customer has been exchanging in a given time, i.e. which total amount did he/she exchange within the last 30 current days. I also need to cross-check his/her current 30-days-spend at each exchange to trigger off some zaps.
Has anyone found a solution or has a hint how to do it (all proposals, even outside of Zapier, are appreciated)? The excel formula is actually no rocket since at all, but integrating it in a zap seems to be a challenge...