Hi there,
I’m new to the world of Zapier, and I’ve soon realized that there is a lot to learn!
Currently, I’m trying to send data (on record update) from system 1 to system 2.
System 1 contains a unique reference in a field. This could be “ABC1234, A Short Description Here”.
System 2 contains a simplified version of this reference “ABC1234”. - note: without the “A Short Description Here” suffix.
Each record will have it’s own unique reference. i.e. another record in System A and B could start with “XYZ4321”.
Is there an easy way to extract the dynamic reference (before the first comma) from system 1, match this reference to system 2, and then update system 2 accordingly?
Thank you!