Timeline for How to make a filtered lookup field
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 18, 2019 at 15:33 | comment | added | John John | @ronx simple and smart solution thanks.. | |
| Mar 15, 2017 at 5:44 | comment | added | Abdul Hameed | @Mario, to address that check the workaround by Coralie | |
| Feb 10, 2017 at 20:36 | comment | added | M. Lanza | This approach works with one exception. A historic expense record may need to hold a reference to a now defunct department. New expense records should not see the department in the dropdown, but the historic records already pointing to it should. SharePoint doesn't handle this situation. | |
| Feb 17, 2014 at 16:16 | comment | added | lwbecker2 | I was looking into this solution for something I am doing, and it appears that if you have prior items that have been set with Active Depts, and then those Depts are marked as InActive (or Active = FALSE ) then the fields in the other list get replaced with "" after the fact. If that is the desired behavior then this solution works, if you would like to retain the original dept that was selected, this will approach will change that value and might not be what is desired depending on your requirements | |
| Nov 8, 2012 at 9:59 | comment | added | Mahendran Govender | Great solution! Saved us loads of time, and rework :D | |
| Oct 1, 2012 at 16:25 | review | Suggested edits | |||
| Oct 1, 2012 at 16:31 | |||||
| Jun 19, 2012 at 13:33 | vote | accept | noesgard | ||
| Aug 24, 2011 at 13:14 | comment | added | ronx | BTW - I had also tried the FilteredLookup codeplex solution that Ryan suggested. There was some push back from our architecture council because it was a 3rd party solution and we couldn't guarantee how easy it would be to migrate from 2007 to 2010. Granted, the codeplex solution is more flexible with it's cross-site lookup and CAML support. But if all you need to do is filter out the inactive values, my solution allows you to use native fields to accomplish this fairly easily without the need to install anything. | |
| Aug 24, 2011 at 13:03 | history | answered | ronx | CC BY-SA 3.0 |