Filter by inactive days but some Opportunities have waiting periods

Our use case: 

  • We need a way to get/create a comprehensive list of all opportunities that haven’t had any interaction for longer than 14 days
  • Some opportunities have a waiting period though
  • Opportunities with waiting periods should be excluded from the list until their waiting period is over 
  • Waiting periods can be any length of time

What I’ve tried:

  1. Filter by inactive days
    1. Includes opportunities still in their waiting period
  2. Add an activity towards the end of the waiting period, then filter by inactive days
    1. Cannot log an activity in the future 
  3. Add a new custom date field called “wait until”, then filter by inactive days and “wait until” date
    1. Filters can’t include results where the “wait until” field is null
  4. Add custom boolean called “To-Contact”, add workflow automation that checks inactive days and “wait until” date and sets “To-Contact” to true if inactive days>14 and “Wait until” = before today (or null). Then filter by “To-Contact” 
    1. Workflow automation trigger “check once a day” doesn’t work with custom fields. 
  5. Same as 4, but on the “when an opportunity is updated” trigger, then add a benign automation on the “check once a day” trigger that arbitrarily CONCAT(details, “.”)’s the description of each opportunity so that the opportunity is updated once a day to trigger the above workflow 
    1. Workflow automation trigger “when an opportunity is updated” doesn’t trigger when the update comes from another workflow automation.

Any suggestions? I’d love to get this sorted.


Best answer by Kevin from Copper 28 June 2022, 19:57

View original

3 replies

  1. Same as 4, but using “Last contacted date”, “inactive days” and “check once a day”. And if those 3 meet the requirements, set “To-Contact” to true. 
    1. Seems a custom field snuck in there and confused things and this wasn’t actually possible. 
Userlevel 3
Badge +1

@KyleLS nice speaking with you today. Here is a link to the recording.

Topic: Copper Workflow Automation Q&A
Start Time: Jun 28, 2022 09:00 AM

Meeting Recording:

For future viewers - To save you having to watch the recording:

Our solution was to repurpose the default field “close date” as our “wait until” date and write workflow automations around that. I also had to add a workflow automation that cancelled the default close date and changed it to the date that the Opp was created. 

Seems to be working now