Choice values are appearing twice

[amaradiswamy]

Hi All,

We have a dopdown field called "type" in a "devices" table. Under devices table we have created 3 child tables laptops and desktops. we have added 10 choice field values to the parent table(in sys_choice table table is u_devices and element is u_type) but surprisingly in the dropdown it is showing each choice value twice(totally it is showing 20 choices). And one more problem is that when i am trying to create a laptop then in this field no choice values are shown, only for desktops only i can see the choices(each value twice).

Please help and advice on this.

Thanks and Regards,

Swamy

[reeba]

Hello Anurag,

i came across this old post, but can you tell me what does it mean if the value is showing up in blue? i have a dropdown field and one of the values shows two times when it is selected and saved and one of them shows up in blue colour.

Regards,

Reeba

[shilpsrn]

Hi Reeba,

Did you get any response, reg the duplicate values showing in blue.

Regards,

Shilpa

[Sumanth16]

Hi @reeba ,

The issue is that the value passed in the Client Script was the Field's Label rather than the Value. This caused a perceived duplicate choice.

Resolution

For example, replace all occurrences of

g_form.setValue("time_constraint","Start on specific date");

with

g_form.setValue("time_constraint","start_on");

as the value of the choice is actually 'start_on' (while 'Start on specific date' is just the label).

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[shilpsrn]

Hi Anurag,

I'm facing the same issue, there are duplicates in choice field and one of the duplicate value is showing up in blue. Can you please help me to identify the issue and how do we solve it?

Regards,

Shilpa

[amaradiswamy]

@shilpsrnThe choice will have two values one is labela nd another is value, the database stores the field value with the value of choice not the label of the choice. for example, "Request Help" is the choice label and choice value is "request_help" then database stores the value of this field as "request_help". so, now if the choice value is changed as "request help" in sys_choice table then system couldn't match and shows the value in blue color. 

To fix the issue update the choice manually by checking the choice value of the field, you can check by navigating to the record and show xml for the record.