http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Wed, 01 Apr 2009 21:33:09 +0000 http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5591 Wed, 01 Apr 2009 12:00:34 +0000 NancyCentury 5591@http://www.endusersharepoint.com/STP/ <p>Now, naturally I left one thing out. </p> <p>Can I add to the dynamic string to ensure the user lands back on a specific site page (like when you append the ?Source=http://.... to force user to a target URL)?</p> <p>I tried placing ?Source=my target URL between [%ListName:ID%] and the comma, Link words but that did not work. I hope I am not asking for too much. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5589 Wed, 01 Apr 2009 11:50:17 +0000 NancyCentury 5589@http://www.endusersharepoint.com/STP/ <p>.... and, of course, it works PERFECTLY. Thank you!!! </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5587 Wed, 01 Apr 2009 11:24:40 +0000 NancyCentury 5587@http://www.endusersharepoint.com/STP/ <p>Ok- I didn't know that the regular hyperlink field would format as text if you laid it out that way. Duh. I will try it again. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5576 Wed, 01 Apr 2009 09:25:21 +0000 laura67 5576@http://www.endusersharepoint.com/STP/ <p>Again, I'd just use a regular hyperlink field.<br /> Sinc we put a comma, space, and the text that needs to display after the hyperlink, when we created the dynamic string, that's how sharepoint knows that the part after the comma is the part that needs to be displayed.</p> <p>/[%ListName:Path%]/EditForm.aspx?ID=[%ListName:ID%], Link Words</p> <p>See, it is two parts, the part before the comma, and the part after. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5555 Tue, 31 Mar 2009 18:32:58 +0000 NancyCentury 5555@http://www.endusersharepoint.com/STP/ <p>I still must be missing something. </p> <p>I am fairly positive I created my dynamic string and variable correctly. I set it to manual initiation, and when I go to one of my list items to run the WF I get an error page with the message "Value does not fall within the expected range."</p> <p>I still am not sure if, since by target field is a <em>"hyperlink with formatting contraints for publishing"</em> type field, this is why it's not working.</p> <p>How does the WF "know" that this particular field type needs both an URL and a Display Value to be complete? </p> <p>When I tell it to "Set field in item..." it's only providing one value for what is essentially a 2-part field. ???</p> <p>(Or, of course, I could just be doing it wrong. :-) </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5546 Tue, 31 Mar 2009 15:13:59 +0000 laura67 5546@http://www.endusersharepoint.com/STP/ <p>Once you're in the String Builder for the Build Dynamic String action, click the "Add Lookup button. This will let you put any of your list's fields in there. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5544 Tue, 31 Mar 2009 15:00:19 +0000 NancyCentury 5544@http://www.endusersharepoint.com/STP/ <p>[Feeling stupid]<br /> I do not know how to obtain the Path field or the ID field. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5543 Tue, 31 Mar 2009 14:43:31 +0000 laura67 5543@http://www.endusersharepoint.com/STP/ <p>When you "build dynamic string" as your action in the workflow:<br /> Type a backslash, then insert the Path field, then type another backslash, then type EditForm.aspx?ID=<br /> Then, insert the ID field. </p> <p>So, it'll look like this, with the name of your list showing as the ListName:<br /> /[%ListName:Path%]/EditForm.aspx?ID=[%ListName:ID%], Link Words</p> <p>See, I then added the comma and "Link words" at the end.</p> <p>Then,<br /> "Set field in current item"<br /> For the field, choose your new hyperlink field<br /> For the source, choose "workflow data", and then pick the name of the variable you just created when you built the dynamic string. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5537 Tue, 31 Mar 2009 11:41:15 +0000 NancyCentury 5537@http://www.endusersharepoint.com/STP/ <p>Actually my way did NOT work. It takes you to the custom edit page BUT it's not connecting to the specific list item. </p> <p>I still need your way- the "list name path" and the "list name ID" parts, to be specific. I think that is what is critical to ensuring that when a user clicks the link from within a specific list item, the values they change are being applied to that list item (wich is not happening now).</p> <p>But where I failed before was I do not know how to get those 2 things. Are they choices in the workflow designer? </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5536 Tue, 31 Mar 2009 09:45:40 +0000 laura67 5536@http://www.endusersharepoint.com/STP/ <p>Cool. Yes, I would have recommended just a hyperlink field to put the data in.<br /> Also, the part I forgot is what you want the link to SAY when they click on it. For that, you put<br /> [%ListName:Path%]/EditForm.aspx?ID=[%ListName:ID%], Link Words</p> <p>See, I just added a comma and a space, and some text. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5525 Mon, 30 Mar 2009 19:30:38 +0000 NancyCentury 5525@http://www.endusersharepoint.com/STP/ <p>I could not make this work as you described. </p> <p>BUT- here is how I made it work after all! I manually added the formatted hyperlink (URL of my custom edit form, and the display text: 'edit status'). </p> <p>Then I went into datasheet view and copied what was in that field, then pasted THAT into the dynamic string builder in SPD. Then I called that variable up in my workflow and it worked like a charm. Thanks thoguh- I don't know that I ever would have gotten there on my own! </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5522 Mon, 30 Mar 2009 18:58:44 +0000 NancyCentury 5522@http://www.endusersharepoint.com/STP/ <p>One more question first though- what type of field should I create in my list to receive the variable value (the URL)? </p> <p>Will the "hyperlink with formatting constraints for publishing" work? I thought that field type required 2 parts- the URL and another text value for the display link. will this work with that field type? </p> <p>If not, I am afraid I'll get a long URL in my list and I don't want that. I'd prefer a hyperlink called "edit status" that took them to the custom edit page. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5521 Mon, 30 Mar 2009 18:19:48 +0000 NancyCentury 5521@http://www.endusersharepoint.com/STP/ <p>Nice!! I will give it a try and let you know. </p> http://www.endusersharepoint.com/STP/topic/can-a-hyperlink-list-column-be-a-default-value#post-5520 Mon, 30 Mar 2009 16:51:11 +0000 laura67 5520@http://www.endusersharepoint.com/STP/ <p>In your workflow, create a variable with the following value:<br /> "Build Dynamic String" as the action...<br /> [%ListName:Path%]/EditForm.aspx?ID=[%ListName:ID%]<br /> Then, just insert that variable as the value of the hyperlink.<br /> "Set field in current item"<br /> For the source, choose "workflow data", and then pick the name of the variable you just created.</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/can-a-hyperlink-list-column-be-a-default-value#post-5446 Fri, 27 Mar 2009 11:25:22 +0000 NancyCentury 5446@http://www.endusersharepoint.com/STP/ <p>A manager wants to track time it takes handlersto complete a series of monthly process steps. The goal is to track Step Duration and view associated KPIs based on target step duration times. </p> <p>I will lay out the scenario and ID then my specific problem.</p> <p>I have a list of Process Steps (parent content type is Issues list). The same set of steps repeat every month but the handlers may be different. A manager assigns each step to a handler at the start of the month. (The manager has specified that is all he wants to do/can do in terms of data entry.)</p> <p>Hidden columns include "Start time" and "End time" whose values will derive from other workflows (described below). Each list item also contains a Status column (default at creation = Not Started) and a calculated "Step Duration" column that gets its value from (end time)-(start time). </p> <p>WF 1) On item creation, handler recieves email alert that step has been assigned to them. A link in the alert email takes them directly to a Custom Edit Page for that item showing only Step Title and Status drop-down. When handler is ready to begin the step, he clicks the link and changes the status to "In Progress." </p> <p>WF 2) When the handler changes the status from the default "Not Started" to "In Progress," value of "start time" field is set to equal "modified." This 'starts the clock" on the step completion timeframe. </p> <p>WF 3) When the handler is done - he must change the status from "In Progress" to "Completed." The value of "end time"is set to equal "modified." This "stops the clock" and logs his Step Duration in the hidden calculated column.</p> <p>My problem is this: How do I get the handler <em>back</em> to my custom edit form when he is ready to change the status to "Completed?" </p> <p>The first time, he got an email containing the direct link. I can't count on him saving that email, so I need to make it possible for him to get to the Custom Edit Form some other way on his own. I DO NOT want the handlers to be able to get to the regular Edit View where they could potentially mess with the other values. </p> <p>I wanted to put a column in the list called "Update status," which would be a hyperlink to my custom edit page, then provide a list view that shows that column to the handlers. </p> <p>However, I can't figure out how to make that column default to my custom edit page URL. I do not want my manager to have to manually add that URL to every list item on creation. Is a hyperlink allowed to be a default value? </p> <p>How else could I make the custom edit page available easily and quickly to my handlers? They must be able to get there fast once they've completed the step becasue the clock is ticking and they need to be able to log their completion time ASAP.</p> <p>Thanks for all ideas! </p>