Wednesday 9 October 2013

Query SharePoint 2013 (on-premise, online, 365) list WITHOUT any code deployment

As a consultant you often get a task where you need to make some shiny and neat functionality to an existing site. But you are not allowed to make code-solution or there is simply no budget for that. What to do...?

In SharePoint 2013 many of these tasks can be done with out-of-the-box webparts, some JavaScript and CSS.

Lately I had customer who wanted two dropdown boxes on a list form to be related. If you choose the option "Fruits" in dropdown box one, you should only be able to select fruits in dropdown box two:

[PICTURE]

In short

So what I basically did was to call the rest webservices to query a list with all the fruits, vegetables and other choices for the drop down with a ajax call from jQuery. I put all this "code" in a Content Editor Web Part and placed it on the "New Form" and "Edit Form" for the list containing the drop down boxes.

Step by step

La la la... (shorthand for: "coming soon")