Vlookup in Newform
- This topic has 3 replies, 2 voices, and was last updated 10 years, 3 months ago by .
Viewing 3 reply threads
Viewing 3 reply threads
- You must be logged in to reply to this topic.
Home › Forums › vLooup for SharePoint › Vlookup in Newform
Tagged: Vlookup in Newform
Hi Alex,
How can i achieve vLookup functionality in new form?
Thanks,
Navya
Hi Alex,
How can i achieve vLookup functionality in new form?
Thanks,
Navya
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
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