Tag Info

Hot answers tagged

3

I would suggest putting the districts and their schools in a Term Set and use a Managed Metadata column.


3

If you neither want to use InfoPath nor Workflow, then you have to use SharePoint web services to fetch corresponding data in Column B for a selected value in dropdown Column B. You can achieve this functionality using SPServices library. Its a js library used to call SharePoint web services and perform operation very easily and in efficient way. You have ...


2

SPCascadeDropdowns works. It is one of the most popular functions in whole SPServices library, thus it is tested and proven to be functioning by tens of users, at the very least. Also Marc has demo page, there you can see it yourself. XSLT in SharePoint acts as server-side templating engine, not less and not more. You should use it for one-time-only ...


1

I'd suggest looking at the SPServices javascript library. Marc has made a great function the handles cascading very simple with jQuery. Since you're already using client side script, this might be another option.


1

From the tags of your questions, I assume you're using an InfoPath form, and I assume for the selection that you mentioned you are using "select" control (dropdown), so the question is, are you using data source for the drop down or you are filling static data? In any case you can use the action rule on the dropdown list to fill other fields based on the ...


1

This isn't supported out of the box. You have a few options: Use an InfoPath form to apply the filtering, but keep in mind that InfoPath is being discontinued in future versions Use JS Link to customize the item forms, or create a custom field for it (this was better explored here and here) Perhaps adapt the requirements a bit and use a Managed Metadata ...


1

If you can use jQuery, there is an outstanding jQuery library called SPServices that has a function to help with cascading columns. If you can't use script, there is an option available using InfoPath.


1

Paul's solution - managed metadata - works well if your list is stable and if you do not need to attach additional properties to each item (e.g. school address, contact, etc.). An alternate option is to use two SharePoint lists: one for the districts one for the schools, with a lookup column that points to the districts list Then you can create lists ...


1

You can use SPServices Cascaded Dropdown functionality Or you can modify list forms via InfoPath and achieve cascaded dropdowns, as shown in the following post: How to create cascading dropdowns in InfoPath [[The example relates to SharePoint 2010, but its the same for SharePoint 2013.]] I hope you already know about Lookup columns, and know that Schools ...


1

I don't get it. Cascading means exactly this: one depends on another. In your case, the secondary dropdown can only be populated once a selection on the first dropdown has been made and sent back to the server with autopostback=true. The query of the secondary dropdown datasource needs to receive the value of the parameter from the first dropdown selection. ...


1

For this sort of lookup I would be tempted to use a hierarchical term set. You can use a single metadata column instead of the complexity of 3 connected ones. You can display the full path of the selected term and you can use XSLT to split them into individual values if you need that. Filtering will allow you to filter at any level in the hierarchy and you ...


1

I should use the example that are explained in the SPServices project, like this: http://spservices.codeplex.com/wikipage?title=GetListItems basically you can use JQuery and IMHO is better


1

From their site apparently the version of jQuery you are using does not work with SPServices... "2013-02-05 - SPServices will not work with jQuery 1.9.1 due to a bug in that release." SPServices on codeplex


1

SPServices will convert the dropdown to a simple select for you; it's one of the options. Simply set simpleChild: true. If you used SPComplextoSimpledropdown properly, then the cascading should have worked, but the option is built into SPCasecadeDropdowns so there's no need to call it separately. The reason that the cascading stopped working when you used ...



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