How can I pass a Parameter via Query String to populate a lookup field on a New Item Form/DVWP?

Question

I have two lists:

• List A: Products
• List B: Requirements

I'd like to have a nice Create Requirement page launched from the Product Listing page.

I have a DVWP/Multi-Item View displaying all Products. Next to each product, there is a Create Requirement link. The hyperlink generates the Query String URL /Pages/Create-Requirement.aspx?Product=Product

On the Create-Requirement.aspx page, I have a DVWP/New Item Form. The form includes a lookup field back to the Products list. I would like the Query String parameter to populate that lookup field and for the field to be hidden.

I've seen different methods of using Javascript or jQuery to pass to a field on a Custom New Item Form - but not necessarily a DVWP/New Item Form. And it's easy to pass to a text field but not a lookup field. I even tried passing to a text field that would then populate the lookup by workflow on item creation but SPD won't do that (unless someone can think of workaround logic).

Hiding the field should be easy enough - I just can't make the lookup happy. (Lookups are never happy.)

Answer 1

This blog post from Microsoft is highly linked to and describes what you want to do. I've used it before, these days I typically use jQuery and SPServices. Setting lookups typically requires you to pass in the Lookup ID value or the ID;Descriptor.

Here's an actual example from a site of mine, it's setting a person/group field, not a lookup though. You can experiment with looking at the source of the rendered page to see what markup the lookup field generates, then try passing in either the ID or the description in the query string and setting the field to that. If it saves properly, then set the visibility to hidden.

var queryStringVals = $().SPServices.SPGetQueryString();
var insEmail = queryStringVals["InstructorEmail"];
  $("textarea[Title$='People Picker']").val(insEmail);

Another example from some of my code, this is setting a >20 choice lookup field. It is using a hard coded value but so long as your query string variable passes over the proper vaule, it would work.

$("select[Title$='Department']").val('*Not Applicable - Student');

Or to abstract it to account more closely to your situation:

var queryStringVals = $().SPServices.SPGetQueryString();
var prod = queryStringVals["Product"];
$("select[Title$='Department']").val(prod);

Answer 2

Using Jquery and normal OOB Javascript functions we can easily implement this as below

<script type="text/javascript">
var url = new URL(window.location.href.toLowerCase());
var product = url.searchParams.get("Product"); //Product is the Name of Query Parameter passed through the URL
$( document ).ready(function() {
    $("select[Title='Requirements']")[0].value = product; // Title is the Display Name of the Lookup Field
});
</script>