I need a workflow which will check a custom list -for every row in this list- every day automatically and if the total value column is 0 then it will send an email to a user. Is it possible with SharePoint designer 2010 and InfoPath 2010? I can not use visual studio to develop a batch application.
|
If it's good enought to get a daily summary of new items where the total is 0, then you can create a view to show these and add an alert when new items enter the view. Otherwise a timer job is the right solution or as you're not allowed to use VS against the server a program using the client object model which is run on a client PC by the task scheduler. I'd only use the looping workflow described by @PirateEric as the last resort as it's a kludge which depending on the size of the list is going to put a heavy load your servers for no good reason. |
|||
|
|
Realistically this screams timer job to me, but since you said you can't use Visual Studio, we'll have to resort to workflows. There is a very detailed post on how to set up a for each type loop here, http://sharepointgypsy.blogspot.com/2011/11/create-for-each-loop-for-workflows.html. I recommend looking at that. |
|||
|