Setting up vLookup

Forums vLooup for SharePoint Setting up vLookup

Viewing 3 reply threads
  • 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!

      https://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

Viewing 3 reply threads
  • You must be logged in to reply to this topic.