New answers tagged

0

Rather than a timer job which "touches" all the items, consider using jsLink or other client side rendering techniques to calculate the value in real time. Of course, it depends on how you are using the values, which you don't indicate.


0

The way I got it to work was with a timer job. Create a timer job Itrate over all the items in the list Do an item.systemupdate() This won't change any field but will sure recalculate all the calculated colums.


-1

I think you may find your solution in this Pentalogic blog. It's been a lifesaver for me in working with calendar/today issues.


-1

Maybe type 'calculated column today' in that white box in the top right (it is a search box) And switch to the ranking-by-votes ?? http://sharepoint.stackexchange.com/search?tab=votes&q=calculated%20column%20today


1

Unfortunately, this isn't possible since Calculated Columns are not recalculated on viewing, but only on creation and modification. See this article: http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/ You will need to solve this with display logic.


0

I manage to figure out the location of these files after checking around and literally missed the path. The Steps In Internet Explorer, access any library on the site to open up the library in file explorer. Click the Open In Explorer button on the SharePoint ribbon. When the file explorer opens, click on the folder 'Lists' to access the folders of all ...


0

These "files" usually lives in your content database. That's why you can't find the actual files in an on-premise environment. The Views shows a list of items in "prescribed order and selections". This means that you use the views to display list data the way you want, by date, by author, by title, by category. It can be grouped, sorted and filtered in ...


0

You can expand the lookup column. https://***/sites/_vti_bin/ListData.svc/List?$select=Title,LookupColumn/OtherColumn&$expand=LookupColumn In this example my list has a column called LookupColumn that looks up a value in another list. This other list has a column called OtherColumn. By expanding LookupColumn in your query you can access the value of ...


0

You have already linked the tasks with sprint ID in Task List, Now you are looking for a way to display each sprint, and underneath each sprint, every task that was completed. So in the Sprint ID lookup field, you have options to select the fields related to sprint > try to select the fields that you need to show with its related tasks like Spring Name, ...


0

The workflow is looking for a Date and Time field, but lookups return text. You need to return the field as Lookup text. Set Variable: lookupStart to Current Item:Lookup: Sprint Start Date, Return fields as Lookup Value (as Text)


0

Did you try the below solution? http://stackoverflow.com/questions/10205192/x-frame-options-allow-from-multiple-domains You may have to allow that specific domain in which you want to show the documents. You can set X-Frame-Options in IIS for the specific site. Click on the site in IIS. In the middle pane look for HTTP Response Headers and add an entry ...


1

There are four sharepoint list columns that will allow multiple entries: Choice Lookup People/Person/Group Managed Metadata Obviously, persons would not be appropriate for this scenario. But the other three can all work. Generally speaking: Choice is good if you have a small amount of products. Lookup is good if you have a separate list for the ...


0

SharePoint exposes WebServices which you can use to load information to SharePoint from External Systems. Since you specifically requested for List Item Add below service can be used https://blogs.msdn.microsoft.com/ryanrogers/2004/10/08/adding-new-list-items-using-the-lists-asmx-web-service/ You can also check the REST endpoints https://msdn.microsoft....


0

Viewing with console developement browser, I find the source problem : SetDisabledOnControl function is unknown. This post indicates the source problem is an UC update. But I can't test the proposition on this post to validate it. I think it's dangerous to edit a forms.js file on a PROD server. The solution is to upgrade this site collection to user ...


0

You need to check if the user with whom you try to add value to choice field is having "Contribute" access on the list/library in which this field has been added.


0

It is actually a pretty nooby problem, I changed the display name of fields to static name and that works perfectly. Thanks for the community help and hope this answer could be helpful for the others.


1

Looks like issue with the internal name, please confirm the column internal name. try with may be "name" columns internal name, this can be default "Title" valuepairs:[["Title",name], ["description", description]]


0

