Hi, first of all I have to say that I'm very new to SharePoint and the use of designer, etc. What I'm trying to do would assist me in creating a pseudo help desk for my department. I am an administrator on the sharepoint site but not on the companies servers, etc. I cannot load templates in, etc. Let me explain the issues...
1. I have thousands of "sites" that we manage across the world. My initial thought was to create a page that the user would first select the site type, then country, state, city, address. All of the cascading smaller and smaller to reach what they need. I implemented the cascading dropdown and it works to a point. What it does is shows the site types but then when it gets to states, it does show all the states but not unique values. So there could be 10 CT's, etc. Once you select the state, the same occurs with the City. This is most likely because I'm referring to the larger "sites" list but I cannot create individual lists for Country, State, City. That would be a bear to manage.
The goal would be to show the site types (there are only 3 unique values). Then the country (unique) and so on. By showing the unique values only once would really make it work well.
Below is the code for just the State and City - figured I would start off small:
Code:
<script language="javascript" type="text/javascript" src="Shared%20Documents/jquery-1.4.2.js"></script>
<script language="javascript" type="text/javascript" src="Shared%20Documents/jquery.SPServices-0.6.0.min.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function() {
$().SPServices.SPCascadeDropdowns({
relationshipList: "Sites",
relationshipListParentColumn: "State",
relationshipListChildColumn: "City",
relationshipListSortColumn: "ID",
parentColumn: "State",
childColumn: "City",
debug: true
});
$().SPServices.SPCascadeDropdowns({
relationshipList: "Sites",
relationshipListParentColumn: "City",
relationshipListChildColumn: "Street",
parentColumn: "City",
childColumn: "Street Address",
debug: true
});
});
</script>
2. The other thought I had was to create a webpart on the main page, where the sorting of the sites could be done. Then a checkbox or button where the user would select the site and then be able to enter the "service" in another form. The problem is I don't know how to do this -- I tried thinking I could pass the site's variables to the service form, etc. but just couldn't wrap my head around it. If anyone could provide a link to a site that could walk me through explaining, that would be great.
Thanks to everyone. Sorry for so many issues but I figured I would throw it out there and see if anyone has any suggestions or perhaps they have a similar issue they're working on.
Login
FAQ
Search
