tag:blogger.com,1999:blog-3981477210525148311.comments2023-03-08T08:21:16.846-05:00SharePoint GypsyTom Molskowhttp://www.blogger.com/profile/01224161982994081203noreply@blogger.comBlogger185125tag:blogger.com,1999:blog-3981477210525148311.post-56854987630296905192015-12-11T18:09:36.553-05:002015-12-11T18:09:36.553-05:00Hey Ghim,
No, I would not use this method in SP 2...Hey Ghim,<br /><br />No, I would not use this method in SP 2013, there are better ways to do this in SP 2013, and I will eventually post an article about that.<br /><br />Thanks!<br /><br />TomTom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-90327412495018570152015-02-26T02:47:43.421-05:002015-02-26T02:47:43.421-05:00Hi Tom,
May I know if the above works for SPD 201...Hi Tom,<br /><br />May I know if the above works for SPD 2013? I created 2 lists & workflows following your steps above, but when I start either one of the workflows, it only updates the counter in the other list but fails to trigger the workflow after that. Not too sure what went wrong. <br /><br />Appreciate if you might be able to provide some advice on this.<br /><br />Thank you!Ghimnoreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-26283112684287013232014-05-09T12:45:21.126-04:002014-05-09T12:45:21.126-04:00For everone who is having problems getting this to...For everone who is having problems getting this to work, the code attempts to get theInputMLTRR before the page was finished loading. moving "var theInputMLTRR = getTagFromIdentifierAndTitle("TextArea","TextField","Reassignment Reason");" into the hideField function enabled this to work on sharepoint 2007.<br /><br /><br />Change<br /><br />_spBodyOnLoadFunctionNames.push("hideField"); { <br />var theInputMLTRR = getTagFromIdentifierAndTitle("TextArea","TextField","Reassignment Reason"); <br />//*** Hide the Field *** <br />function hideField() <br />{ <br />theInputMLTRR. parentNode.parentNode.parentNode.style.display = "none";<br />}<br /><br /><br />To<br /><br />_spBodyOnLoadFunctionNames.push("hideField"); { <br />//*** Hide the Field *** <br />function hideField() <br />{ <br />var theInputMLTRR = getTagFromIdentifierAndTitle("TextArea","TextField","Reassignment Reason");<br />theInputMLTRR. parentNode.parentNode.parentNode.style.display = "none";<br />}<br />Anonymoushttps://www.blogger.com/profile/14314842160353980908noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-56726823277865165902013-12-04T16:01:09.563-05:002013-12-04T16:01:09.563-05:00Hey Greg,
Yes definitely post it up, I'd love...Hey Greg,<br /><br />Yes definitely post it up, I'd love to see what you have done with it.<br /><br />Thanks!<br /><br />TomTom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-14592840232848013102013-12-04T11:42:53.684-05:002013-12-04T11:42:53.684-05:00Thanks for the WF loop Tom, I was able to take it ...Thanks for the WF loop Tom, I was able to take it and alter it to my library or any library actually and after many trials, errors and all I finally got it linking through all items and finishing off, I also got it down to just 2 WF.<br />Again thanks a lot for the great work. If you want I can post it up.<br />GregGreghttps://www.blogger.com/profile/05286190196124049456noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-79394292694739937212013-07-31T00:52:07.225-04:002013-07-31T00:52:07.225-04:00All above post is very clear to understand about f...All above post is very clear to understand about for each loop.<br />Thanks for sharing this .<br /><br />Read also here about - for-each loop limitations Three scenarios where you can not use for each loop<br /><br />http://efectivejava.blogspot.in/2013/07/for-each-loop-limitations.htmlSaroj Sainihttps://www.blogger.com/profile/16739586739802266523noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-58993655138794186412013-06-27T15:02:34.478-04:002013-06-27T15:02:34.478-04:00I think I found the reason some commenters (myself...I think I found the reason some commenters (myself included) were having issues with the workflow stopping after the first four items:<br />In 4l you posted a picture for configuring the activity to update the item in the Loop 2 list. In the picture the matching value is where Title = "New Item." My guess is that people were actually typing "New Item" in when the name of the item in their Loop 2 list was something different. Therefore, when the For Each Loop 1 workflow finished pausing and attempted to update the item in the Loop 2 list, it could not find a match and the workflow stopped.<br /><br />It is probably safer then to pull the match where ID = 1, as you did in 6g. This should alleviate the problem.<br /><br />Of course, after finding that out I ran into an issue wherein the workflow doesn't stop, but does endlessly run its cycle over the first four items again and again. Your earlier recommendation of having one workflow set Processed to "Yes" and a second to set Processed to "No" should solve this.<br /><br />Finally, I noticed in an above comment (7/10/2012) that Brady had the Field LoopCountValue set to 0 in the Loop 1 item update, and you indicated the value should be 1. Your picture in 6g displays a value of 0; I am assuming that's why Brady had it set the way he did!<br /><br />Thanks for the post! It's proving very educational for me.Philip Stichtenothnoreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-5578551432719942972013-06-10T22:17:33.453-04:002013-06-10T22:17:33.453-04:00Hello Vmrao,
You need to add another Update List ...Hello Vmrao,<br /><br />You need to add another Update List Item action to the Delay workflow. In the Update List Item update the first item in the Loop 1 List. <br /><br />Please let me now if this works for you, I'll check for updates tomorrow night.<br /><br />I hope that helps!<br /><br />TomTom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-88644319598822440772013-06-10T22:00:36.846-04:002013-06-10T22:00:36.846-04:00Hello Vmrao,
Thanks for your posts and I apologiz...Hello Vmrao,<br /><br />Thanks for your posts and I apologize for not apologizing sooner but I have been working on a new 2013 workflow project.<br /><br />I'm glad you seem to have gotten the solution to work, and I have updated the posts in the area of 7h and 8.<br /><br />Unfortunately in SP 2010 you will have to essentially run the workflow twice, once for flipping the yes to no, and once for flipping the no to yes. You could add this as a secondary workflow that gets called when the primary workflow completes.<br /><br />In SP 2010 there is a free workflow scheduler tool available from HarePoint - the tool provides the following capabilities:<br /><br />•Starting site and list workflows manually or automatically by schedule. <br />•Starting list workflow for all documents or list items or for those selected manually or by CAML query. <br />•List views support. It is extremely topical for such lists as Tasks where you may select, for example, “Due Today” view so that the workflow would process only tasks for today, rather than all ones in the list. <br />•Setting workflow launch parameters, including parameters described in the InfoPath form linked to the process. <br />•Adjusting flexibly the autorun schedule: by days of the week, by dates in a month, daily at a specified time, etc. <br />•Receiving alerts, daily or weekly summaries by email or via SMS with workflows results. <br />•Specifying accounts under which the workflow can be launched.<br /><br />You can also try the timer loop workflow I designed - http://sharepointgypsy.blogspot.com/2011/01/sharepoint-designer-workflows-3.html<br /><br />Again, thanks for the comments - if there are any other changes needed to my post or you need additional answers please let me know.<br /><br />I hope that helps!<br /><br />Tom<br /><br />Tom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-84033901107304368182013-06-10T22:00:21.487-04:002013-06-10T22:00:21.487-04:00This comment has been removed by the author.Tom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-46429685569363354552013-06-10T22:00:16.254-04:002013-06-10T22:00:16.254-04:00This comment has been removed by the author.Tom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-26444272958951778032013-06-10T15:45:21.912-04:002013-06-10T15:45:21.912-04:00Hi Tom,
I need to implement a solution which is a ...Hi Tom,<br />I need to implement a solution which is a combination of your Timer loop and For Each solutions. The For Each solution is working great. But I am not sure how to combine both solutions into one. Would the Data List serve as the Endless Loop List too when we are combining both the solutions ? How do I trigger the workflow on 'For Each Loop List 1' from the Timer Loop Workflow ? Can you please list the steps needed to combine both the solutions.vmraohttps://www.blogger.com/profile/13330637245231428487noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-9334461930577522652013-06-07T16:42:20.240-04:002013-06-07T16:42:20.240-04:00Hi Tom,
Thanks. Nice work around solution for ...Hi Tom,<br /><br />Thanks. Nice work around solution for 'For Each Loop'.<br /><br />It looks like, the processed should not be set to 'No' as mentioned in the instrcution 7H.<br /><br /> But finally when the workflow completes, all the items have processed set to 'Yes'. <br /><br />How to reset the Processed value to 'No' for all the items after the workflow completes ? <br /><br />Also, What are the additional steps needed so that the For Each Loop runs automatically everyday ?<br /><br />I think the above two are common requirements if someone is looking for a For Each Loop solution. If you can incorporate those steps also as an addendum to this solution, I think that would be really helpful.vmraohttps://www.blogger.com/profile/13330637245231428487noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-30963966473436557112013-06-07T14:21:56.566-04:002013-06-07T14:21:56.566-04:00Hi Tom,
Nice article and exactly what I was look...Hi Tom, <br /><br />Nice article and exactly what I was looking for. But, does not work for me as stated.<br /><br />First of all, few things are not clear in the steps mentioned.<br /><br />In the step 5L, the screenshot shows to match Title field with value of 'New Item'. I think the value should be <br />'For Each Loop 2' as that is the Title for the item created in Loop2.<br /><br />In the step 7H, the instruction says to change the value of 'Processed' to 'No' but the screenshot does not show that.<br /><br />In step 8, the instruction says to run the For Each Loop workflow in the Loop List. It is not clear which Loop List,<br />Loop 1 or Loop 2 List ?<br /><br />I started the For Each Loop workflow on Loop 1 List in two different ways but both did not work as desired.<br /><br />a) If I go along with the screenshot under 7H (processed is not set to No), all the items in the Data List are<br />getting processed but they remain at processed value 'Yes' and starting the For Each Loop workflow again would <br />lead to Error.<br /><br />b) If I go along with the text instruction under 7H (processed set to No), only the first 4 items are getting processed <br />again & again in the Data List.<br /><br />In our environment, the pause is not working exactly as specified as 1 or 2 minutes. Sometimes it takes 5 to 10 <br />minutes for the workflow to trigger again after pause. May be that is the reason that my b) approach does not work and <br />the first 4 items are getting processed again & again.<br /><br />For this solution to work properly, the pause should work perfectly in the environment. Is that correct ?vmraohttps://www.blogger.com/profile/13330637245231428487noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-24481592872445404752013-04-03T15:16:29.173-04:002013-04-03T15:16:29.173-04:00Folks,
I am having the same problem many of you a...Folks,<br /><br />I am having the same problem many of you are reporting, the workflow stalls after 5 items are processed. Has anyone actually got this to work? I have 'tuned' the pause timings no end and still the problem persists. Any help would be most appreciated.<br /><br />TNX,<br />MikeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-63320659231961191552012-12-31T21:07:11.302-05:002012-12-31T21:07:11.302-05:00Hey Mario,
Sorry for the late reply, it's bee...Hey Mario,<br /><br />Sorry for the late reply, it's been a busy few weeks for me.<br /><br />On Step 1, both Update Item(s) are to update the First Run field to Yes?<br /><br />I've looked through the instructions but I'm not sure where you see the instruction to update the First Run item twice, can you post the exact comment you are referring to?<br /><br />The Task Workflow is not updating the Values on the Review Process Library. Any idea why? <br /><br />Do you recieve any errors? Can you post one of your tasks (images and text) so I can review it?<br /><br />Thanks!<br /><br />Tom<br /><br />Tom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-70932025460126023802012-12-31T20:38:48.736-05:002012-12-31T20:38:48.736-05:00Hello G,
In SP 2010 there is a free workflow sche...Hello G,<br /><br />In SP 2010 there is a free workflow scheduler tool available from HarePoint - the tool provides the following capabilities:<br /><br />•Starting site and list workflows manually or automatically by schedule. <br />•Starting list workflow for all documents or list items or for those selected manually or by CAML query. <br />•List views support. It is extremely topical for such lists as Tasks where you may select, for example, “Due Today” view so that the workflow would process only tasks for today, rather than all ones in the list. <br />•Setting workflow launch parameters, including parameters described in the InfoPath form linked to the process. <br />•Adjusting flexibly the autorun schedule: by days of the week, by dates in a month, daily at a specified time, etc. <br />•Receiving alerts, daily or weekly summaries by email or via SMS with workflows results. <br />•Specifying accounts under which the workflow can be launched.<br /><br />I have not tried the solution in 2013, but SPD 2013 does support SP 2010 workflows. On the other hand, in SPD 2013 there are better ways to do For-Each-Loops, so you might try those methods as well.<br /><br />Thanks!<br /><br />Tom Tom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-1717571782437615262012-12-31T20:09:36.146-05:002012-12-31T20:09:36.146-05:00Hello,
Can we accomplish the above code in DispFo...Hello,<br /><br />Can we accomplish the above code in DispForm? <br /><br />Since the display form does not allow input, I don't see a way to trigger the hide/reveal.<br /><br />and is it compatible with SP2010?<br /><br />I'm not sure, I have not tried it because in a SP 2010 list you can now use Infopath to create advanced list forms and obviously this is a much better way to go.<br /><br />Thanks!<br /><br />TomTom Molskowhttps://www.blogger.com/profile/01224161982994081203noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-48569874672776275702012-12-30T16:51:40.912-05:002012-12-30T16:51:40.912-05:00Hi Tom,
Newcomer to workflow design, but basicall...Hi Tom,<br /><br />Newcomer to workflow design, but basically just want a workflow to run the same time everyday to update a field with the current date in it. <i>(Basically so I can calculate the age of a file since it was last modified, so there may be an easy way of doing this)</i> I thought this would be a good way to do it and learn a bit about work flow in the process. However when I get to step 5g the system will not allow a variable to be input and keeps asking for a number. I might be missing something but followed the guide a few times and come unstuck at the same point every time.<br /><br />I am currently using Office 365 2010 but understand that MS are currently upgrading users to the 2013 version which might be causing my problem as I have been advised by MS to upgrade to SP Designer 2013.<br /><br />Any help and guidance you can give would be greatly appreciated.<br /><br />Many Thanks<br /><br />GGraham Shawhttps://www.blogger.com/profile/04244624342550593101noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-61844310382311060592012-12-27T10:03:26.021-05:002012-12-27T10:03:26.021-05:00Hi Tom,
Thank you very much for your valuable...Hi Tom,<br /> Thank you very much for your valuable post.<br /><br />With Regards,<br />Rajendhiran MuthusamyRajendhiran Muthusamyhttps://www.blogger.com/profile/14540360824327031952noreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-5702156098837459802012-12-18T19:24:16.920-05:002012-12-18T19:24:16.920-05:00Hello Tom,
The Task Workflow is not updating the...Hello Tom, <br /><br />The Task Workflow is not updating the Values on the Review Process Library. Any idea why? I followed the same steps you indicated on your 2 articles.<br />Why is it necessary to Update the First Run field twice during the Initialization Step? <br />Any help will be greatly appreciated. <br />Regards, <br />Mario <br />msaaval@me.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-33935722175514761672012-12-17T15:53:51.637-05:002012-12-17T15:53:51.637-05:00On Step 1, both Update Item(s) are to update the F...On Step 1, both Update Item(s) are to update the First Run field to Yes?<br />Thanks, <br />Mario<br />msaaval@me.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-20765259197904567872012-12-11T12:28:42.204-05:002012-12-11T12:28:42.204-05:00You are Great. This is what I was looking for!!! T...You are Great. This is what I was looking for!!! Thank you very much.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-91248406141395942932012-12-06T03:31:09.747-05:002012-12-06T03:31:09.747-05:00Hi Tom,
Can we accomplish the above code in DispF...Hi Tom,<br /><br />Can we accomplish the above code in DispForm? and is it compatible with SP2010?<br /><br />Thanks<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3981477210525148311.post-42887522194888482832012-11-19T18:38:04.774-05:002012-11-19T18:38:04.774-05:00Tom,
Please disregard my earlier comment. Upon re...Tom,<br /><br />Please disregard my earlier comment. Upon re-reading, I see clear as day:<br /><br /><b><i>I use a Boolean called First Run to tell me if the workflow has been rerun and if so to protect against certain conditions causing errors. As you will see, all the other steps will only be run if First Run equals “No”. The First Run value is changed when the Action “Update Items in Tasks” runs (the third Action in this step).</i></b><br /><br />Again, thank you for sharing your wonderful work!<br /><br />-imberAnonymousnoreply@blogger.com