Hello! I am getting the following error when I try and restrict the field of options a user can enter, and am unable to enter any new data. If anyone has experienced this please let me know if you have any tips on how to navigate this.
Try without the / character.
I’d say enclose the long text of the last value in double quotes “”. It seems that the part within parentheses is also discarded.
2 Likes
I think this error is happening because there is a long history of data entry where the title for that column has changed a few times, so it will complain as long as that column is marked to only allow the possible values. Does that sound possible? And if so, is there a solution where I can customize the drop down and search filters, possibly prevent users from adding new values, and also not require existing data to fit into those molds?
First, how about changing the data source once? Substituting similar/duplicate values with the new unified values.
In many occasions, when you are building an app, you have to “clean” the source first.