The arrangement of data for storage or display.

learn more… | top users | synonyms

0
votes
1answer
37 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 ...
2
votes
1answer
48 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 ...
0
votes
0answers
28 views

Modify List Formatting

I don't know too much about SharePoint, but I've been tasked with changing the formatting of a list we have on our site. The list is used on multiple pages and each page has a different view. The ...
1
vote
2answers
60 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.
0
votes
0answers
17 views

Is it possible to use inline-blocks in SharePoint?

Is it possible to use inline-block in SharePoint? I am trying to use them but it keeps formatting the code, and adding a space (&#160) to my div tags which messes up the inline-blocks. Here is an ...
1
vote
2answers
216 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
45 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 ...
3
votes
1answer
167 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 ...
0
votes
0answers
9 views

Conditional Formatting code for percentages [duplicate]

I have a SharePoint 2013 question on conditional formatting code. I would like to have percentage font 85% - 100% in green, and 84.99% on down in red. The problem is if set to display as a % it ...
0
votes
0answers
40 views

JL Conditional Formating for SharePoint 2013

I have a column of percentages in a list. 85.0% on up is in green font, and everything 84.99% and under is in red font. The problem is if set to display as a % it stops evaluating it as a number and ...
0
votes
0answers
18 views

Formatting issues when uploading excel tables

I am uploading an excel table with 4 columns to a sharepoint list. The first three columns are text, and the last column numbers. When I go to upload, it says that the middle two columns will be ...
1
vote
0answers
72 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 ...
0
votes
1answer
42 views

How do I show a calculated field along the same baseline as preceeding text?

I am new to infopath and so I may be missing something obvious... I have a combo box with sample data, and a calculated formula which binds to the value of that combo box. There is text before the ...
1
vote
1answer
476 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: ...
0
votes
1answer
22 views

How do I duplicate the formatting of a Web Part?

I'm building a page with tasks for my team and I can't figure out how to copy the Task Web Part formatting to each of the other team members. At the moment I ams doing this by hand setting: Web Part ...
1
vote
1answer
76 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 ...
0
votes
0answers
77 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 ...
0
votes
0answers
64 views

How to unify date formats on web parts

I have three web parts on my SharePoint 2013 page which show an item with the latest date of modification. These web parts are based on: Announcement app (so basically list with customized layout, ...
8
votes
4answers
6k 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 ...
0
votes
2answers
394 views

How to suppress display of comma when rendering a number column?

This is for SP2010. I have a custom content type which has a column defined as a Number column type. For other business reasons, it does need to be a Number type, so switching it to "Single line of ...
0
votes
0answers
195 views

DataProviderJSON: Cannot convert object of type 'System.String' to type 'System.Collections.Generic.List`1

I'm getting this error, my JSON is well formatted. using (ContentBySearchWebPart box = GetControlByIDPath(ControlID, this.Page.Controls[0]) as ContentBySearchWebPart) { string ...
1
vote
0answers
57 views

Apply CSS to all Choice Checkboxes [closed]

I have a choice field that allows multiple selections and users to add new values. I'm trying to put a red border around all of the checkboxes (long story why I need it). Previously I've done this ...
0
votes
1answer
49 views

SP 2010 - Lookup Column not working with Conditional Formatting

I have a lookup column for Tabs: Major Sub-1 Sub-2 Sub-3 Technical Pricing I need to setup conditional formatting so the row color changes with the level of tab selected. I can do this with drop ...
0
votes
0answers
14 views

How do I hide the text formatting in my shared calendar?

Our shared calendar now shows all the text formatting. How do I hide this formatting and not delete it?
1
vote
0answers
99 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. ...
0
votes
1answer
532 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
826 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 ...
2
votes
2answers
11k 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. ...
1
vote
1answer
78 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 ...
2
votes
1answer
52 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?
0
votes
1answer
319 views

Conditional formatting displaying correctly in SPD but not in page

I have been attempting to create status indicators in Sharpeoint Designer 2010 using two background images (red and green circles) in a hyperlink column and conditional formatting. The idea is that ...
2
votes
1answer
42 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 ...
0
votes
1answer
3k 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 ...
0
votes
1answer
43 views

Paste code into a discussion?

I have a discussion going on our Sharepoint site and I'm trying to paste some JSON for evaluation. I see no [pre] markup or anything similar. Am I just missing it?
1
vote
0answers
57 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, ...
2
votes
1answer
618 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 ...
0
votes
1answer
200 views

Hide Edit button in Data View web part based on Person / Group column

I am working on a customized Project Management solution using SharePoint. I have a data view web part which displays all the project data including Project Name / Project Manager. I have a Edit ...
0
votes
1answer
593 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 ...
2
votes
0answers
125 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 ...
1
vote
0answers
259 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
2answers
745 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
1answer
335 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
239 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 ...
0
votes
2answers
3k views

conditional formatting with advanced rules

I need to format rows in a list, based on the due date and status. If a task is not completed and there is still more then 7 days time it should be green. If a task is not completed and there are 3 ...
1
vote
1answer
680 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> ...
2
votes
1answer
253 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
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 ...
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 ...
2
votes
1answer
116 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 ...
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 ...