Because there is no AND condition for searching both Lead and Contact in Salesforce, is there any IF...ELSE with Zapier filter that we could use. I can adjust my current workflow to use IF...ELSE as alternatives for AND condition.
My goal is to check the email does not existing in Lead and Contact in order to save a new record in Salesforce; otherwise, it will cause an error in Zapier task about duplicated records.
Best answer by SamBBest answer by SamB
Just wanted to pop in here for anyone looking to build a similar workflow, but doesn’t want to upgrade to the Professional plan, to suggest using Filter by Zapier instead of Paths.
With Filter you could handle this in a single Zap using the following steps:
1. Trigger: New Form Submission in Gravity Forms
2. Action: Find Record in Salesforce (searches for the lead and also has the option to create one if an existing lead record isn’t found)
3. Action: Only continue if _zap_search_was_found_status field is false in Filter by Zapier (meaning that no existing lead was found)
4. Action: Find Record in Salesforce (searches for the contact and has the option to create one if an existing contact record isn’t found)
5. Action: Only continue if _zap_search_was_found_status field is true in Filter by Zapier (means that an existing contact was found)
6. Action: Update Record in Salesforce (use the ID number for the contact found by step 4 so that the Zap knows which contact to update)
And for other ways to handle If/Else logic in a Zap you may want to check out this related thread:
+9Hey! What’s to stop you using paths here for this use case?
You can say - If LEAD exists - PATH A
ELSE - PATH B - Search Contact?
Hi
Could you provide more hint because I cannot find an option to do that? Here is our workflow:
I cannot find the way to do with Zapier Filter app.
Regards,
Nguonchhay
+9Hey, So with paths - You would be able to choose the path based on the result here. Sorry - I should have sent you to the help article - My bad:
Hi
Thanks for your article. Let me try and I will get back to again if I have more question.
Regards,
Nguonchhay
Hi
I just quick look to Zapier account. It is a starter plan. For the professional plan, are there any demo accounts for testing? I want to proof it first before making suggestion to manger to upgrade an existing account.
Regards,
Nguonchhay
+9Yes. Zapier actually lets you test it out and build your entire flow using paths, so you can see if it would work as a POC, from there you can purchase the appropriate plan before turning it on
Hi
I mean we already have an account as Starter plan with Zapier but the Path that you mentioned is only for Professional plan. So I want to have a place to test whether it is fit our workflow before making the suggestion. Is that possible to have that kind of option?
Regards,
Nguonchhay
+9I think you can though. What happens when you try to add a path?
Hi
So there is no option to test for Professional plan besides upgrade existing account. Thanks for your reply. I will discuss with my team.
Regards,
Nguonchhay
+11Just wanted to pop in here for anyone looking to build a similar workflow, but doesn’t want to upgrade to the Professional plan, to suggest using Filter by Zapier instead of Paths.
With Filter you could handle this in a single Zap using the following steps:
1. Trigger: New Form Submission in Gravity Forms
2. Action: Find Record in Salesforce (searches for the lead and also has the option to create one if an existing lead record isn’t found)
3. Action: Only continue if _zap_search_was_found_status field is false in Filter by Zapier (meaning that no existing lead was found)
4. Action: Find Record in Salesforce (searches for the contact and has the option to create one if an existing contact record isn’t found)
5. Action: Only continue if _zap_search_was_found_status field is true in Filter by Zapier (means that an existing contact was found)
6. Action: Update Record in Salesforce (use the ID number for the contact found by step 4 so that the Zap knows which contact to update)
And for other ways to handle If/Else logic in a Zap you may want to check out this related thread:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
