I have updated the tool described in this article with some new functionality.
The functionality i will describe here is the ability to convert a standard SharePoint lookup column to a cross site lookup column using javascript/jquery only!
Download the script from the above referred article. Create a Lookup column in your list and have it point to the actual list it is created from (it is in fact not relevant what list you point it towards). Load the script from the above described article and select your list:
Images
Select the list
Modify the web and list association and hit “Save”:
NOTE: The web selector is only available for site collection administrators.
If you are a non site collection administrator, you may change the list association, but not the web association.
This method requires NO modification to the field schema and is fully compatible with Data sheet view etc.
I have not had the chance to test it in SharePoint 2010 yet, but i can see no reason why it should not work.
Alexander

December 1, 2010 at 6:36 pm |
[...] Convert a standard SharePoint lookup column to a full blown cross site lookup using javascript only [...]
December 1, 2010 at 6:36 pm |
[...] Convert a standard SharePoint lookup column to a full blown cross site lookup using javascript only [...]
January 7, 2011 at 10:01 am |
Hi Alexander,
nice tool and working well.
On my server it doesn’t recognize the System Account to be a Site Collection Administrator, which was a little disappointing at the beginning but easy to overcome.
Another requirement is to change also lookup columns pointing to an external list (field type is ‘External’ in this case).
Any plannings to implement this in future versions?
Many thanks and best regards,
Tobias
January 18, 2011 at 8:33 pm
Hi,
I haven’t looked into the “External” field type yet so i cannot tell…
Alexander
May 2, 2011 at 8:52 pm |
Hi Alexander,
I will need your advice on a problem:
I need to filter a Lookup dropdown field based on an radio button, and another Multiple selection lookup field based on a multiple checked boxes.
I saw a lot of scripts for cascading dropdowns, but not for something like this. even for filtering radio buttuns based on dropdown, but not otherwise around.
Do you have any hint regarding this?
Thanks
May 6, 2011 at 9:05 pm
Hi,
Filtering a lookup column is a bit complicated and i do not have a solution to offer right now.
Alexander
June 3, 2011 at 12:52 pm |
Another great tool!
How difficult would it be to filter duplicates from the lookup list?
Thanks,
Ken
July 13, 2011 at 6:45 pm
This tool does not “interfere” with the values, it only points to which list to use.
Removing duplicates is a bit tricky as SharePoint does not have any built-in support for this. You could take a look at this one, but it’s not a standard lookup.
Alexander
July 13, 2011 at 4:13 pm |
Can the dropdown tool to select web include all site collections and not just sites within same site collection??
July 13, 2011 at 6:42 pm
This is not possible.
Alexander
January 31, 2012 at 11:21 pm |
Alexander, can this solution be used to restrict the triggering of an alert, or to hide fields that appear in the alert?
February 9, 2012 at 11:46 pm
Hi,
I do not quite understand – is this comment made in the right article?
Alexander
February 9, 2012 at 11:51 pm
I was hoping this script could control which columns are included in the email that Sharepoint sends to users who set up alerts. The alert emails include every field, including fields that contain code (like html, or code from your vlookup solution). It would be great if there was a setting to exclude them from appreaing in that email alert. I can send a screen shot if that would help.
February 9, 2012 at 11:55 pm
Sorry, but this is used to point a lookup column to a list in another site. That’s all it does.
I have no method of tapping into the alert messages sent by SharePoint.
Alexander
March 15, 2012 at 10:35 pm |
Alex, is this the right link to the javascript to make a standard SP column to be a lookup column?
http://spjsfiles.com/index.php?dir=SharePoint+JavaScripts%2FChangeListAndFieldProperties%2Fv2.0%2F
March 15, 2012 at 10:43 pm
It’s the correct link to turn an *existing* lookup column into a cross site lookup column.
Alexander