In this blog I provide tips on SharePoint customization for end users - people who only have access to SharePoint sites through their browser or occasionally through SharePoint Designer.
About me
I am a virtual worker, travelling between the US, China and Europe. I have been involved in SharePoint deployments since 2004. Feel free to contact me by e-mail at Christophe@PathToSharePoint.com.
15 comments
Comments feed for this article
October 23, 2008 at 4:48 pm
Richard Clay
I really like your “The Html Calculated Column” tips, and I wondered how to do something a bit more extreme.
I have a web page that contains a large table with 19 columns and a few dozen rows. It is filled with links and created via JavaScript. My problem is that if one of my colleagues needs to add a new row, they need to know how to get access to the host, and then either use CVS to track changes or risk stomping on each others changes.
What I want is to have a SharePoint list that contains the information needed to calculate the table, so that adding a new row is just adding a new item to the list. Then, I would want a view with a CEWP with the JavaScript to read the data from the list, and replace the view with the table.
More, since my table is a bunch of quick links to the hundreds of environment deployment pages we need to manage, it defeats the purpose of the table to have any page real estate wasted on normal SharePoint navigation. So, I want the JavaScript to “display=none” all of the SharePoint content on the page except for the top navigation line, and I want to move the view selector into the top line – so that users can still switch to the normal list view and add/edit rows.
Any suggestions? Feel free to say “you are nuts”
November 13, 2008 at 8:57 pm
Jeremy
Hello,
I am working on something alittle more advanced I was wondering if you had any ideas.
I am currently using the “Room and Equipment Reservation Template” from Microsoft.
I have added more columns to fit my need such as name and such.
Currently when you open a new reservation, we can choose a start date and end date to reserve a resource which creates one reservation.
Is there any way that we can creat multiple reservations from the same reservation?
Maybe we add a field for 2nd Reservation? That would make it so Scheduling of resources is not redundant.
OR maybe could I add checkbox for “another reservation”, and if that is checked then it will automatically open a new reservation with name and stuff filled in all we would have to do is set the sate and time.
Sornry for the long post.
Thanks for any responce!
November 14, 2008 at 1:29 am
Christophe
Sorry Jeremy, I don’t know much about the Microsoft templates.
You may be able to add a field for a second reservation, but then why not a third, etc. It’s difficult to know where to stop.
I think starting a new reservation through a workflow is a better idea. But is it worth the effort?
November 14, 2008 at 5:56 pm
Jeremy
Thanks!
January 6, 2009 at 8:00 pm
Live Case Study: SharePoint Blogs by Technorati Authority | End User SharePoint
[...] Christophe at Path to SharePoint is at it again. This time, he has configured a list to show the Technorati rankings for most of the SharePoint blogs in existance. There is a nice radio button filter on the left side of the page to do a quick search by ranking. [...]
March 10, 2009 at 2:31 pm
Benjamin
Christophe:
This is a GREAT site.
April 3, 2009 at 11:55 am
Rachael
I am trying to add a JS tool tip to a customer webpart, so that when someone hovers over a document title or list title a description of the document appears. Have you got any idea how I could go about designing this?
Thanks.
April 3, 2009 at 1:01 pm
Christophe
Rachael: I’d recommend that you start with Peter Allen’s site, as he has several posts on this topic, including live demos:
http://www.bitsofsharepoint.com
EndUserSharePoint.com would also be a good resource, and I think Peter reused some of their scripts.
April 14, 2009 at 3:55 pm
Sam
Hi Christophe,
Is there any possibility or workarounds available to make certain columns read only in a Custom List?. I’am basically thinking about a solution to control colum editing for certain users/groups without using SPD. Can this be done through jQuery?—i dont know..:).
Your thoughts please..
Thanks & Regards,
Sam
April 15, 2009 at 12:46 am
Christophe
Sam, this can be done with plain JavaScript in an edit form. However, your users will always have other options to update the column (datasheet view, Web Services).
April 15, 2009 at 2:13 am
Sam
Christophe, WoW, that is a great news. Truly appreciate if you can share some reference links or scripts with instructions which you always do to try the same..
April 15, 2009 at 3:16 am
Christophe
This article is a good start to understand the difference between “disabled” and “readonly”:
http://www.htmlcodetutorial.com/forms/_INPUT_DISABLED.html
Then search the Web for scripts that use the “disabled” attribute.
April 16, 2009 at 9:24 am
Sam
Thank you so much Christophe. Let me search for more on the subject and share here for all our folks.
Cheerz,
Sam
July 20, 2009 at 6:18 pm
Hari
Hi Christophe,
I am trying to export color coded list to excel. The standard export doesn’t export the color code along with the list. Is there any way to do it?
Thanks for your help,
Hari
July 27, 2009 at 8:22 am
cj
Hello,
I am trying to figure out how to handle a calculation for a KPI that needs to display server uptime by month as a percentage.
Currently have Excel worksheet with one row for each day. One column is “total outage minutes”. This is manually entered from one or more server downtime events. Another column calculates the uptime percentage: if there was a 2 minute outage then it gives a result of 99.86% for that day (1438 minutes up out of 1440 minutes in a day). It also has a calculated cell that gives the total average for all days in the month. Also, if there were separate outages, someone manually adds the two and enters them into the cell for that day.
This system is being replaced with a sharepoint list, so there could be days with one or more events (rows) that contain outage information – submitted by individuals who may not know about other outages for that day. There will also be days with no outage information (no list items created).
Having a hard time understanding how to calculate the average monthly uptime, because my KPI average only runs against the data (rows) that exist in the list, it doesn’t account for the rest of the days during the month when no downtime events occur. In Excel, this was just a row where “0″ was manually entered for that date. The goal is to have this information fully automated, not using Excel, and, not have a person manually enter a row of data for each day that did not have an outage. (And the outage events are actually populated by workflows running off of forms that have the outage minutes tallied by separate departments.)
The averaging problem: if in a given month there are three downtime events (for simplicity, say they are 2 minutes each) , the KPI averages 99.86%: (99.86 * 3) /3 but over a 30 day period (where 27 days had 100% uptime) the average should be 99.986. The number must be accurate to the ten-thousandths decimal point. Also, not all months have 30 days, so how is that handled?
The best I have been able to come up with is to sum the _outage_ minutes for the month and set a KPI target of 22 minutes (there are 43200 minutes in a 30-day month, and the goal is 99.95% uptime. 99.95% of 43200 is 43178 minutes.) This solution doesn’t present the data required by the execs, and it doesn’t dynamically adjust for 28,29, or 31 day months.
We have basic-intermediate SharePoint Designer expertise. I was also wondering if this can be handled by Performance Point/Dashboard Designer, which I have heard will be released free with SharePoint SP3.
Any suggestions are greatly appreciated.