I need to create a picklist field, that will have an option to add values that are NOT in the original list. The values are coming from a SF form.
- If you add the new data today, it is inserted, and shown in reports - but it can NOT be selected in filters and/or bucket values.
- This option should also be available from the SF interface
I thought of having a text field, that if there is data there, it should be added to the picklist values, but I am not sure that it's the way.
For example: I have a picklist with name list: John, Jane, Jo
Someone needs to enter a new value: Boby
Boby will NOT be visible, even if I would like to change Boby to something else in the picklist field edit page, I will not see it.
I will need Boby to be added as a valid value.