The arrangement of data for storage or display.

learn more… | top users | synonyms

9
votes
4answers
10k views

Color code item row based on column value in SharePoint Foundation 2013

I have a custom list which contains a field called Status. In the AllItems view, I would like to color code each line item based on the value of Status. Is this possible to do withing SharePoint ...
4
votes
2answers
14k views

How to add hide/show section toggle to InfoPath form?

MS Word 2013 has this great feature. You can define sections of a document with Headings. You make certain lines headings by highlighting the text and choosing the Heading 1 Style from the ribbon. ...
4
votes
3answers
5k views

Date Only format with BCS

I have created an External Content Type through SharePoint Designer. One of the fields that I'm getting from my database is a DateTime column. In SharePoint, however, I want to format this as a Date ...
3
votes
1answer
284 views

get_fieldValuesAsText usage example

I need to get items using JSOM and show them on a page in a display form. So currency field will be shown like $ 123,456.78 the date will be formatted accordingly to settings and Yes\No value will be ...
3
votes
1answer
3k views

How do I validate a selected “choice” field in a survey?

We've got SP2010 foundation, and the other limitation is that we do not have access to SPD or any of the programmatic ways of accomplishing this. I'm looking for information about how to set this up ...
2
votes
1answer
2k views

How to enable bullet styles in Sharepoint 2010?

Intro: I'm running a publishing service using Sharepoint 2010 and recently tried to copy and paste contents from Word 2010 into an article. Problem: After pasting the content, it did not retain the ...
2
votes
2answers
673 views

Is there a way to insert a <blockquote> in a Rich text column?

We have a List in our Sharepoint that we use for reporting quality assurance issues. One of the columns is a 'Description' column which is defined as a Rich text column, is there anyway to insert ...
2
votes
1answer
56 views

How do I get a placeholder of 0?

I want my InfoPath form to have numbers formatted like "010" instead of "10" to then sync with SharePoint. How can I get my form to show the zero placeholder instead of two digits?
2
votes
1answer
683 views

Remove HTML Tags when Copying and Pasting into SharePoint People Picker textbox

I'm trying to remove formatting and in this case, mailto anchor html tags from being copied when I paste into the people picker textbox/field in SharePoint 2010 and have no idea how to go about doing ...
2
votes
1answer
261 views

sharepoint list view conditional formatting

I'm trying to set a conditional formatting for my custom list data row, it works fine for background color but not for foreground color, when I inspect the element in chrome browser, I found it apply ...
2
votes
2answers
476 views

SharePoint Online “Page Elements” style for Format Text missing

We are currently experiencing a really weird bug where the "Page Elements" is missing under the Font Styles under Format Text. Here is a screenshot: The weird thing is, it was working fine ever ...
2
votes
1answer
42 views

Link to Edit button on page for item & conditionally format

In SharePoint Online (E3 subscription) I have 5 lists in a site and in each list the user is to enter 1 item. The end result is to enable the Create and Edit button conditionally on a page next to ...
2
votes
1answer
84 views

Format Date in Content Query

I have looked through too many threads about this and have made no progress. So far the following links have helped me the most: Content Query WebPart & Date How to format Date in Content ...
2
votes
1answer
43 views

SharePoint 2007 Web parts view size

Can the view of web parts be zoomed in or out? I have a named Excel Chart displayed in an Excel Web Access web part. The chart appears very large in the web part. Is there any way to adjust the ...
2
votes
0answers
139 views

InfoPath Designer 2010 - Format HTML tags

I have set up a web browser form for SP2007 in InfoPath Designer 2010. It points to a list that contains several columns of different types, to include some enhanced rich text multiline fields. The ...
2
votes
1answer
117 views

SP2010 - Formatted data view web part saved to gallery - get error when dropped on parent site

I have a list on a subsite that I need to feature on the parent site homepage. I created the formatted data view and saved it as a web part in the gallery. I drop it on the homepage but get a "web ...
1
vote
2answers
444 views

