New answers tagged

0

I quit using InfoPath and learned how to use highly customized forms in SharePoint Designer for the same requirement you are trying to satisfy. Using javascript you can use the default preSaveAction() function that SharePoint forms will use every time they are saved. Inside that function you would need to use jquery SPServices UpdatelistItems to make a New ...


0

This isn't an excel issue. Person or group fields can't be retrieved using a lookup. You can get around this by using code, or by making a string copy of the owner field by running a workflow each time the item is changed, and the string can be retrieved using a lookup.


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 ...


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 ...


2

One way is to create your filtered view on your source list. Then go to Site Settings and click on Content and Structure. This will take you to a screen with a hierarchy of your site. Click on your source list and switch to your view. Select the items you want, and in the ribbon select from the Actions drop down Copy (or Move, I'd suggest Copy to make ...


3

The is no password for list email addresses because they are no associated with AD user accounts. There is also no inbox because these are not Exchange email addresses. List email addresses act more like identifiers for the lists so SharePoint knows where to direct and store incoming email messages. You should have a connector in Exchange that routes emails ...


0

All you have to do is create a datasheet view with no filter, select all rows, and hit the delete button.


1

PowerShell is the way to go. The following will parse 500 items at a time into the recycle bin and then remove them from the recycle bin. I've used this on lists up to 700k items. # Enter your configuration here $siteUrl = "http://sitecollectionurl" $listName = "Name of List" $batchSize = 500 write-host "Opening web at $siteUrl..." $site = new-object ...


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

I have frequently encounter this bug first reason is: we should fill required field by call correct name for example: string siteUrl = "http://sharepoint-server/"; ClientContext clientContext = new ClientContext(siteUrl); //Announcements SP.List oList = clientContext.Web.Lists.GetByTitle("Contacts"); ...


1

You can use Infopath or Client Side Rendering (JS Link) for hiding the columns of the SharePoint List. for better understanding follow this blog using CSR https://code.msdn.microsoft.com/office/CSR-code-samples-11-Fully-54ebcaa6 To understand CSR well, you can follow this link Client-Side Rendering/JS Link documentation?


1

Nothing wrong with using JavaScript. Almost everything in SharePoint (frontend-wise) is handled with JavaScript anyway. And it would be, by far, the fastest way to do it. SPUtility.js would be a good candidate for a library that brings all the functions you need: https://github.com/kitmenke/sputility


0

You can try below code Approach 1 : $(document).ready(function() { var userID = <<input your user ID >> var siteUrl = <<input site url>> var soapEnv = "<?xml version='1.0' encoding='utf-8'?> \ <soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/...


0

There is a default ID column which get auto incremented every time you add new item in list. You can use that. But that column in non editable. If you want to keep column editable you can write below code and it doesn't need CAML query using System; using System.Security.Permissions; using Microsoft.SharePoint; using Microsoft.SharePoint....


0

Unless you are a farm administrator or a developer with your own dev environment, chances are that you don't have permissions to log on to the server and run PowerShell. As a regular SharePoint end user you may have access to SharePoint Designer, though. Open the site in SPD. Here you can navigate to the list and delete it.


1

You can remove the list using PowerShell: $web = get-spweb -Identity http://spsiteurl $list = $web.lists["list name"] $list.AllowDeletion = $true $list.Update() $list.Delete()


1

To get the last record of the list you have to take Ascending='False' in CAML Query. <OrderBy> <FieldRef Name='EnquiryNumber' Ascending='False' /> </OrderBy> <RowLimit>1</RowLimit>


1

Sounds like Alerts are turned on for the list. You can check the subscriptions by going to the Manage Alerts page. You can navigate there by going to: Site Settings > Site Administration > User Alerts The address though is just YOURSITEURL/_layouts/15/sitesubs.aspx


-1

There are different we can achieve this. You can use out of the box View Item page for displaying the item. You need to make sure you are passing the correct item id as a query string parameter to that page. In the list view using JavaScript/jQuery you can add a dynamic column and embed the image into it along with a tag. Populate the href to have the same ...


0

There are different ways to do it in SharePoint (Append-Only-Comments) in the out of the box columns which keeps the old comments too. follow below link for more understanding https://chuvash.eu/2012/04/02/add-comments-column-to-your-sharepoint-list/enter link description here Also you can achieve this by using CSR in SharePOint list http://...


0

There is a very nice JavaScript-only solution from spjsblog.com that you could give a try: http://spjsblog.com/2014/03/04/commentbox-for-sharepoint-2010-and-2013/


0

it might not be exactly what you had in mind, but you could always just use a Multiple lines of text field with 'Append Changes to Existing Text' on. Version history will keep it so that you can see who added what comment. This is the simplest way to accomplish this. This of course assumes that permissions are not restricted on individual list items.


0

An alternate solution is to make use of Event Receivers. Apply a event receiver on the list you want to monitor and write the code to shift/ fill data into the destination list.


1

I finally found the answer! adding these two lines to the top of my script worked. $w = Get-SPWebApplication -Identity https://mysharepoint.org $w.GrantAccessToProcessIdentity("domain\my_username") Full script: $s = New-PSSession -ComputerName mysharepoint.org Invoke-Command -Session $s { Add-PSSnapin "Microsoft.SharePoint.PowerShell" $w = Get-...


3

This code should work: (web is a variable that references the web object) SPFieldUserValue value = new SPFieldUserValue(web, item["AssignedTo"].ToString()); if (value) { assignToUser = value.User; }


2

You can try below code to get SPUser in AssignedTo columns for specific item. If(task["Assigned To"] != null) { string fieldValue = Convert.ToString(task["Assigned To"]); SPFieldUserValue assignedTo = (SPFieldUserValue) task.Fields["Assigned To"].GetFieldValue(fieldValue); }


2

Try this SPFieldUserValue userField = item.Fields["AssignedTo"] as SPFieldUser; string userName = item["AssignedTo"].ToString(); SPFieldUserValue fieldValue = (SPFieldUserValue)userField.GetFieldValue(userName); SPUser user = fieldValue.User; Taken from http://ethan-deng.blogspot.com/2013/03/get-spuser-from-user-column-there-are.html


2

You can try below code, using (SPSite siteCol = new SPSite("http://server/sites/Contoso")) { using (SPWeb web = siteCol.RootWeb) { SPList list = web.GetList("/sites/Contoso/Lists/Books"); SPListItem item = list.GetItemByIdSelectedFields(3, "Title", "ISBN", "Retail_x0020_Price"); String bookISBN = ...


0

Removing a workflow from a list or library does not delete the actual source files used to compile the workflow. Rather, the workflow is no longer attached to the list or library, but the source files remain stored in the Workflows document library of the site. To delete the workflow, see the next section. In a Web browser, browse to the site that contains ...


0

Here is one way your setTeam function can look like: function setTeam(ctx) { // Set the default value of the drop-down field from query string. ctx.CurrentFieldValue = GetUrlKeyValue('Team'); // Return the default rendering function for choice fields. return SPFieldChoice_Edit(ctx); } Notes There are no IF statements required because ...


1

Something like this. Get the value of query string using GetUrlKeyValue and then use javascript/jquery to set the selected dropdown value. $(document).ready(function () { var dropDownValue = GetUrlKeyValue('Team'); if (dropDownValue) { $("select[title='Team']").children("option").each(function () { if ($(this).text() == ...


1

Put this JavaScript code in your newForm.aspx page in SEWP: <script type="text/javascript"> function myFunction() { document.getElementById("your dropdown control's id").value = getParameterByName('Team'); } window.onload = myFunction; function getParameterByName(name) { var url = window.location.href; name = name....


2

As @spguy mentioned, having separate document libraries can also help. However, if that is not an option, you can consider using folders to limit the fine grained permissions.


2

Are you limited to a single document library? Depending on what kind of content you are storing, is there any way to split them up and have multiple libraries? Are the 2000 documents that are submitted each year all of the same type of document that they cannot be separated? If you can split any of the documents up into active and archived documents, then ...


0

If you are on the Datasheet view in SharePoint and try to edit the form in InfoPath, it will also throw this error. If this is the cause, just switch from "Datasheet View" to "Standard View".


0

This CSR sort the groups by item-count: Type.registerNamespace('SPOODOO') SPOODOO.Demos = SPOODOO.Demos || {}; SPOODOO.Demos.Templates = SPOODOO.Demos.Templates || {} SPOODOO.Demos.Functions = SPOODOO.Demos.Functions || {} SPOODOO.Demos.Functions.Func1 = function (context) { ctx.ListData.Row.sort(function(a, b) { return parseInt(b['Title.COUNT....


0

Option 1:If you are trying to avoid custom code, the only way I see if to create connected web parts. So you will have a page with the master list view web part (the one with the unique id) and underneath it place all the other lists (list view web parts) and you create a connection between them based on the unique ID. Option 2: this is a little heavy on ...


0

As far as I can tell, it seems like MS made an unannounced change related to this at some point in the last 2-4 weeks. You used to be able to prevent the threshold error by filtering based on indexed/built-in fields, (so long as the filtered results counted less than 5000) but that no longer seems to be the case. That said, I have two suggestions that might ...


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

You can invoke the REST API as below https://siteurl/_api/web/lists/getbytitle('Test100') If the list doesn't exists then you can expect below response <m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> <m:code>-1, System.ArgumentException</m:code> <m:message xml:lang="en-US">List 'Test100' ...


0

Try this below code: SP.SOD.executeFunc('SP.js', 'SP.ClientContext', function() { clientContext = SP.ClientContext.get_current(); SP.SOD.executeFunc('SP.UserProfiles.js', 'SP.UserProfiles.PeopleManager', getUserProperties); });


0

Yes the error is because you are calling your function inside ready, call the below function outside ready function SP.SOD.executeFunc('sp.js', 'SP.ClientContext', sharePointReady);


0

You have to write Javascript on the page and modify the PreSaveAction() functionality. In preSaveAction functionality check in if condition the value of Status Field, If its resolved, set Date column to Today. I can write the script but you will get it easily if you do some googling.


0

If by "without a custom coded solution", you mean no server-side compiled/deployed code, then yes -- but your solution will almost certainly require some JavaScript code added to the EditForm for your Camps list. First, create a variable to flag whether activities are allowed or no, defaulted to false (e.g. var areActivitiesAllowed = false ) Next, perform ...


0

You can take inspiration from here: Limit only one entry per day per user in sharepoint list In short: Display an Activities View on the Edit Form Use JavaScript (in a Calculated Column) to alter your Edit Form


0

I don't think so, because Documents are not stored a filesystem but in (rows in) a Database. These rows are chunks of data, not bytes. So the size of a Document is metadata (written on file upload/change), not space occupied in the database. That means total size of a Library can only be found with a loop Alternatively you could add your own ...


0

You could use an item updating event receiver, and check the value of your field before saving. If the value is set to true, you can just cancel the update event with an error message saying "The fees are already submitted." or something like that.


0

The only thing you got is Item Level Security But this does not cover your scenario. You could achieve your scenario by changing the Ownership of an Item with code. (I do'nt think a Workflow can change it) Limit entries If you are not too tight about security, you could just hide the Edit form for allready entered values: Starting point: Limit only ...


0

You could have a workflow start every time a new Project List item is created which will update items in a helper list which is then displayed in the form. So, let's say someone creates Project S16-0042. The workflow checks which city this project belongs to and then updates the corresponding item in the helper list. City | Latest Project Number ------...



Top 50 recent answers are included