http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Tue, 21 Apr 2009 12:15:40 +0000 http://www.endusersharepoint.com/STP/topic/dressing-up-hyperlinks#post-6026 Tue, 21 Apr 2009 04:51:12 +0000 27palms 6026@http://www.endusersharepoint.com/STP/ <p>Laura, may a thousand blessings descend upon you!! Thanks :) </p> http://www.endusersharepoint.com/STP/topic/dressing-up-hyperlinks#post-6024 Mon, 20 Apr 2009 23:48:48 +0000 laura67 6024@http://www.endusersharepoint.com/STP/ <p>In the workflow, when you want to write data to a hyperlink field, you need to use a comma to seperate the url part and then the "View Item" part.</p> <p>So, you build a dynamic string that has </p> <p>[server relative url], View Item</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/dressing-up-hyperlinks#post-6018 Mon, 20 Apr 2009 20:35:16 +0000 AutoSponge 6018@http://www.endusersharepoint.com/STP/ <p>It's stored like this:<br /> <code>&lt;z:row ows_URLwMenu=&quot;http://server.com/requests.php?id=54, Report&quot;/&gt;</code></p> <p>So, I'm guessing you could use the comma to separate the values... but I've never tried it myself. I'm interested if it works though. </p> http://www.endusersharepoint.com/STP/topic/preview-pane-causing-pain#post-6017 Mon, 20 Apr 2009 20:31:01 +0000 AutoSponge 6017@http://www.endusersharepoint.com/STP/ <p>Dave T,</p> <p>To test for jQuery in IE, use the jQueryify Bookmarklet. I blogged that here:<br /> <a href="http://www.endusersharepoint.com/?p=1235" rel="nofollow">http://www.endusersharepoint.com/?p=1235</a></p> <p>Or, if I've converted you to Firefox/firebug, open the Firebug console and type $("body")</p> <p>If it returns something, jQuery is working.</p> <p>I have a new version of the Preview Pane with better performance, you may want to check it out here:<br /> <a href="http://www.endusersharepoint.com/?p=1514" rel="nofollow">http://www.endusersharepoint.com/?p=1514</a> </p> http://www.endusersharepoint.com/STP/topic/quick-launch-accordion#post-6016 Mon, 20 Apr 2009 20:28:36 +0000 AutoSponge 6016@http://www.endusersharepoint.com/STP/ <p>I had other ideas to store session or profile data, but they were more complicated solutions that required a separate list.</p> <p>If you have an idea I'll be happy to help guide you. </p> http://www.endusersharepoint.com/STP/topic/quick-launch-accordion#post-6003 Mon, 20 Apr 2009 14:13:16 +0000 Trihimbulus 6003@http://www.endusersharepoint.com/STP/ <p>And of course it works just like you had said! Is there anyway to accomplish this without the use of cookies? If so, please show me how. </p> http://www.endusersharepoint.com/STP/topic/preview-pane-causing-pain#post-5994 Mon, 20 Apr 2009 09:21:52 +0000 Dave T 5994@http://www.endusersharepoint.com/STP/ <p>Paul,<br /> By 'version of code' I am going to assume you mean the scipt that you provide. The scipt is from the two Jan 19th blog posts. I don't know how to test is jQuery is on the page. Can you explain that?</p> <p>Thanks!<br /> Dave </p> http://www.endusersharepoint.com/STP/topic/dressing-up-hyperlinks#post-5993 Mon, 20 Apr 2009 09:16:41 +0000 27palms 5993@http://www.endusersharepoint.com/STP/ <p>Paul, I think I may be barking up the wrong tree and using attempting to use jQuery to address my knowledge gap, who knows...</p> <p>I have a workflow that runs when new items are added to a list. One step in the workflow builds a dynamic string that points back to a list item. The string built is a relative url that is then stored in hyperlink field within the list. </p> <p>Fields that are typed as hyperlink have two pieces of informaiton. The URL and the description. I'm writing into the URL but I really want the list to say "View Item" as its description. </p> <p>I'm able to do that when editing myself but I don't see how you write something to the description field when you are creating a record through a workflow. </p> <p>To cust a long story short....when my list is rendered on the screen I simply want it to say:</p> <p>"View Item" rather than "/Lists/History/AllItems.aspx?&#38;FilterField1=CID&#38;FilterValue1=17" </p> http://www.endusersharepoint.com/STP/topic/list-settings-choice-column#post-5981 Sun, 19 Apr 2009 17:18:05 +0000 AutoSponge 5981@http://www.endusersharepoint.com/STP/ <p>I'm publishing an article Tues. which has JavaScript methods for calling the owssvr.dll and returning a set of values (based on a column name). For instance, you could fetch a list of start times from the service and compare that to a field value in a validation routine.</p> <p>I've written before about placing custom validation in a OOB form without SPD.</p> <p>Do you have any experience using JavaScript for building solutions yet? </p> http://www.endusersharepoint.com/STP/topic/quick-launch-accordion#post-5980 Sun, 19 Apr 2009 17:14:30 +0000 AutoSponge 5980@http://www.endusersharepoint.com/STP/ <p>The way the cookies (should) work is, if the link in the header points to the same place, the child list will be open.</p> <p>If you navigate to a list that you always want open (and for example the list does not exist elsewhere to create the correct cookie entry), you can add a CEWP to that page and fire the click event for that section.</p> <p>Since you already have jQuery on the page, just add a line between some script tags, here are a few examples of ways you can find that td element:</p> <p><code>$(&quot;a[href=&#39;/Site/_layouts/viewlsts.aspx?ShowSites=1&#39;]&quot;).parent().click()</code><br /> <code>$(&quot;table.ms-navheader:last td&quot;).click()</code><br /> <code>$(&quot;a[text=&#39;Sites&#39;], a[innerText=&#39;Sites&#39;]&quot;).parent().click();</code> </p> http://www.endusersharepoint.com/STP/topic/ranking-items-in-a-list#post-5979 Sun, 19 Apr 2009 16:51:42 +0000 AutoSponge 5979@http://www.endusersharepoint.com/STP/ <p>Typically, the easiest way to change the order of a list without changing all elements in the list is to use a float number as an an order number.</p> <p>Item 1 = 1.0<br /> Item 2 = 2.0</p> <p>If you want to add something between 1 and 2, give it order number (2.0+1.0)/2.</p> <p>This can probably be done with workflow. </p> http://www.endusersharepoint.com/STP/topic/preview-pane-causing-pain#post-5978 Sun, 19 Apr 2009 16:47:45 +0000 AutoSponge 5978@http://www.endusersharepoint.com/STP/ <p>Dave,</p> <p>Which version of the code are you using? Did you test to see if jQuery is on the page? </p> http://www.endusersharepoint.com/STP/topic/list-settings-choice-column#post-5976 Sat, 18 Apr 2009 15:30:17 +0000 laura67 5976@http://www.endusersharepoint.com/STP/ <p>I think it would be easy to do that in infopath, but less easy in a sharepoint list. The Fab 40 template called "employee training" has s similar concept.</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/list-settings-choice-column#post-5969 Sat, 18 Apr 2009 12:09:31 +0000 ihmunro 5969@http://www.endusersharepoint.com/STP/ <p>Morning</p> <p>It would be nice to do that but until you get a fix, what about combining it with a live preview pane - at least you would see what appointment times had already been taken.</p> <p>Iain </p> http://www.endusersharepoint.com/STP/topic/list-settings-choice-column#post-5964 Fri, 17 Apr 2009 22:07:30 +0000 EndUserSharePoint 5964@http://www.endusersharepoint.com/STP/ <p>Kathy - Interesting one. There is no date field, so are you creating a new list for every day there are appointments? Let's here the case study scenario of what you are trying to do. -- Mark </p> http://www.endusersharepoint.com/STP/topic/preview-pane-causing-pain#post-5963 Fri, 17 Apr 2009 16:42:36 +0000 Dave T 5963@http://www.endusersharepoint.com/STP/ <p>Eric,<br /> Very interesting. I had not noticed preview pane in Style. Under some circumstances I think that will work well. Calendar does not offer the Style option. </p> <p>Paul's solution works with any list, library or calendar. Well, except for mine...;-)</p> <p>Thanks sharing that link. I will let my user community know about it.</p> <p>Dave </p> http://www.endusersharepoint.com/STP/topic/preview-pane-causing-pain#post-5961 Fri, 17 Apr 2009 15:54:46 +0000 Eric Truchon 5961@http://www.endusersharepoint.com/STP/ <p>Hi, </p> <p>Here is an interesting link for preview pane : <a href="http://blogs.msdn.com/sharepoint/archive/2007/03/29/tip-using-the-preview-pane-to-view-items-in-a-large-list.aspx" rel="nofollow">http://blogs.msdn.com/sharepoint/archive/2007/03/29/tip-using-the-preview-pane-to-view-items-in-a-large-list.aspx</a></p> <p>Eric </p> http://www.endusersharepoint.com/STP/topic/preview-pane-causing-pain#post-5954 Fri, 17 Apr 2009 14:27:48 +0000 Dave T 5954@http://www.endusersharepoint.com/STP/ <p>Paul,<br /> I have used many of your jquery solutions without a problem. But the preview pane is not working at all. I have tried both list and calendar. When I hover over an item, nothing happens. Any suggestions? </p> <p>Thanks!!<br /> Dave </p> http://www.endusersharepoint.com/STP/topic/list-settings-choice-column#post-5948 Fri, 17 Apr 2009 12:02:36 +0000 kirgisk 5948@http://www.endusersharepoint.com/STP/ <p>I have created a list to request appointment times. Data collected is name, email, phone number and Appointment time. The Appointment time are in 15 minutes intervals (e.g 1:00 - 1:15, 1:15 - 1:30) is there any way to prohibit a new entry from using on of the choices that have already been selected. </p> http://www.endusersharepoint.com/STP/topic/ranking-items-in-a-list#post-5944 Fri, 17 Apr 2009 11:05:47 +0000 eric 5944@http://www.endusersharepoint.com/STP/ <p>Someone posted about this recently but I cannot find the link. A solution was to use a Links List template and to use the Actions, Change Order menu item to automatically reorder the list items. </p> http://www.endusersharepoint.com/STP/topic/ranking-items-in-a-list#post-5939 Thu, 16 Apr 2009 18:06:47 +0000 FranKaWaKiaK 5939@http://www.endusersharepoint.com/STP/ <p>Here is what I am trying to do with a SharePoint list:</p> <p>I am using out of the box SharePoint 2007, no SharePoint developer available..</p> <p>I have a column called 'priority' which is currently a choice column (1-50)</p> <p>Is there a way to have it so when the user selects an item to be of priority '1' it will take the existing priority '1' item and bump it down to '2' and so on. If you've ever changed column ordering or the views it uses this same process.</p> <p>Any tips or suggestions would be beneficial, thank you! </p> http://www.endusersharepoint.com/STP/topic/quick-launch-accordion#post-5936 Thu, 16 Apr 2009 15:44:15 +0000 Trihimbulus 5936@http://www.endusersharepoint.com/STP/ <p>Great script! I am having one problem though. On my Sharepoint 2007 site, I have added the above code in the master page so it will apply globally to all sites and it is working great! I have nested navigation (quick launch menu), so for my top level site, I have sub-sites each with individual pages. When I click on the link to go to a subsite or new page, the list is collapsed. The nav looks like this:</p> <p>&lt;SubSite1&gt;<br /> - Page1<br /> - Page2<br /> - Page3<br /> &lt;SubSite2&gt;<br /> -Page1<br /> -Page2<br /> -Page3</p> <p>When I click on Subsite one, when it brings me to the page- the list defaults to closed. I need this to open the list for which I clicked, be it SubSite 1 or 2 and NOT expand everything. How do I accomplish this??? </p> http://www.endusersharepoint.com/STP/topic/changing-time-frame-on-gantt-chart#post-5912 Wed, 15 Apr 2009 18:38:23 +0000 AutoSponge 5912@http://www.endusersharepoint.com/STP/ <p>Not OOB, of course.</p> <p>You could try to manipulate the data as loaded into the Gantt web part or try one of the following:</p> <p>1. Get the data from owssvr.dll or a web service and render it using a 3rd-party tool/site (I've seen some other visualization tools for activities on the web that do a good job).<br /> 2. Build a DVWP to pull the data and render it with some spans that can then be manipulated with simple JavaScript.<br /> 3. Export the data to Excel or MS-Project where you can develop the solution outside of SP.<br /> 4. Get the data and render a spreadsheet in Excel Services. I did a simple Gantt in Excel like 10 years ago--it's not that hard if you know a few date functions. </p> http://www.endusersharepoint.com/STP/topic/when-mouse-over-field-in-form-how-change-text-displayed#post-5911 Wed, 15 Apr 2009 18:32:26 +0000 AutoSponge 5911@http://www.endusersharepoint.com/STP/ <p>Ruanape,</p> <p>First, we have to grab the text from the description field. Using jQuery, I do something like this to see what I'm working with:</p> <pre><code>$(&quot;td.ms-formbody:visible&quot;).each(function(i,e){ var t = $(e).text().replace(/\s+/g,&quot; &quot;); console.log(t); });</code></pre> <p>Then you have to pick or develop a tip style. There are several tooltip plugins and scripts to poll for examples.</p> <p>Then add the content you collected to the row and remove the content from the default location. Getting the data to look nice may take some practice.</p> <p>If jQuery fails to load, the descriptions will remain in the default location. </p> http://www.endusersharepoint.com/STP/topic/changing-time-frame-on-gantt-chart#post-5903 Wed, 15 Apr 2009 15:00:43 +0000 Bellivo 5903@http://www.endusersharepoint.com/STP/ <p>Currently, the time basis for the gantt chart is days and I have the need to schedule in hours. Is there a way to do this..? </p>