Update [01/03/2009]: I have corrected an error in the script I initially published.
Three months ago, I published a script to display a random picture on your SharePoint site.
To answer Chris’ question, here is a variation to display a random quote. The method is the same as for the random picture, except that in this case I am using a SharePoint custom list to host the quotes. For my sample script, the quote is entered in the default Title column (SharePoint calls it “ows_LinkTitle”).
Note that the script and the list don’t need to be on the same site, they just need to be on the same server.
Hi, thanks for your really usefull scripts! I have your imagerotator working nice and smoth, but this one shows nothing, think the problem is the function for DisplayQuote. Any tip?
DrWat, send me more details by e-mail:
Did you use a custom list?
To answer questions I received by e-mail: this can be applied to other list types and to fields other than the title. I’ll publish another example using an announcement list (as this is typically the kind of content you may want to share across sites).
Thanks for the code but I am having a problem, it shows nothing. I have the site URL, list GUID, and the LinkTitle all filled out with information. Any ideas what the problem could be?
Update: there was an error in the last line of the script and I have corrected it.
My apologies to DrWat, Michael and those who have tried to use the code.
You would think that using
var SelectedQuote = ListItems[SelectedItem].getAttribute(“ows_Body”);
Would display the body of an announcements list, but it returns “null” for me. Any ideas?
Interestingly, I had the same issue. A tip from Larry about using different names for the fields led me to the idea that my FieldInternalName and FieldName were the same and for the purposes of this script, shouldn’t be. To solve that, I renamed the field from “Body” to “body”…. and that seemed to do the trick. I now had two (similar) names for the field.
I want to piggy back on Walter’s comment. I have been trying to figure out what the other ows attributes are for other fields. Is there a list or resource that identifies how or where to find these names?
With a little trial and error, I found that I was able to write it by using ows_ + “FieldInternalName”. Hope this helps.
So for my Announcements list I would use?
View the source of the NewForm.aspx, find the field in the page and look up the FieldInternalName. I have found that with Multiline fields the FieldName works.
This is what I have tested.
if FieldType=”SPFieldNote” then use ows_+”FieldName”
if FieldType=”SPFieldText” then use osw+”FieldInternalName”, this is not true for all. I created a second field and the name FieldInternalName is quote0, it returns null.
I am not sure why, but still looking. also looking what is use for calculated fields
Finding the ows attribute names is very easy.
Simply use the URL protocol in your browser:
You’ll get your list in XML format with the attribute names.
The script works on FireFox – new item returned with every screen refresh – however, on IE 7 the webpart goes blank on refresh. Should it work on IE?
Unless otherwise stated, all the scripts I propose are for both IE and Firefox.
On refresh, IE simply re-runs the script and you should get another random value. It is working for me…
Question-if you wanted to change the font for the quote, would you do that in this script, or in the list you’ve created for the quotes? The script works great, but the quote is very small (about a size 8). Thanks for publishing this! It’s awesome.
Apply the formatting to the QuotePlaceholder element. For example:
how is it possible to make the random-displayed text change in a hyperlink to the displayed item?
so that you can click on the link a land on the dispform.aspx…
Is it possible (I’m thiking it is 😉 to get more columns from the custom list and concatenate them to be one text?
Say, the list has 2 columns Name and Message and the contents are Name: “Andrey”; Message: “Hi, Christophe.” So, I need the webpart to show: “Hi, Christophe. [new line] Andrey”
Great site by the way!
Absolutely. You have two ways to do this:
– either use a calculated column that concatenates the two columns
– or do the concatenation in the script
Thanks! I figured out how to concat in script. Works great!
How about taking this thing further and having it switch a quote (i my case – message) periodically? Time to upgrade this thing!
Andrey, I have this on the image rotator:
In your case, just use it…without the image!
This site is amazing, thank you for all!
I am not a coder neither good in scripts. What I would like to do is to display a kind of random “Did you know…?”. What I miss so far is to display an hyperlink to the random word and have this a bit fancier. I have seen that Christophe gave the tips, but I am not able to figure out concretly how to do it in the script. Could you help me?
How I can return two values from list?
getAttribute(“ows_LinkTitle”); is there any way to use + or something to return second value?
Sebastien and freeal: if you want to look into the code, I’d suggest that you use the latest version of my image rotator:
In the latest version, you can pull both text and link from the list.
Thanks for this great code, I got it working just fine.
Just one quick question? Is it hard to change the random logic to a today’s date logic?
Just to enhance on the CSS for the CEWP.
I’m no coder, so I’m trying to add the
to the code but have no idea where to place it. I’m actually trying to make my list of 500 quotes in Italics and if it can be done, quotation marks at the beginning and end of each quote.
Are you able to provide the exact code and which line I’m to put this in?
“Research is what I’m doing when I don’t know what I’m doing. Wernher von Braun”
Brett: Simply replace the very first line in Christophe’s code with this:
This will make the font size 12px and font style italics. For the quotes at the beginning and end, I’m sure the code could be modified to concatenate these in there, but why not just add them into the quotes from your list?
Hope this helps.
Argghh….it seems I can’t post html here without it being stripped out. I’ll post to my twitter account under @planetparker.
Christophe: How can I post html to your blog? Newbie here 🙂
Are you able to modify the code to function on SP2010? Currently migrating web parts from 2007 and I’m getting a XML error.
So simple and so elegant. Thanks, worked a treat!