Stump the Panel: Forum: jQuery for Everyone - Recent Posts

27palms on "Dressing up hyperlinks"

27palms — Tue, 21 Apr 2009 04:51:12 +0000

Laura, may a thousand blessings descend upon you!! Thanks :)

laura67 on "Dressing up hyperlinks"

laura67 — Mon, 20 Apr 2009 23:48:48 +0000

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.

So, you build a dynamic string that has

[server relative url], View Item

Laura Rogers
http://spinsiders.com/laurar

AutoSponge on "Dressing up hyperlinks"

AutoSponge — Mon, 20 Apr 2009 20:35:16 +0000

It's stored like this:
<z:row ows_URLwMenu="http://server.com/requests.php?id=54, Report"/>

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.

AutoSponge on "Preview pane causing pain"

AutoSponge — Mon, 20 Apr 2009 20:31:01 +0000

Dave T,

To test for jQuery in IE, use the jQueryify Bookmarklet. I blogged that here:
http://www.endusersharepoint.com/?p=1235

Or, if I've converted you to Firefox/firebug, open the Firebug console and type $("body")

If it returns something, jQuery is working.

I have a new version of the Preview Pane with better performance, you may want to check it out here:
http://www.endusersharepoint.com/?p=1514

AutoSponge on "Quick launch accordion"

AutoSponge — Mon, 20 Apr 2009 20:28:36 +0000

I had other ideas to store session or profile data, but they were more complicated solutions that required a separate list.

If you have an idea I'll be happy to help guide you.

Trihimbulus on "Quick launch accordion"

Trihimbulus — Mon, 20 Apr 2009 14:13:16 +0000

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.

Dave T on "Preview pane causing pain"

Dave T — Mon, 20 Apr 2009 09:21:52 +0000

Paul,
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?

Thanks!
Dave

27palms on "Dressing up hyperlinks"

27palms — Mon, 20 Apr 2009 09:16:41 +0000

Paul, I think I may be barking up the wrong tree and using attempting to use jQuery to address my knowledge gap, who knows...

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.

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.

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.

To cust a long story short....when my list is rendered on the screen I simply want it to say:

"View Item" rather than "/Lists/History/AllItems.aspx?&FilterField1=CID&FilterValue1=17"

AutoSponge on "List Settings Choice Column"

AutoSponge — Sun, 19 Apr 2009 17:18:05 +0000

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.

I've written before about placing custom validation in a OOB form without SPD.

Do you have any experience using JavaScript for building solutions yet?

AutoSponge on "Quick launch accordion"

AutoSponge — Sun, 19 Apr 2009 17:14:30 +0000

The way the cookies (should) work is, if the link in the header points to the same place, the child list will be open.

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.

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:

$("a[href='/Site/_layouts/viewlsts.aspx?ShowSites=1']").parent().click()
$("table.ms-navheader:last td").click()
$("a[text='Sites'], a[innerText='Sites']").parent().click();

AutoSponge on "Ranking Items in a List"

AutoSponge — Sun, 19 Apr 2009 16:51:42 +0000

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.

Item 1 = 1.0
Item 2 = 2.0

If you want to add something between 1 and 2, give it order number (2.0+1.0)/2.

This can probably be done with workflow.

AutoSponge on "Preview pane causing pain"

AutoSponge — Sun, 19 Apr 2009 16:47:45 +0000

Dave,

Which version of the code are you using? Did you test to see if jQuery is on the page?

laura67 on "List Settings Choice Column"

laura67 — Sat, 18 Apr 2009 15:30:17 +0000

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.

Laura Rogers
http://spinsiders.com/laurar

ihmunro on "List Settings Choice Column"

ihmunro — Sat, 18 Apr 2009 12:09:31 +0000

Morning

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.

Iain

EndUserSharePoint on "List Settings Choice Column"

EndUserSharePoint — Fri, 17 Apr 2009 22:07:30 +0000

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

Dave T on "Preview pane causing pain"

Dave T — Fri, 17 Apr 2009 16:42:36 +0000

Eric,
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.

Paul's solution works with any list, library or calendar. Well, except for mine...;-)

Thanks sharing that link. I will let my user community know about it.

Dave

Eric Truchon on "Preview pane causing pain"

Eric Truchon — Fri, 17 Apr 2009 15:54:46 +0000

Hi,

Here is an interesting link for preview pane : http://blogs.msdn.com/sharepoint/archive/2007/03/29/tip-using-the-preview-pane-to-view-items-in-a-large-list.aspx

Eric

Dave T on "Preview pane causing pain"

Dave T — Fri, 17 Apr 2009 14:27:48 +0000

Paul,
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?

Thanks!!
Dave

kirgisk on "List Settings Choice Column"

kirgisk — Fri, 17 Apr 2009 12:02:36 +0000

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.

eric on "Ranking Items in a List"

eric — Fri, 17 Apr 2009 11:05:47 +0000

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.

FranKaWaKiaK on "Ranking Items in a List"

FranKaWaKiaK — Thu, 16 Apr 2009 18:06:47 +0000

Here is what I am trying to do with a SharePoint list:

I am using out of the box SharePoint 2007, no SharePoint developer available..

I have a column called 'priority' which is currently a choice column (1-50)

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.

Any tips or suggestions would be beneficial, thank you!

Trihimbulus on "Quick launch accordion"

Trihimbulus — Thu, 16 Apr 2009 15:44:15 +0000

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:

<SubSite1>
- Page1
- Page2
- Page3
<SubSite2>
-Page1
-Page2
-Page3

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???

AutoSponge on "Changing time frame on gantt chart..."

AutoSponge — Wed, 15 Apr 2009 18:38:23 +0000

Not OOB, of course.

You could try to manipulate the data as loaded into the Gantt web part or try one of the following:

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).
2. Build a DVWP to pull the data and render it with some spans that can then be manipulated with simple JavaScript.
3. Export the data to Excel or MS-Project where you can develop the solution outside of SP.
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.

AutoSponge on "When mouse over field in form, how change text displayed"

AutoSponge — Wed, 15 Apr 2009 18:32:26 +0000

Ruanape,

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:

$("td.ms-formbody:visible").each(function(i,e){
    var t = $(e).text().replace(/\s+/g," ");
    console.log(t);
});

Then you have to pick or develop a tip style. There are several tooltip plugins and scripts to poll for examples.

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.

If jQuery fails to load, the descriptions will remain in the default location.

Bellivo on "Changing time frame on gantt chart..."

Bellivo — Wed, 15 Apr 2009 15:00:43 +0000

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..?