http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Sat, 21 Feb 2009 02:07:32 +0000 http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4324 Tue, 17 Feb 2009 20:42:43 +0000 AutoSponge 4324@http://www.endusersharepoint.com/STP/ <p>@eric,</p> <p>No, if I'm correctly mistaken, the toughest part about workflows is the logic.</p> <p>:P </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4311 Tue, 17 Feb 2009 17:28:13 +0000 eric 4311@http://www.endusersharepoint.com/STP/ <p>No problem, the toughest part about workflows is the logic. </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4308 Tue, 17 Feb 2009 17:03:08 +0000 jaxkookie 4308@http://www.endusersharepoint.com/STP/ <p>@eric, thanks. I think I am starting to see the big picture on this. it's going to take some time to think this through and figure it out, but your post definately helped clarifying some of it for me. </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4306 Tue, 17 Feb 2009 16:45:58 +0000 eric 4306@http://www.endusersharepoint.com/STP/ <p>What Paul was getting at was you create a secondary list called Admins. There are 3 columns in the list defined as numbers, each column named for your admins. The single row would be called total.</p> <p>When your workflow runs, it looks at the Admin list, for the lowest value in the 3 name columns, it send the email to that admin, then updates the column value by 1. Next time the workflow is run, it will select one of the other 2 admins send the email and increment the value by 1, etc.</p> <p>You can test the functionality of it by entering seed values (like 3,2,1) and testing the workflow on new item submissions. The first process should sent an email to who ever is assigned as admin 1. Next workflow should select one of the 2 admins with a value of 2, third workflow should select the remaining user with 2. </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4304 Tue, 17 Feb 2009 16:30:41 +0000 jaxkookie 4304@http://www.endusersharepoint.com/STP/ <p>Thanx for the update, Hope he enjoys his time off. </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4300 Tue, 17 Feb 2009 15:04:36 +0000 EndUserSharePoint 4300@http://www.endusersharepoint.com/STP/ <p>Jax - I wouldn't expect to hear from Paul for a while. He takes off on vacation tomorrow and is going to be gone for a week. You might have to try to hack it out for a bit until he returns. -- Mark </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4295 Tue, 17 Feb 2009 14:52:13 +0000 jaxkookie 4295@http://www.endusersharepoint.com/STP/ <p>@laura67, thanks, you are always quick to respond which is very important with this type of forum. I am still drawn to AutoSponge's concept. I like the second list idea. this provides a way to change the names in hte second list with out disrupting or working on the workflow. I am not sure how to begin this. </p> <p>@AutoSponge, I know your busy, but if you get the time to explain I would be very interested. </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4264 Mon, 16 Feb 2009 18:50:08 +0000 laura67 4264@http://www.endusersharepoint.com/STP/ <p>There is a way to do this random number thing in the data view web part, but the data isn't stored in the list. You might not be interested, but here's how it's done.</p> <p>1. Insert your list as a multiple item view DVWP<br /> 2. Insert a new, blank column in the table.<br /> 3. Put a name in the header cell, such as "Random"<br /> 4. Put your cursor in the first cell of the data for this column<br /> 5. Click the &lt;Data View&gt; menu in the top toolbar of SPD<br /> 6. Choose "Insert Formula"<br /> 7. For the function, choose Random<br /> 8. Use the syntax provided. </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4257 Mon, 16 Feb 2009 10:36:55 +0000 jaxkookie 4257@http://www.endusersharepoint.com/STP/ <p>I have been working on generating a random number 1 - 3. out of 75 posts it is very close to equal. I am not sure if this is the route I should be going. How would I assign an admin in a column then assign the next admin from another column in the second list? </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4237 Fri, 13 Feb 2009 16:06:55 +0000 jaxkookie 4237@http://www.endusersharepoint.com/STP/ <p>Yes I think I can make this suggestion work. I have created my secondary list. I have my columns: 1 admin, 2 admin, 3 admin. Now I am not sure if I followed your explaination. what do you mean check for the lowest # in that record? in my original intake? I am still trying to figure out how to generate my number. I know I cant grab the ID cause it is not available until item posts. can a calculated field generate a randon num, say from 1-3? </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4221 Fri, 13 Feb 2009 12:20:34 +0000 AutoSponge 4221@http://www.endusersharepoint.com/STP/ <p>It really depends on your logic but in the past I've used secondary lists to hold values. So, in this case, the secondary list might have 1 record (easy to match in SPD) with 3 columns (one for each member of the WF). You check for the lowest # in that record and apply the appropriate AssignedTo then increment the number. </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4207 Fri, 13 Feb 2009 10:18:15 +0000 jaxkookie 4207@http://www.endusersharepoint.com/STP/ <p>@baldcat - Yes very similar to a state machine.<br /> @AutoSponge - Could you give a little more detail to your statement or a resource I can go through. This sounds like I can make that happen. </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4198 Thu, 12 Feb 2009 23:47:24 +0000 AutoSponge 4198@http://www.endusersharepoint.com/STP/ <p>can you write your counts out to a secondary list by userid? </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4196 Thu, 12 Feb 2009 23:17:53 +0000 baldcat 4196@http://www.endusersharepoint.com/STP/ <p>sort of like a state machine you mean ?? </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4194 Thu, 12 Feb 2009 22:54:16 +0000 jaxkookie 4194@http://www.endusersharepoint.com/STP/ <p>Thanks, this is packed with great information, but not quite what I am looking for. I want to assign an item in some type of order so each user eventually is assigned the same number of items. This went into a way to assing an item base on a condition or product. I have one type of intake. I am looking into a way to do a count and try assigning the item base on the count. Any input? </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4020 Fri, 06 Feb 2009 16:55:36 +0000 laura67 4020@http://www.endusersharepoint.com/STP/ <p>Yes, something similar is outlined in this demo series:</p> <p><a href="http://office.microsoft.com/en-us/sharepointdesigner/HA102564171033.aspx" rel="nofollow">http://office.microsoft.com/en-us/sharepointdesigner/HA102564171033.aspx</a></p> <p>I learned everything I know about web parts on that site.</p> <p>Laura Rogers<br /> <a href="http://spinsiders.com/laurar" rel="nofollow">http://spinsiders.com/laurar</a> </p> http://www.endusersharepoint.com/STP/topic/workflow-assignto#post-4017 Fri, 06 Feb 2009 16:34:30 +0000 jaxkookie 4017@http://www.endusersharepoint.com/STP/ <p>using SPD, is there a way to dynamically assign an item. I know you had a post here that described dynamically using emails. What I have are 3 users. as an item is received currently the wf sends a message to all three. Is there a way to send the items to only one user, next item to the next user and again, then start from user 1...? Can we create a variable that counts each time a wf instance is triggered and use that number to send the wf to a different user? </p>