New answers tagged

0

You can set checked the property using jQuery. $('input[name=SimpleHTMLCheckbox]').prop('checked', true);


0

Are you able to view the list in datasheet view? Meaning can you edit the list inline? If so, I suggest you simply enter the hyperlink into the top cell, copy it, select the rest of the empty cells from that column, and paste in the hyperlink. That should get you your "batch update".


0

Follow this link for better understanding https://social.msdn.microsoft.com/Forums/en-US/07512437-fecf-4257-bcc8-ba3c8e467554/how-to-increase-width-of-a-list-in-sharepoint-designer-2013


1

As an alternative (only to display a Hyperlink in a VIEW) you can use a calculated column, with the datatype set to DateTime (Number will align the HTML to the right) to output it as HTML. This also has the maximum string length of 255 characters BUT you can concatenate multiple strings up to the maximum Formula length of 4000 bytes ="<a href='http://...


2

You can not increase the limit. Possible workaround You can use Multi-Text column find more here OR You can use URL shortener like https://goo.gl/ and then store the URL in your hyperlink column. Google's URL shortener has JavaScript API. So call this API from your JS code and then store it in your hyperlink column. https://gist.github.com/hayageek/...


1

You can't increase the character limit of the hyperlink column. But you have a workaround for it, Add a Multi-Text column to your list Edit the item that has long URL Go to the Multi-Text field and you will get Rich-Content Ribbon Click Insert on the Ribbon > Link > To Address Add your Title and long URL in the respected field Source: ...


1

You can set up a Yes/No calculated field with the following formula. =IF(OR(MID(Title,7,1)="7",MID(Title,7,1)="6",MID(Title,7,1)="5"),"Yes","No") Just change "Title" to your Tracking Number field.


0

