SPServices.SPCascadeDropdowns

Aug 14, 2013 at 3:41 PM
Hi Mark:

This is my first attempt at using SPServices so I apologize profusely in advance if I've made an obvious mistake in logic or in reading the documentation. But I've read the documentation over and over and nothing is materializing as to what the problem is. I've used the Discussions to double check that I'm not missing any comma, etc.

I created two lists which contain information that will be used to populate a form in a third list, Program Status Report. One list, Program Info, is locked down to editing by the Program Manager and another list, Program Budget, is only editable by the Program Office. Some of the columns in the lists are lookups to other lists. For example in the list, Program Info, Center is a lookup to the Center list.

I want form fields to populate once the Program Name is selected on the newform of my Program Status Report. The Program Name is a lookup to the Program Info list which is a lookup back to the Program Budget list.

"Program Status Report" list which has the following fields:
Program Name
Center - lookup to Center list
Customer - lookup to Program Info list
Portfolio Activity - lookup to Program Info list which is then lookup to Portfolio Activity list
Funding Source - lookup to Program Info list which is then a lookup to Funding Source list
Period of Performance - Lookup to Program Budgets list
Program Budget - lookup to Program Budget list
Program Manager - lookup to Program Info list

Heres the code I have:

$().SPServices.SPCascadeDropdowns({
relationshipList: "{GUID to Project Info list}",
relationshipListParentColumn: "ProgramName",
relationshipListChildColumn: "Center",
parentColumn: "ProgramName",
childColumn: "Center"
});

I tried to use debug: true but wasn't getting anything. I know it's something simple which is going to make me scream but for the life of me I can't see it. Been looking at it off and on for last week.
Aug 14, 2013 at 6:43 PM
Okay, in playing around with several things at some point I had made a change to the child column title - In the first dropdown I was referencing the child column as Customer instead of Center. It's amazing how you can stare at something for hours and not see something. Then you see it and you want to kick yourself. I now have part of it working. The dropdown works up to the Portfolio Activity field. At that point it shows two options - None and Option #1. It's working somewhat because there is an Option #2. I need to figure out why None is appearing.
Coordinator
Aug 29, 2013 at 10:04 PM
Did you figure this out?

M.