Skip to main content

Hi All, 

I have a zapier that I’d like to push contact us form submissions from the last 7 days from Salesforce to Slack. 

Right now, I’m not able to get it just right. 

The Zap’s Current State: 

  • If a Contact Record is updated and the ‘Recent Conversion’ field contains ‘Contact Us’
  • Find a Salesforce Record (looking for the User to bring in the contact owner’s name)
  • Filter Conditions to look at ‘Recent Conversion Date’ is before zap_meta_human_now
  • Date/Time Format (Input: zap_meta_human_now, Expression: -7d, To Format: ddd MMM DD HH: mmLss Z YYYY
  • Delay Zap for 2 minutes (to give SFDC round robin to work)
  • Slack Message (Name of contact, owner of contact, etc)

 

Current Issue: 

  • I’m seeing that any contact that is updated and the recent conversion contains ‘contact us’ the zap is triggered
  • I ONLY want to see contacts where the Recent Conversion Date is within the last 7 days

 

How do I fix this?

Hi ​@healthiejames 

For us to have full context, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.


 


@Troy Tessalone Let me know what you think based on the provided images. I can provide more details if needed


@healthiejames 

In the screenshots, it does not show the logic related to “Contact Us” in any Zap step, so if that is a requirement, then make sure to configure that logic.

 

Seems like the Filter step should be Zap step 2 to prevent the Zap from running when conditions are not met.

Help links for using Filter: https://zapier.com/apps/filter/integrations#help

 

You may need to convert the Zap Human Meta Now variable value timestamp format so it works correctly in the Zap Filter step condition: https://help.zapier.com/hc/en-us/articles/8496030961165-Use-filters-so-your-Zap-only-triggers-on-certain-days-times#h_01HKM97FPVXTFWV3134V7E4H1X

 


Hey ​@healthiejames, just checking in—were you able to get this sorted by updating the filter and converting the Zap Human Meta Now variable as Troy suggested? 

Let us know if you still need any help! 🙂


Appreciate the help!

I ended up using a Salesforce flow to ping Slack instead. All good!


Thanks so much for getting back to me, ​@healthiejames 🤗 Really glad you got it sorted—even if it didn’t involve a Zap. 

Feel free to reach out again if there’s anything else we can help with!