Setting up vLookup

Forums vLooup for SharePoint Setting up vLookup

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

  • Author
    Posts
  • #13547

    Paul Lynch
    Participant

    I’ve setup DFFS in my list, just added some tabs and css so far but would love to leverage the vLookup functionality but have struggled with the examples and the setup screen.

    I created two separate custom lists.
    I’d like to simply be able to create child items in one list, from the newform of the parent item.
    I’m using Office 365 SharePoint and latest version of vLookup.
    I have installed dffs on both and vlookup (just added a random column)
    I added columns _vLookupParentID to parent list and _vLookupID to child list
    I am at the Build Query stage now (see screen shot)

    It is the “Prefill values in child” section of the setup instructions that confuses me. It shows a screen shot of the “Prefill values in child” which I cannot see in the Vlookup Tab of DFFS setup.

    I wonder if I need to setup these two custom lists in a specific way. Particularly the child list. Hopefully just need some initial guidance/direction to get me back on track.

    Kind Regards,
    Paul

    Attachments:
  • #13567

    Paul Lynch
    Participant

    I guess put more simply.

    Can you join any two custom lists together?
    Or do you need to create a parent and child list?
    Do you need to be able to write scripts to make this solution work? (or at least create the parent and child lists).

  • #13572

    Paul Lynch
    Participant

    Sorry Alex, for some reason I missed this page that explains it all very clearly. Please ignore this!

    http://spjsblog.com/vlookup-for-sharepoint/vlookup-setup-example-for-sp-2010-and-2013/

  • #13584

    Alexander Bautz
    Keymaster

    I’m glad you figured it out – and thank you for the beer!

    Best regards,
    Alexander

You must be logged in to reply to this topic.