Below are the easy steps to add the text below uplaod dialog of Picture Library. Get the Page URL (like this http://SiteColURL/_layouts/Upload.aspx?List={GUID of document library}) of the Dialog of Picture Library upload document. below is the image of upload page of shared document library but you will get the same for picture library Open the URL ...


0

You can use UserSelectionScope="GroupID" attribute to specify a group in your CAML query. GroupID is a group ID (integer). You can see property description on the MSDN field schema description page


0

Try modifying PrincipalAccountType="SPGroup" as MSDN says. String used to specify the type of principals to be resolved in a query Comma-separated : "User,DL,SecGroup,SPGroup"


0

Create field and while creating come at down near Choose from option and select Share Point Groups and define group name under Choose from:. Hope this will help you...


1

Similar to http://stackoverflow.com/a/38020258/708685, you should be able to. While your column Assigned To has allow multiple values enabled, fill in all of your data as needed. Once done, turn off allow multiple values. SharePoint will pop up a warning about how this data may be lost (so far has never happened to me). Hit okay, then modify the view you ...


0

Maybe this will help anyone who doesn't want to use css or javascript magic and just use OOB SharePoint columns. For me multiline text field with enabled rich editing *including HTML) worked nicely. I just putted in as field value html generated like this: private string GenerateUrlLinkForMultilineTextField(string url) { return "<div class='...


1

It is not totally clear whether you want to write the value to the list or just display the value. So here is another solution which only displays the value without actually writing it to the list: ExecuteOrDelayUntilScriptLoaded(sum, "inplview.js"); function sum(){ ReRenderListView_old = ReRenderListView ReRenderListView = function(ctx){ ...


1

You can get total of the current view from ctx.ListData.Row. var total = 0; ctx.ListData.Row.forEach(function(item) { total += item["column1"]; }); Then update the column2 using REST API function updateItem(url, oldItem, newItem) { $.ajax({ url: _spPageContextInfo.webAbsoluteUrl + url, type: "PATCH", headers: { ...


0

You can create calculated column & use below formula to get the age of the item. =IF(ISBLANK(Created) ,"Created" ,"<img src='/_layouts/images/blank.gif' onload=""{" &" var SPday=new Date();" &" SPday.setFullYear(" &YEAR(Created) &"," &MONTH(Created)-1 &"," &DAY(Created) &");...


2

The best approach to this is to create a timer job or powershell/executable script that runs nightly to query your list items, iterate over them, add 1 to the field, and commit the change using system.update to not affect modified information.


1

You will have to call SPAutocomplete separately for each column. $().SPServices.SPAutocomplete({ sourceList: "My list", sourceColumn: "Email", columnName: "user1", ignoreCase: true, numChars: 3, slideDownSpeed: 1000, debug: true }); $().SPServices.SPAutocomplete({ sourceList: "My list", sourceColumn: "Email", ...


4

OnPostRender: function (ctx) { var rows = ctx.ListData.Row; var sum = 0; for (var i = 0; i < rows.length; i++) { var value = rows[i]["FieldInternalName"]; sum = +sum + +value; } alert(sum); } Can be condensed to: OnPostRender: function (ctx) { ...


0

You may use client side rendering OnPostRender to sum up all the values of a particular column. Use the below code. (function () { var option = { OnPostRender: function (ctx) { var rows = ctx.ListData.Row; var sum = 0; for (var i = 0; i < rows.length; i++) { var value = rows[i]["...


0

I'm not 100% clear what you're asking, but if I've interpreted you correctly, you should be able to add separate column values together (i.e. =([Column 1] + [Column 2] + [Column 3]) etc.). You may have to convert to a numeric value if they are "Single Lin of Text" columns, and also check for empty values as well in this scenario. If you're looking to add ...


1

I would create a new view, filtered by your column equals your particular value. In the Totals section of the view configuration screen, tell it to count on any of the listed fields. Save the view. When you visit the view, it will be filtered and there will be a total at the top of the view that tells you how many items there are.


0

SharePoint wasn't set up to update user data through Active Directory. I set it up to do that and it solved the issue.


2

Finally hunted down the error: I had the column indexed. Once I removed the index, it changed nicely, then I re-added the index.


0

Using either PowerShell or the SharePoint UI, Just add a site column to the content type, remove it, and then add it again. it propagates properly.


0

Within the Library Settings for any of the libraries you have already created, you should find an option called "Save document library as template" under the "Permissions and Management" section. Click that and provide the required information. The next time you use Site Contents > Add an app, the template you just created should be toward the end of the ...


0

The below script worked for me in SP2010.Add the script to a CEWP and place it below the list webpart and make it hidden. Kindly update your list name in the script: <style type="text/css"> #TTNheading { OVERFLOW: hidden; HEIGHT: 28px; } #TTNlist { HEIGHT: 400px; OVERFLOW-X: auto; OVERFLOW-Y: scroll !important; } ...


1

Danny Engelman has a very good list for tested and tried functions for calculated column. You can view the list here: http://www.viewmaster365.com/365coach/#/Calculated_Column_Functions_List


1

There's a great Dev Center resource that provides a list of Calculated Field Formulas. I've used it to calculate date values, do basic math, and concatenation.


0

You cann't work with columns like Today() or Now() in calculated columns. But calculated columns can be handy in many scenarios, i.e. If you have fields like lets say, red, green, yellow indicators, you can easily use HTML in calculated columns to show, red, yellow or green images based on categories. Also, you can play around with mathematical ...


0

Calculated columns cannot contain volatile functions like Today and Me. You can use Excel to built the formulas and use it in SharePoint. Here is a walkthrough http://techtrainingnotes.blogspot.in/2010/08/sharepoint-creating-calculated-column.html?m=1


1

This column only shows on OneDrive. Switch your OneDrive and you shall see the column there where you can set who has should access the file or folder and what permission level they should have.


0

Add the Reservations content type by clicking Add from existing site content types. Then you should be able to click Use this calendar to share member's schedule?


0

You can use JQuery to find and replace the html of your description. Add a content editor web part to your new and edit forms. This code will alert the full description. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script> <script> $(document).ready(function(){ $("#tbAllFields").html($("#...


0

You can do that using Client Side Rendering. I believe following references will help you to customize your form. SharePoint 2013 Client Side Rendering: List Forms Client-side rendering (JS Link) code samples Client Side rendering at PnP There is great tool for SharePoint CSR Live Edit in Chrome.



Top 50 recent answers are included