Re-Direct With ID - REVAMP

Ended up re-working the process from my previous post!

RECAP: The goal is to allow users to enter a list item and associate a number of items in ANOTHER list with that original list item. In this case, we have a list of projects and we want to associate multiple notes with a single project.

My original approach was to use URL parameters wherever possible. That still works in a few cases, but I found that it works better to skip the URL hassle. Instead, I hid a data view web part on the child (the notes list) newform page.

The hidden data view web part is filtered to show only the ID of the project most recently modified by the current user. That ID is displayed in a cell with the ID "ProjectID".

On the same page, my add-a-new-note form has a hidden field that accepts that ID. That field is populated using the following Javascript:

<br /><script type="text/javascript"><br /> <br /><br />// This javascript sets the default value of a lookup field identified <br />// by <<FIELD DISPLAY NAME>> to the value stored in the querysting variable<br />// identified by <<QUERYSTRING VARIABLE NAME>><br /> <br /><br />_spBodyOnLoadFunctionNames.push("fillDefaultIDValues");<br /> <br /><br />function fillDefaultIDValues() {<br />var temp = document.getElementById("ProjectID")<br />var RealId = temp.innerHTML; <br /> setLookupFromFieldName("Project ID", RealId);<br />}<br /> <br /><br />function setLookupFromFieldName(fieldName, value) {<br /> if (value == undefined) return;<br /> var theSelect = getTagFromIdentifierAndTitle("select","Lookup",fieldName);<br /> <br />// if theSelect is null, it means that the target list has more than<br />// 20 items, and the Lookup is being rendered with an input element<br /> <br /> if (theSelect == null) { <br /> var theInput = getTagFromIdentifierAndTitle("input","",fieldName);<br /> theInput.value = value;<br /> theInput.fireEvent("onblur");<br />// ShowDropdown(theInput.id); //this function is provided by SharePoint <br />// var opt=document.getElementById(theInput.opt);<br />// setSelectedOption(opt, value);<br />// OptLoseFocus(opt); //this function is provided by SharePoint <br /> } else {<br /> setSelectedOption(theSelect, value);<br /> }<br />}<br /> <br /><br />function setSelectedOption(select, value) {<br /> var opts = select.options;<br /> var l = opts.length;<br /> if (select == null) return;<br /> for (var i=0; i < l; i++) {<br /> if (opts[i].value == value) {<br /> select.selectedIndex = i;<br /> return true;<br /> }<br /> }<br /> return false;<br />}<br /> <br /><br />function getTagFromIdentifierAndTitle(tagName, identifier, title) {<br /> var len = identifier.length;<br /> var tags = document.getElementsByTagName(tagName);<br /> for (var i=0; i < tags.length; i++) {<br /> var tempString = tags[i].id;<br /> if (tags[i].title == title && (identifier == "" || tempString.indexOf(identifier) == tempString.length - len)) {<br /> return tags[i];<br /> }<br /> }<br /> return null;<br /><br />}<br /><br /></script><br />

NOTE: In this case, the ProjectID field in my child list is a lookup field. If you have a different type of field, you'll need to alter the javascript to some degree. The holy grail of info on setting values in SP forms with Javascript is here.

Once the data is ready, I wanted to send the user back to the display form for the project they were working on (I would have preferred to send them to the edit form, actually, but doing so can cause save conflict errors). To do that, I had to go back to the URL parameter, so I can specify what project I want to display.

It took a smidge of Javascript magic again to properly insert the project ID into the URL. Here's the code:

<br /><script type="text/javascript"><br />function ExperimentalSubmit()<br />{<br />var TheCell = document.getElementById("ProjectID")<br />var TheID = TheCell.innerHTML;<br />var actionStr = aspnetForm.myactionstr.value;<br /><br />actionStr = actionStr.replace("REPLACEURL", "http://edweb/meg/Analytics/Lists/ProjectTracking/Item/displayifs.aspx?ID=" + TheID + "&Source=http%3A%2F%2Fedweb%2Fmeg%2FAnalytics%2FLists%2FProjectTracking%2Fadmin.aspx%3FShowInGrid%3DTrue%26View%3D%257B48FE1D5B%252D7EFE%252D4BBF%252DBCEE%252DFB47D868720D%257D%26InitialTabId%3DRibbon%252EList%26VisibilityContext%3DWSSTabPersistence");<br /><br />eval(actionStr);<br />return false;<br /> <br />location.href = url + "?ID=" + TheID;<br />return false;<br />}<br /></script><br />

This is called in a custom submit button:

<br /><input type="button" value=" Submit " name="btnTopSave" onclick="javascript: ExperimentalSubmit();"/><br />

And there you have it!