vLookup within a vLookup using Listview

Forums vLooup for SharePoint vLookup within a vLookup using Listview

This topic contains 3 replies, has 2 voices, and was last updated by  Alexander Bautz 1 week, 2 days ago.

  • Author
    Posts
  • #26601

    Brett
    Participant

    Hi Alexander,

    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.

  • #26614

    Alexander Bautz
    Keymaster

    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.

    Alexander

  • #26624

    Brett
    Participant

    Hi Alexander,

    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.
    Screen-shot attached.

  • #26669

    Alexander Bautz
    Keymaster

    Nice! – I’m glad you found a workaround.

    Alexander

You must be logged in to reply to this topic.