Vlookup in Newform

Home › Forums › vLooup for SharePoint › Vlookup in Newform

Tagged: 

Viewing 3 reply threads
  • Author
    Posts
    • August 2, 2016 at 10:10 #12632
      Navya Marla
      Participant

        Hi Alex,
        How can i achieve vLookup functionality in new form?

        Thanks,
        Navya

      • August 2, 2016 at 10:10 #12634
        Navya Marla
        Participant

          Hi Alex,
          How can i achieve vLookup functionality in new form?

          Thanks,
          Navya

        • August 2, 2016 at 11:42 #12636
          Navya Marla
          Participant

            Hi Alex,

            we tried to analyze the issue to find out the root cause and we came to know that the CAML query in new form is not passing the _vLookup ID.
            Please find the below query in new form

            <View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='_vLookupParentID' /><Value Type='Text'>~_vLookupID~</Value></Eq></Where><OrderBy><FieldRef Name='ID' /></OrderBy></Query></View>

            we tried to get the _vLookupID in the parent list in new form using Getfieldvalue.It is returning the correct ID

            In edit form

            <View Scope=’RecursiveAll’><Query><Where><Eq><FieldRef Name=’_vLookupParentID’ /><Value Type=’Text’>8:1470121931290</Value></Eq></Where><OrderBy><FieldRef Name=’ID’ /></OrderBy></Query></View>

            Thanks,
            Navya

          • August 5, 2016 at 07:33 #12682
            Alexander Bautz
            Keymaster

              Which version of vLookup are you using? – I have addressed an issue with showing vLookup matches form NewForm in vLookup frontend v2.2.70 (July 10, 2016): https://spjsblog.com/dffs/dffs-change-log/

              Alexander

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