Skip to main content
Share Your Experience: Take the 2024 Developer Survey
7 votes

Hide "add column" in Sharepoint 2013 List

The "Add a column" is related to the permissions(full control, design, etc.). Users who have contribute, read or lower access will not see this anyway. Also note this action is found in the ribbon as ...
Chris G's user avatar
  • 1,282
5 votes

List and change image size

You can try this: { "elmType": "img", "txtContent": "", "style": { "width": "80px", "height": "60px" }, "attributes": { "src": { "operator": "+", "operands": [ ...
SharePointer's user avatar
  • 3,046
5 votes
Accepted

Column Formatting using JSON: Get value of the column "CheckoutUser"

Below code works for me: "display": "=if([$CheckoutUser.email] != '', 'block', 'none')" Since it's a user field, you can check email for a blank value ($CheckoutUser.id seems also works). ...
Sergei Sergeev's user avatar
4 votes

How to show date as day of week?

Using the defined system value, [TODAY], we can calculate the current date for a default by simply adding: [TODAY] To get the day of week, use the WEEKDAY() function: =WEEKDAY([TODAY]) Now we have ...
ShooShoSha's user avatar
4 votes
Accepted

Formatting list row based on status column Office365

Yes, it is possible. You can use View Formatting in Office 365 to color the rows based on the Status field. Use below JSON code to color the rows in your list: { "schema": "https://developer....
Ganesh Sanap - MVP's user avatar
3 votes

Sharepoint 2013 - custom display form - time/date not formatted correctly

The date will save in the UTC format internally and on custom forms you have to format and show. If you are using jQuery for your custom form, you can format as follows (new Date("2017-03-30T13:00:...
Venkat Konjeti's user avatar
3 votes

Formatting date inside a If than statement

You have to go the other way around, Not convert your date to Text but convert the text you use to compare to a Date. That will also make it safe to use in any language provided your field IS a ...
Danny '365CSI' Engelman's user avatar
3 votes
Accepted

Sharepoint 2013 - issue with using java script to format columns

Add the following code into script editor web part in list view page. <script type="text/javascript"> (function () { // Create object that have the context information about the field ...
LZ_MSFT's user avatar
  • 6,219
2 votes
Accepted

How to format a currency field in SharePoint 2013

If you set the column type to Currency while creating the column, then you will get the format you want without any coding. Currency columns are auto-formatted.
harshal gite's user avatar
  • 1,474
2 votes
Accepted

Web Part alignment query

Edit the content editor web part and select "Yes" for the option "Should the Web Part have a fixed height". Then change the value to fix your purpose. Click "Apply" to check the result after each time ...
imp. MSFT's user avatar
  • 1,321
2 votes

Column Width in Quick Edit or Datasheet View

Unfortunately, the answer provided didn't completely help my situation. We were able to use the CSS provided by EvanC to wrap the column headers but the column itself was still not adjusting. The ...
Tyler's user avatar
  • 41
2 votes
Accepted

Column Width in Quick Edit or Datasheet View

After a lot of searching, the following did the trick for me. This enables text wrapping in the Quick Edit view. .ms-spGrid-HeaderContentStyle div{ white-space: normal; }
EvanC's user avatar
  • 31
2 votes

Conditional formatting in item view (display form) using CSR / JS / CSS - is it doable?

In SharePoint Online, you should be aware of the JavaScript/CSS customization is not allowed for the Modern Experience list and libraries. Meanwhile, it's allowed for Classic Experience. In case, you ...
Mohamed El-Qassas MVP's user avatar
2 votes

Hide "add column" in Sharepoint 2013 List

You can try below CSS it is working on my SharePoint online site. It will hide the last column, .ms-listviewgrid .ms-viewheadertr th:last-child, .ms-listviewgrid tr td:last-child { display: none; ...
san's user avatar
  • 1,654
2 votes
Accepted

CQWP ItemStyle: how to display background of description with conditional formatting

If you do not wish to add style sheet as explain by @JJD then just update your item style sheet as below : <div class="description"> <xsl:attribute name="style"> <xsl:choose> ...
Bhaskar Dhone's user avatar
2 votes
Accepted

Conditional formatting for a row that contains any information

Try changing your code to this: <script type="text/javascript"> SP.SOD.executeFunc("clienttemplates.js", "SPClientTemplates", function() { SPClientTemplates.TemplateManager....
Damjan Tomic's user avatar
  • 3,656
2 votes

Formatting list row background color

Just sample demo: { "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json", "hideSelection": true, "hideColumnHeader": true, "rowFormatter": { "elmType": "...
Lee's user avatar
  • 4,271
2 votes

Formatting column with multiple conditions

Give this format a try: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "...
theChrisKent's user avatar
  • 6,011
2 votes
Accepted

Formatting column with multiple conditions

1.1 Trying to understand First of all we need to simplfy your business requirement into a simple set of a Logical condition to make it for the Computer to understand it : Here, from all the condition ...
AIMEN BOULAHIA's user avatar
1 vote

CQWP ItemStyle: how to display background of description with conditional formatting

Are you using an xsl file? In that case it would be something like <div> <xsl:attribute name="class"> <xsl:choose> <xsl:when test="(@RAG = 'red')">...
JJD's user avatar
  • 493
1 vote
Accepted

How to force a number field to keep zeros at the start?

I tried adding an out-of-the-box 'telephone number' field, Primary Phone, to a list, but it is a text field. So, I found this other post which deals with your issue. It seems there is no very simple ...
Tally's user avatar
  • 2,243
1 vote

SharePoint 2013 Content Query Tool Part - How to format a "Date and Time" display field?

I assume you're referring to the content query webpart? If so, here is a good example of how you can control the output of dates via xsl. Note that you'll have to adjust your schema, per the notes on ...
Matt Jimison's user avatar
1 vote

How to format a currency field in SharePoint 2013

I had created and tested by creating a currency type field and working as per you requirement
TARUN's user avatar
  • 2,856
1 vote

Sharepoint 2013 - custom display form - time/date not formatted correctly

I finally found the details of what I needed. I looked the blog post above and it hinted at the Locale format. I need a more detailed output so I thought I would post my solution. <xsl:value-of ...
garvon-77's user avatar
  • 589
1 vote

What causes the page jumping when applying formatting?

It might be the compatibility issue between IE11 and SharePoint 2013. You can click F12 in the keyboard->Emulation tab, change the Document mode to 10, check if the issue exists. Then go to Internet ...
Hellofiona_MSFT's user avatar
1 vote

Column Formatting using JSON (Sharepoint Online)

As I understand it, using JSON for column formating only works on Modern sites. I spent a long time trying to get progress bars on Classic sites working with CSR and gave up. I'm sure someone who ...
hydrogen's user avatar
1 vote

Change column width in SharePoint 365, using JSON

You can use this code. It includes a column width and a text color format - remove the color format if you don't want to use it. { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-...
Katy Sing's user avatar
1 vote

Change column width in SharePoint 365, using JSON

You could edit the allitem.aspx, add the script editor web part and add the code below to the script editor web part. It only can work for classic experience. <style> .ms-vh-div[DisplayName='...
Amy_MSFT's user avatar
  • 2,946
1 vote

SPO Conditional Formatting - Color Column views

The JSLink script below for your reference: (function () { (window.jQuery || document.write('<script src="//ajax.aspnetcdn.com/ajax/jquery/jquery-1.10.0.min.js"><\/script>')); var ...
LZ_MSFT's user avatar
  • 6,219
1 vote

SPO Conditional Formatting - Color Column views

I had this problem before and after a lot of searching I learned that you can't modify multiline text fields style. You can use a single line text field instead but it will limit your comments to 255 ...
RickyGzz's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible