locked
Workflow - designer or c#? If there is no change on any of two lists -> e-mail every day RRS feed

  • Question

  • I have to prepare such workflow and I wonder how to do it.

    There are such lists: project (name and progress), docLibrary (just file).

    Manager who is assigned to specific project, is supposed to get an e-mail every day, if there was no modification on project or docLib during past 2 weeks (reminder - "Do Something Lazy!" ;)

    Any idea? :)


    For now, I figured out sth like this:

    1) SP Designer -> new workflow -> attached to: "Project" list -> automatically start when a new item is created/changed

    2) Conditions: If Modified equals Today

    Actions:

    -Add 14 days to Today (variable: DataEx)

    -hold till DataEx

    -send an e-mail to the user

    Problems:

    1)There will be always an e-mail after two weeks. I want to send an e-mail, only if there was no more modification since then.

    2) Workflow starts only, if there are change on Project list, but I have solution: (I can omit this, by creating another workflow on docLib -> Modify sth on Project list, when You upload new document to docLib)

    • Edited by simon17 Thursday, December 8, 2011 11:19 AM
    Thursday, December 8, 2011 10:59 AM

Answers

  • "There will be always an e-mail after two weeks. I want to send an e-mail, only if there was no more modification since then."

    A trick might work. Create new fields name "Modified Date".

    Update that field with "Modified" date field when workflow starts om item created. Wait for 14 days and after wait check condition

    if "Modified Date" is equal to "Modified" (don't ignore time)

    Send Email

    else

    Stop Workflow.


    Dare to promise
    • Marked as answer by Pengyu Zhao Thursday, December 15, 2011 9:49 AM
    Thursday, December 8, 2011 4:23 PM