The itemArray is not needed (unless you are using it elsewhere) because this line: clientContext.load(itemArray[itemArray.length-1]); is also not needed and may in fact be causing you problems. To update a list item all you need is that update() call followed by the clientContext.executeQueryAsync call.


0

You can use choice filter and In the advance settings of this filter, enable multiple values.


0

I have discovered a simple way of formatting Date field in SharePoint to exclude time stamp. I opened the list in SharePoint Designer and open the properties of the list. Select Formatting and deselect Time.


0

2013 task lists have the new time line associated with that content type. Otherwise Ghantt chart views work with any other lists, given the correct info such as start / end dates. There is also the task list timeline web part that can showcase the items from the task list.


-1

I ended up using metadata navigation and filtering to achieve this.


0

If you are using a web part page, Arsalan's answer is about as good as you can get. However, if you're using a Wiki page, you can do this without having to use SharePoint Designer and un-ghosting your page. Just edit the Wiki page in the browser and click within the page layout section, then go into Edit HTML Source (in the ribbon under Markup) to add the ...


0

Here is the best solution to do it. You can use retention policy. In designer create a workflow in your timesheet custom list as move current item to weekly timesheet Then stop workflow Save and publish workflow Then follow these steps: Go to your timesheet custom list Click on list (From the menu) Click on List setting click on Information ...


0

There is a hidden List in the Site which lists all Users who has permissions on the site. URL - http://siteurl/_catalogs/users/simple.aspx If you know the User ID then details can be retrieved using URL - http://siteurl/_layouts/userdisp.aspx?id={UserID}&Force=True


0

