Jul 25, 2018 07:23 AM
I have a very basic single select field. When I copy and paste data from a csv file the field creates a new option even though the option is already there and matches the pasted data.
For example, “Active” is a single select option. When I past the word “Active” in the field it creates a new single select option.
There are 3 other fields where this is not happening- same data, same steps…
Jul 25, 2018 10:15 AM
Did you check for white spaces in the options?
I mean check if one is “Active” and the other one " Active" or "Active ".
It is not logical to work with some fields and do not for others.
Rgds
Jul 25, 2018 12:23 PM
Makes sense…I’ll run this by the VBA coder…I bet he has an extra space in there somewhere!..it works off a larger coded document and there is logic that populates the cell…
Thank you! @Luiggi_Cuozzo
Jul 25, 2018 12:24 PM
Of course there are spaces :grinning_face_with_sweat:
Jul 26, 2018 12:43 PM
Good looking out! Got it fixed.