Tag Info

Hot answers tagged

3

if you want date format in dd-mm-yyyy format although you changed local settings to United Kingdom you can use below formula: concat("Backup", "-", substring(now(), 9, 2), "-", substring(now(), 6, 2), "-", substring(now(), 1, 4))


2

Disclaimer: I don't know how that specific functionality is implemented, so it is possible that there exist a simpler way to achieve the same results as my proposed solution. Looking at SharePoint object model, the only way that comes to mind to achieve that is to work backwards - checking for each file if it has a relation to the original listitem. The ...


2

You can try 3rd party solutions from Virtosoftware (List Form Extender) or from Kwizcom (Column/Field Permissions)


2

We are using Virto Workflow Scheduler for these purposes. It's easy and simple solution from well-known vendor, VirtoSoftware. Try to use. Hope it help to you.


2

BaseViewID 0 is intended for using in views, which are added to home page! Remember, when you're adding a XsltListViewWebPart to a page, you can select to display "Summary view" in webpart properties. This is actually "BaseViewID=0" view. Source: How can I use normal paging on a custom view?


2

Nicole, Danny's solution should also work. If you want to keep it in one formula, this should work. =IF(LEFT(SUID,1)=";",IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package ...


2

It is easier if you build your Formula in partials/multiple Calculated Formulas, you can add a maximum of 48 Calculated Columns to a List and you don't have to use everyone in a View or Form. So create a separate Column "NumberStripping" with you Formula RIGHT(LEFT(SUID,FIND("=",SUID)-1),LEN(LEFT(SUID,FIND("=",SUID)-1))-1) That is the part you want to ...


2

The FeatureId 00BFEA71-52D4-45B3-B544-B1C71B620109 is used for Custom lists. You need to check the FeatureId of your custom template. To determine FeatureId property, you could save your list as a template, then go to List Template Gallery page (/_catalogs/lt/Forms/AllItems.aspx) and find the Feature Id value of the corresponding. list. see the answer by ...


2

I think I had success with this by using the Overwrite=True attribute (https://msdn.microsoft.com/en-us/library/office/aa544268.aspx). Also I believe once the content type is in use in a list instance it might be blocked from being removed. Try deleting the instance and then clearing it from both the first stage and second stage recycle bin then ...


2

I know this is an old question and has already been answered, but both the answers here led me in the right direction. Since my reputation isn't good enough to comment on their answers I simply decided to write out my own answer that details what caused this same problem for me, and how I resolved it. I also got the 'The Selected Cells are Read Only' error. ...


2

I think you are mixing up a few things in there. In SharePoint there is not an out of the box method for scheduling workflows. You can for sure get creative with multiple lists and looping actions - but this set's you up for trouble in managing that type of solution. You will either need to consider a custom solution - or look to a 3rd party tool, such as ...


2

The item with the biggest ID is the latest created item. function compare(a,b) { if (a.id < b.id) return -1; if (a.id > b.id) return 1; return 0; } arr.sort(compare); var latestItem = arr[arr.length - 1]; You can also compare the dates created in the Compare fuction and it will give the same result. function compare2(a,b) { var ...


2

This is possible OOTB. You have several options. Option 1 - JSOM (JavaScript Object Model). You can load the lists into JS arrays and do any number of joins and manipulations needed. Then a little jQuery magic to display it. Option 2 - Load the lists in separate webparts. Run some JavaScript to hide the other lists while collecting their data, then update ...


2

Stop inheritance & remove all permissions on the list and assign the permission to User on List : SPList list = web.Lists["myList"]; list.BreakRoleInheritance(false,false); // break inheritance & remove parent permissions // Now assign permission to "user1" SPUser spUser = web.EnsureUser("user1"); SPRoleAssignment roleAssignment = new ...


2

Working with lists and list items with REST url: http://site url/_api/web/lists method: POST body: { '__metadata': { 'type': 'SP.List' }, 'AllowContentTypes': true, 'BaseTemplate': 100, 'ContentTypesEnabled': true, 'Description': 'My list description', 'Title': 'Test' } Headers: Authorization: "Bearer " + accessToken X-RequestDigest: form digest ...


2

Select the option for "Return field as" to Lookup Value, while selecting [%Current Item:Application%] For reference, have a look at screenshot below.Instead of "As String", select Lookup Values,Comma Delimited


1

That is the limitation with importing a spreadsheet. You could make them choice columns or lookup columns to other Sharepoint lists you'd need to create. Once created, you'd then need to update the data, datasheet view could help speed that up, or you could then try deleting all the content and pasting the Excel data into datasheet view.


1

You can do this without having to run any conditionals in your workflow. Create two workflows (one for item creation, one for item change) and go to the workflow settings for each one. Check Start workflow automatically when an item is created or Start workflow automatically when an item is changed.


1

You'd do If Created equals Modified do these actions Else do these actions. When an item is created, it has the same date for created and modified. Once an item is modified, they have different dates.


1

According the OData spec there are supposed to be operations like count and inlinecount but, as far as I've seen, they don't work with the SharePoint 2013 REST API. Your best bet is to run the query you have above and then check the length property of the array that's returned. Update: I just though of another option, using the SharePoint 2010 REST API. ...


1

SharePoint lists consist of rows and columns that store data in a similar fashion to a traditional relational database management system such as SQL Server. However, a benefit of lists is that SharePoint includes Web Parts that provide simple methods for managing the data. If the data was stored in a database, it would require custom user interface ...


1

Expecting the PM field to be user field, you can create a view which filters by PM. Simply set PM to [Me] and this will result in showing all those rows where current user is PM.


1

The ListItemCollection does not have a files collection, so you cannot call the Add method. You can only add files to a document library by using a folder in you URL. Here is an example URL: http://site/_api/web/lists(guid 'guid')/rootfolder/files/add/(url='whatever.png',overwrite=true)


1

Yes event receiver do get fired if item is updated from client object model code. This is how I tested it. Created a custom list and added a text column named "Quantity" to it. Then created a SharePoint project containing an event receiver "ItemAdded". This event is added to custom lists only. Then added code to update the title of the item. public override ...


1

Make sure you are using field internal name. You can find the field internal name by opening the List Settings. And then right click the field and copy the URL. Paste the URL in notepad and check the query string value for Field=


1

You can add two field validations Expiration Date you can use formula =If([Expiration Date]>[Last updated],TRUE,FALSE) Last Updated you can use formula =If([Last Updated]<[Today],TRUE,FALSE)


1

Use site columns and content types. You can set permissions on them. Some people will get some fields in the form, others get different fields in the same form. All out-of-the-box, without SPD, InfoPath, Visual Studio.


1

One option is to use Content Editor Webpart and add links to each of the forms. Then use audience targeting to show/hide the different form url's. Another option is to use SharePoint JavaScript Object Model to check the permission and show/hide form elements. This approach does not provide fool proof security Another option is to create custom webpart and ...


1

You can a create a SharePoint Project in Visual Studio and deploy your customizations using a WSP. In order to deploy the master pages, custom css files and page layouts, you need to create a modules. Following example shows the xml code to deploy the master page to master page gallery: <?xml version="1.0" encoding="utf-8"?> <Elements ...


1

Your hunch here is correct - within an app the client context stuff will return the app's context, not the host context. Here's one example of how to get the host context from an app: (See http://www.mavention.com/blog/sharePoint-app-reading-data-from-host-web for source) The first step is to load required scripts and pull in the URL parameters - you ...



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