in general I do like the lookup column, but I think sometime (especially with over 100 items in the lookup) its not that convenient.
In my lookup there are 300 items (title of the items from the same list). The user should pick similar items.
Any ideas how to realize one of my ideas or other ideas would help me a lot!
Ideas how to improve the convenience:
- I want to have a 'search option' on top of the lookup
- I want the 'text box' to be larger, because at the moment the user is not even able to view the whole title (because the column is too small)
- filter the lookup so that users only see items where some columns are similar
I just read that you can filter the lookup with calculated columns.. but I haven't figured out a way that this helps me with my problem..
Thank you guys!