Solved

How to send reminder if no account activity in last month

Posted on 2008-10-26
5
345 Views
Last Modified: 2013-11-27
Hi,
I'd like to set up a workflow so that if there is no email activity to or from a particular account (any of the child contacts), a reminder email is sent to the owner of that account.

Any ideas on how I could achieve this?

0
Comment
Question by:nick34567
  • 3
  • 2
5 Comments
 
LVL 15

Accepted Solution

by:
WilyGuy earned 500 total points
ID: 22812256
Not sure Workflow is the best way to go.  What would you use to call it?  Would it be manual?
The firing conditions on a workflow don't lend themselves to things "not happening"
In addition, there is no ootb way to check for something that doesn't exist.

More likely you want a custom report.  That lends itself more to a manual process, though.

I could see a SQL procedure or nightly job to run a query to check for activity related to an account.  With that information, you could update a flag in CRM (likely unsupported).

Advanced Find is another tool, but because we are looking for a "sub-entity" that is possibly NULL (if there has never been an email) that is going to be less effective.

You could create a custom field in CRM for "Last Emailed" on the Account Entity.  Then every time you create an email a workflow updates that flag.  Then you could query on that flag (you could set it initially with the account creation date, so it would never be NULL and would include accounts that had NEVER been emailed).  This should work for emails that are created in the web client and should for outlook emails, but if the client emails you and you simply track it, I am less sure.
0
 

Author Comment

by:nick34567
ID: 22817542
This has been my dilemma.  

I have already set up 'Last Contact' field on the Account entity, which is updated whenever an email is created in the database - this works with both incoming and outgoing.  I think I will set a workflow to timeout until a month after this fields value, then send notification and update last contact to the current date, and start itself again.

It's a bit messy though,and would make allot more sense if a check could be done each night.

Would the SQL procedue be hard to set up?
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22817755
Well, if you already have the flag working, you are more than half way there.

The kicker for you is how are you going to use the workflow?
0
 

Author Comment

by:nick34567
ID: 22817834
Just started doing this as I got sick of trying to think up a better way to do it.

WF1:  Update Last Contact date, fires on creation of email.
WF2:  Fires on creation of account.  I'll need to kick it off manually for existing accounts.  Times out until a month after Last contact date, sends notification, updates Last Contact date and fires itself again.  I''ve also put a 'Last Contact Name' field so I can determine whether the Last Date was set by workflow or by an actual activity - the notifications will reflect this.

Seems awfully messy though....

0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22820177
So the workflow is running against each account and IT is sending an email to the account, or the owner of the account?
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack 7.0.0.23 or Above. The following steps a…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now