There are going to be cases where my business partners operate in multiple locations.
I’m having an issue whereby, when a location is selected by the customer and a partner operators in multiple locations, they receive an email with the customer information twice. The customer information would just be a duplication so is unnecessary.
Is there a way to prevent this?
Thanks in advance!
Hi
You would have to add custom Code logic to remove duplicates.
Guide:
Thanks troy, but unfortunately this doesn’t work as I have a loop which checks each of the locations and finds the associated email. If the email appears multiple times, it sends a the email for each time the associated locations are selected.
Change the order of operations for the Zap step logic.
Before looping, find all of the locations from the GSheet, then use the Code step to determine the matching locations as well as do the deduplication, so you are left with the unique emails to send thru the looping.
Still struggling even when i re-arrange the code steps. For some reason, having the GSheet lookup after the formatter, it isn’t able to recgonise the locations. However, when the loops is in place it does. As a result it isn’t able to progress to the code block
GSheet Lookup Value fields don’t accept arrays.
You would need to add another column with a common value to use to lookup ALL the GSheet rows to then be processed by the Code step.
The Code step would come before the Looping step.
If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts
what would be an example of a common value to lookup all the rows?
Column: Lookup
Value: TRUE
Hi 
Just came across this and wanted to check how you’re getting on?
Let us know whether you’re in need of any further help here—keen to ensure this gets sorted!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.