Should you check this code Create a new function and rename it as bulkupdate Function BulkUpdate() { for(var i = 1; i<= 5; i++){ updateListItem(int i); } } } var siteUrl = '/sites/MySiteCollection'; function updateListItem(int i) { var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web()....


1

It seems like clientContext.executeQueryAsync(succeededCallback, failedCallback) is missing from you code. You will be able to access list data in succeededCallback function only. Please refer msdn link for you reference.


1

The page reloads when you click your link, so you need to put JavaScript on the page which on load: extracts the FilterValue1 query string parameter find the corresponding link applies the css Step 2 will be a lot easier if you add an id to each link So if you define your links like this: <a id="linkA" href="?FilterField1=FirstLetter&...


1

You should start using browser Dev tools. Using that inspect the element which shows you how it is rendered in HTML. What all attributes it has. Once you have this information, you can use appropriate jQuery selector to select the object and apply your logic (hide/show etc.) For example below screen the field name is "FieldName" and you can see the ...


0

Using PowerShell you can update the lookup list Id $webURL = "http://server/sites/XY" $listName = "MyList" $columnName = "MyColumn" $lookupListName = "Category" $lookupWebURL = "http://server/sites/X" RepairListLookupColumns -webURL $webURL -listName $listName -columnName $columnName -lookupListName $lookupListName -lookupWeb $lookupWebURL Function ...


0

I would simply create a calculated column that displays the first letter of the Item Title and then use that in my views to display it for users. The group by view shows and totals how many "A>Z" items are in the list as well. Set up column: then you have a view that looks like this and it can be grouped like this


1

OOTB way to achieve this is to make the User Name column as unique. This is only possible if the column is single select person or group column.


0

You can use a is not equal to operator in your view. Since you say you want everything but D or E, your filter would be: Column X is not equal to D or Column X is not equal to E.


0

In case of you got “The server was unable to save the form at this time. Please try again.” for all users. SharePoint Search Host Controller service may need to restart to free up some memory space. Anonymous Authentication was disabled in IIS. “minFreeMemoryPercentageToActivateService” attribute is not set to serviceHostingEnvironment Tag in Web.Config. ...


1

The All Versions command, doesn't mean versions of the list, but means it exports all versions of all list items. When the list is then imported, the entire version history of the list items is present instead of the most recent version.


2

Add a script editor webpart to the same page where your list is and set the color for the selected column header using this CSS. <style type="text/css"> .ms-headerCellStyleMenuOpen { background-color: rgba(255, 0, 0, 0.50); } </style> Edit: Just saw that this was for 2010. As i don't have access to a 2010 farm anymore, this might or might ...


1

Use a SharePoint Designer workflow, started when the item is created, to wait for the item to be closed. Wait for Status to equal Closed Set Closed On to Today You shouldn't use a calculated column, nor a workflow with an if statement, as some are suggesting. If the item is opened in edit mode any time after it's closed, and then saved (even if there are ...


1

Create calculated column Closed On with below formula: =IF(Status="Closed",Modified,"") Select Date and Time as data type for calculated column.


1

Yes. It is possible. The sample code given below will read data from Blog list from host web and display data in your app. <script type="text/javascript"> // Set the style of the client web part page to be consistent with the host web. (function () { 'use strict'; var hostUrl = ''; if (document.URL....


0

Maybe the answer is late, but here's a quick & dirty workaround to achieve such a behaviour: Use View Ribbon Custom Action on Multiple List Items The main tricks: SPD creates the UserCustomActions definition for the list with code to only display for a single item. Using SP Manager, you can simply edit the script to allow for any number of selected ...


0

Yes, there is a way to add multiple time lines. The limitation on SharePoint is that for a task list, there is only one default timeline in which the tasks are added. We can add another timeline to the list using the list folder properties. If we query the folder properties, we can find the timeline_timeline property which contains the metadata for the ...


0

This can be accomplished by using the single line of text type and using the following validation: =(LEN([Start Time])=5) +(MID([Start Time],3,1)=":") +(CODE(MID([Start Time],1,1))>47) +(CODE(MID([Start Time],1,1))<51) +(CODE(MID([Start Time],2,1))>47) +(CODE(MID([Start Time],2,1))<58) +(CODE(MID([Start Time],4,1))>47) +(CODE(MID([Start Time],...


1

Create a content type which has all the fields in the list. Now create list for each subsite and choose the content type as the default one. For rolling up data use Content Query Webpart and choose the content type from the Webpart properties.


0

$newItem.UpdateOverwriteVersion() May be what you're looking for. If necessary you can also use $newItem["Modified"] = $sourceItem["Modified"]


0

SharePoint is not a relational database, so this is a bit of a mission, but it can be done. Mark Rackley has a great video tutorial for such a scenario for 2013 and the page contains a link to tutorials for earlier versions. http://www.sharepointhillbilly.com/Lists/Posts/Post.aspx?ID=26 Quoting: So, for those who care more about the “what” than the “...


0

You can implement this in many ways. Below approach is unnormalized which makes it easy to create views Create a list and name it Team. This list require only the Title field Create a TeamMembers list. This list will have a User field and a lookup field to Team list Create a View and Group by Team - This will show each team and its respective members ...


1

SharePoint Incoming Email is simply a standard SharePoint List that is assigned an email address. IIS SMTP (typically) receives the email from, for example, Exchange, and via timer job consumes the EML and adds it to the List with that assigned email address. What you need to monitor is List Item creation which you can do via SharePoint Workflow, Event ...


2

You should select the view as "Full list view" in view section. This enable all the collumn in the list. Hope this help. Below is the screen shot


0

There is a new JavaScript library added by Patterns and Practices team. That library uses the REST API and easy way in obtaining the result in less lines of code. We require a pnp.js file, which is available from here To run the below code in IE include fetch.js and promise.js to the code. <script type="text/javascript" src="/siteassets/scripts/fetch.js"...


0

Your question doesn't give much details on your environment or how the list/columns where originally created, so I will have to guess. As you may have guess, there is no out-of-box functionality to allow such field type change (as least afaik), so you will have to resort to a custom "migration". There are two opposite cases that we should consider: Option ...



Top 50 recent answers are included