I’m looking for a way to extract the changes from a specific column (string).
I have a base with client names and each client has its account manager (each account manager can handle more than one client).
We work in a dynamic environment, and the account managers’ responsibility changes frequently.
Given the above background, I want to create new automation using Zapier/Integromat to inform the previous account manager via email that he doesn’t own this account anymore.
I can create a last modified field and use it to trigger Zapier/Integromat, but how can I extract the old value from this cell?
Current A.M name: Dan
I’ve added a new A.M named Stan
Now the trigger has been activated, but the cell value is Stan
How can I get the previous cell value in order to send the previous A.M an email?
Any idea would be very helpful.
Thanks in advance for helping!