Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 882
  • Last Modified:

'Color' field in Lists - Sharepoint

Hello,

I am trying to figure out how to add a colored field in a list for Sharepoint. What I mean for this is based on a certain status for a project, I want the field to be filled with a color, like Green for On Schedule, Yellow for Behind, and Red for Immediate Attention.

So, for example:
Project #1 - Location Philly - Status: [GREEN]
Project #2 - Location NY - Status: [RED]

Hopefully this is clear enough.

Thanks for your help everyone.
0
ITimaging
Asked:
ITimaging
  • 5
  • 5
  • 2
  • +1
1 Solution
 
KoenVostersCommented:
You can use jQuery to achieve this:
http://www.codegain.com/codesnippets/sharepoint/developmentprogramming/how-to-apply-color-coding-sharepoint-list-using-jquery.aspx

Add this code in a content editor webpart

If you don't know how to put jQuery on your SharePoint site:
http://weblogs.asp.net/jan/archive/2008/11/20/sharepoint-2007-and-jquery-1.aspx
0
 
TEEDACommented:
If you have access to SharePoint Designer, you can also do this using conditional formatting. If you need a "how to", let me know.
0
 
zabiullahCommented:
In addition to the above references, you can also use calculated column with javascript/JQuery to achieve the same.

Here the references:

http://www.sharepointkings.com/2009/04/sharepoint-calculated-column-and-jquery.html
http://sharepointkb.wordpress.com/2009/04/14/customize-look-and-feel-with-calculated-columns/

Regards,
Zabi
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
ITimagingAuthor Commented:
I don't really have access to the server to be able to deploy JQuery to the server, unfortunately, otherwise I'd use it. I do have Sharepoint Designer 2010 for it, though. TEEDA, do you happen to still have a "how-to" for that, please?
0
 
KoenVostersCommented:
0
 
ITimagingAuthor Commented:
I'm having terrible luck with this thing. Okay, so I went through and got the formatting and everything set the one time, but after getting it setup it didn't actually do anything. It didn't change the background of anything in there. Now, I thought it was my mistake since it usually is so I thought I'd start over with it - didn't save the page and re-opened it so it was fresh. Now every time I actually try and open the data view, the list appears and then disappears. I can't click on any of the fields to actually apply a format.
0
 
TEEDACommented:
in your page, insert a web part zone if there isn't one there already and click Insert a dataview. Sort and filter as needed.  Select the chevron at the top right of the dataview and choose Conditional Formatting, which will open a task pane. Now select the table cell you want to color and click Create/Apply Formatting in the task pane. Create your condition and click OK. The Modify Style dialog appears, allowing you to set background color, fonts and so on. Good luck.
0
 
TEEDACommented:
is it possible that you chose Hide Content instead of Apply Formatting? I've done that once or twice.
0
 
ITimagingAuthor Commented:
Sorry, but I did try that TEEDA, as explained in Koen's link. Unfortunately it doesn't actually change the color. It does nothing to be precise.
0
 
ITimagingAuthor Commented:
I did check to see if I did, and I didn't. I made sure I made everything visible.
0
 
TEEDACommented:
If there are existing entries in your list that meet the conditions, then I'm mystified as to why the formatting isn't being applied.  But just in case, click the Set Visibility button in the task pane and click All Formatting Visible.
0
 
ITimagingAuthor Commented:
I'm baffled myself. I don't know why it's not filling it the proper colors, and I set it up so the condition is correct. I did set it for All Formatting Visible too. It's odd.
0
 
TEEDACommented:
It sure is.  Data views can be finicky, so I'd start a brand new page and make sure your web part is within a web part zone and that it's the only web part on the page.  Good luck!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 5
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now