Sharepoint2007: Display Document Library Folder contents in customized format?

How can I do a customized view of a Document Library in home page? I want to show like following: ![image][1] **Title of Document** [with link to document] Body of articles [Intro Text] ...
1
vote
1answer
2k views

How to make field text bold in custom edit form?

I am already using custom field iterators to customize the fields on my list forms. When users are creating or editing a list item, I want certain field names to show in bold. For example, when users ...
1
vote
2answers
103 views

How to stop Sharepoint from auto formatting my code?

I would like to format my code by myself so it is easier for me to read the code, rather than having SharePoint formatting my code automatically, and it is hard to read.
1
vote
2answers
827 views

Display “NaN” instead percentage value

I'm using SharePoint 2007 and developing a custom view using SharePoint Designer 2007. I've a column of a table that should display numbers as percentage. Minimun value is 0, maximum 100. In SP ...
1
vote
2answers
3k views

Copy/Paste to SP 2010 Page does not keep formatting?

I am trying to copy a formatted Word 2010 document and paste it into a SharePoint 2010 page. Most of the formatting comes over to SharePoint fine, EXCEPT for the indentation of the lines. Is there ...
1
vote
3answers
1k views

Email loses table formatting using Sharepoint

Currently I am creating a form for my team in which whenever I created a table inside the form, the formatting always loses out when its emailed out using the workflow. It looks fine inside ...
1
vote
2answers
913 views

How can I format phone numbers in SharePoint 2013? [duplicate]

I'm wanting to format a column in SharePoint 2013 to automatically enter the parentheses and dashes in a phone number. So no matter how the telephone is entered, it shows (###) ###-####. Thank you ...
1
vote
2answers
86 views

How to format hyperlinks in blog comments?

SO and GitHub have an easy way to format hyperlinks by hiding the URL behind some descriptive text by enclosing the text in brackets followed by an URL in parentheses. How can I do something similar ...
1
vote
1answer
706 views

Date Time format confusion in my SharePoint 2013 server

I want all my date columns in the entire server to be in 'DD/MM/YYYY' format. So I setup the Locale in the regional settings as 'United Kingdom'. I did the changes in the following locations: ...
1
vote
1answer
679 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
1
vote
1answer
356 views

Possible to restrict format/layout/fonts of Wikis & blogs?

Is there a way that I can restrict the text formatting(font etc)/layout on the Sharepoint blog/Wiki sites? Or doesSharepoint have any options to control the HTML that is being generated when users ...
1
vote
1answer
8k views

How do I apply conditional formatting using SharePoint Designer 2013?

I'm attempting to apply Conditional Formatting to a list view web part via SharePoint Designer 2013, and I can't seem to find the option to do so. I've a horrible feeling I'm just being daft, but ...
1
vote
2answers
4k views

How can I apply custom styles/formatting to an out of the box web part?

I have a list of links stored in a Sharepoint List, and have them displayed in the standard list-item-displaying web part. I would like to have this web part formatted (perhaps with CSS) in a custom ...
1
vote
3answers
19 views

Conditional Formatting Based on Number Range

I'm trying to add conditional formatting to a custom list based on whether or not a field contains a number in a certain range (i.e., if the field contains a number less than 15, i'd like the ...
1
vote
0answers
84 views

Sharepoint Custom List conditional formatting date comparison

I am having an issue when creating conditional formatting using SharePoint Designer 2010. When the @Complete_x0020_Date is less than or equal to @Negotiated_x0020_Date, it will color the ...
1
vote
1answer
93 views

Format List Calendar View Days

We'd like to format the calendar view of a list not off the data entered for each of the days, but off the actual day of the week. For example: Saturday and Sunday boxes would be red Monday boxes ...
1
vote
0answers
96 views

Validate that text field matches a format zero or more times

I have a "single line of text" column in my list that needs to contain zero or more numerical values, separated by semicolons, with no spaces, letters, or other characters. The contents of that column ...
1
vote
0answers
112 views

