August 13, 2019 at 01:41 #26601
I’ve gone thru the Forum and couldn’t find this one.
Using SP2010, to keep the same awesome look n feel of vLookup consistant on a page, is it possible to display a Child’s vLookup within the Parent vLookup?
Currently, the user has to click on a vLookup item to view the Childs vLookup documents.
I added the childs vLookup column to the Parent vLookup but it displays blank as there’s no search query I’m guessing.
Is there code to add the Special Config to display a Childs vLookup?
Thanks for your time.
August 13, 2019 at 15:29 #26614Alexander BautzKeymaster
Sorry, but there is no built in support for this. It is possible to build a custom function that does this, but it would have to be written from scratch and you cannot use the vLookup functionality to pull back the grandchild.
August 14, 2019 at 11:43 #26624
I was able to do this somewhat using the Grandparents Title field as a “Prefill values to Child” on the Parent List, then use that Parent’s field value again to Prefill in the grandchilds list.
So 3x vLookups configured in each Grandchild, Parent and Child list.
Then configuring another vLookup field in the GrandParent DFFS that matches the Grandparent Title to the grandchilds prefilled value and it displays.
It dooesn’t have full functionality, it can only be used to Display & Edit exisiting Grandchild items but otherwise works okay.
August 15, 2019 at 15:39 #26669Alexander BautzKeymaster
Nice! – I’m glad you found a workaround.
September 12, 2019 at 19:38 #27077
I have a solution that might work.
What I do is rather than use the the prefill _vlookupParentID, I use a combination of Rules and Cascading drop downs.
This looks to the deepest level I have:
Here is the lookup list Field:
and Here are the current list fields:
Each level is going to change a bit:
Vs if I go to the CLIN setting Level
Autofill subsequent dropdowns when they contain only one valid option needs to be selected.
On my project list I can see all related Grandchildren and great grandchildren as different vLookup lists.
September 13, 2019 at 02:55 #27083
Thanks for providing another method for displaying a vLookup within a vLookup.
Difficult to follow your explaination.
You said you needed a Rule as well?
Can you provide a screen-grab of how the vLookup is displayed within a List View?
September 17, 2019 at 20:33 #27099
The list view setting should work like normal.I don’t use because I’m in modern and its a bit chunky to me. If you have the List view box checked and the CEWP added in it should work just fine.
My Parent is Called Projects.
My child is Called PoPs.
My grand child is Called CLINs.
Projects and Pop vlookup relationship are set up normal.
So long as you pass an extra (the Project ID)field from the child to the grand child, you can create a lookup.
Screen shots attached.
September 17, 2019 at 20:34 #27105
I do an Admin Tab that only I can see so I can view the values being passed.
- You must be logged in to reply to this topic.