+ Start a Discussion
ltcommanderltcommander 

New custom picklist with unique values in that field

Hi guys
Here's what I want to accomplish.

1) Create a new text field (dropdown list) under Contact
2) Have the items in the dropdown list appear from past data in that field

Assuming a user enters "hello" and saves the contact record then in the future another user will be able to see 'hello' in the drop down list.

Reason is that we want to add a field called "Team" and different users spell the contents differently and is they were to see what another user has typed previously and choose from that then the data will be more conistent. We do not want to predefine values in the picklist because they can't be predetermined that way. Only thing I can think of is to dynamically keep adding to the picklist so it achieves the above but it would look best if it appears like a Google Search textbox with previous values automatically showing like an "autofill".

Hope this makes sense!! I am most familar with Perl so any suggestion in perl would be great!

Thank you very much!!