Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

2 Answers

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.

share|improve this answer
    
A daily summry can solve my problem but I need to find all this items first. So maybe PirateEric's sugestion can solve my problem. I'll try it. –  compengTR May 22 '12 at 9:55
add comment

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.

share|improve this answer
    
Thanks, PirateEric, maybe this can solve my problem but I think this will take long time. But I'll try it. –  compengTR May 22 '12 at 9:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.