Can the hover/active borders of form fields be customized and/or disabled?

I'm really not crazy about field borders in forms. In InfoPath, you can get rid of the borders, but then the row heights jump in the browser once the form is published to SharePoint. ...
1
vote
1answer
89 views

Can I lock the cells size in a datasheet view?

I'm working on Sharepoint2010. I have a datasheet which users can edit free. However I've noticed that everyone can change the size of the cells and even add other columns. How can I prevent any user ...
1
vote
0answers
68 views

How to prevent SharePoint 2010 Ribbon from reformating HTML code

I have the telerik editor installed in SharePoint 2010 Enterprise, and every time I edit a page in advance HTML mode, I would like SharePoint to remember how I formated the HTML code. But instead, ...
1
vote
0answers
293 views

How to apply “Table Style Medium 4” template formatting to excel created using open xml?

Hi I have a few datatables (No DataSet). I have created a method which will write datatable to excel. after writing data from datatable to excel, I will again call the same method of excel generation ...
1
vote
1answer
267 views

Highlight items older than X

I have a list which 4 statuses. New, claimed, pending and completed. I need to highlight items which are in the new status for longer than 3 hours. I've read that using the =today() function isn't ...
1
vote
1answer
729 views

SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?

I have this XML query that pulls all entries and fields from a SharePoint list. <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> ...
1
vote
0answers
66 views

Configure search to show particular cells of a list

This might be some kind of a stupid question, but I'm absolutely new to SharePoint and I've no idea what to do. I uploaded a list to my SharePoint and added a search scope for it. Now I can search, ...
1
vote
0answers
97 views

Why does Search only accept YMD date format when Search Language is en-ca (usually DMY date format)?

For some reason the server thinks that the date format for English (Canada) is YMD or yyyy/MM/DD, and the server will only correctly read queries with that format. However, the default short date ...
0
votes
1answer
2k views

Conditional Formatting sharepoint 2010 [duplicate]

Possible Duplicate: Conditional Formatting - Format row I'm using sharepoint 2010. how can I implemet the "Conditional Formatting" concept om custom list. I want to paint the list row ...
0
votes
1answer
406 views

Format field containing integer in edit/view form

I have a list with a field that contains an integer, let´s say 12345. In the edit/view form, the field is displayed as 12,345. How can I format the field so that it displays 12345? This is how the ...
0
votes
2answers
347 views

Custom Field with Custom Format

I have been tring to create a text field (SPFieldText) with a custom format XX-XXXX-XXXX and add a check (control) so that when you add a dokument with same property but different format to a document ...
0
votes
1answer
876 views

Date Format 'Bug' In Lists?

I have a calendar with a date & time field called Departure that a user fills when they add an item. For display purposes, my list view uses a calculated column with ...
0
votes
3answers
4k views

Creating a single column page layout in SharePoint 2010

I have been grappling with this seemingly basic task for the past hour and getting increasingly frustrated. I have created a basic SharePoint site which by default gives me a left and right column, ...
0
votes
1answer
105 views

How to remove time stamp from date field in InfoPath form?

I have a drop down in an InfoPath form that grabs data from a SharePoint list. One of the fields in the form is a date field and when it gets populated with the date from SharePoint it includes the ...
0
votes
1answer
761 views

Number formatting in Sharepoint list

I have several large Sharepoint lists that I imported from Excel, the first column of each of these lists is "Customer Number" these numbers uploaded in the form 1,000,000 and so on. I want to ...
0
votes
1answer
1k views

Conditional Formatting not applied to web part?

SharePoint Server 2010. In SPD, I have applied Conditional Formatting to a document library row, so the background changes color based on a column value in the row. Works great when viewing the ...
0
votes
1answer
4k views

Conditional Formatting using Calculated Column as Condition (SharePoint Designer 2010)

I want to use conditional formatting to change the color of a row based on a Calculated Column. I know I could do this with a CEWP but I would prefer to do it in SPD 2010 because I am new to ...