Choice field on a table showing duplicate values

[srimanta sahoo1]

HI 

I have a business application table and the field architecture type field showing duplicate values.

Any idea why it is generating duplicate values and how to solve it. The duplicate value showing in Blue color.

There is no default value given for the choice field.

Thanks,

Srimant

[Robbie]

Hi @srimanta sahoo1,

So this could be happening due to a script or similar setting the value via code (and not via the User Interface).

If there are business rules or scripts that are triggered and the values are set incorrectly, the same situation will arise.

Can you check Business Rules, Script Includes etc (Including Workflows - it all depends what's configured in your instance) for where this value maybe set.

To help others (and for me to gain recognition for my efforts), please mark this response correct by clicking on Accept as Solution and/or Kudos.




Thanks, Robbie

[srimanta sahoo1]

Hi 

Yes might be. Let me check and revert.

[srimanta sahoo1]

Hi

Its happening for old and new records. Once you select the 3rd option "Platform Host"(which is the correct one) and save it, then the last duplicate value disappears.

I am not sure how it is getting generated for some options.

Thanks,

Srimant

[Dr Atul G- LNG]

Hi @srimanta sahoo1 

@Robbie mentioned same, the value has been changed and do this issue will be there. If you can compare it with other environment do that or delete the duplicate entry by going in dictionary entry. 

[Robbie]

Hi @srimanta sahoo1, Did you see my earlier response?

Whenever you see a value displayed in blue, this typically means the field was initially given a value and after saving the record, the choice value was deleted or changed.

The original invalid/missing choice value is then displayed in blue . This is expected behavior.

To rectify, save the record with the correct/new (non blue) value and you will no longer see the duplicate (blue) value.

To help others (and for me to gain recognition for my efforts), please mark this response correct by clicking on Accept as Solution and/or Kudos.




Thanks, Robbie

[Robbie]

Hi @srimanta sahoo1, Did you see my earlier response?

Whenever you see a value displayed in blue, this typically means the field was initially given a value and after saving the record, the choice value was deleted or changed.

The original invalid/missing choice value is then displayed in blue . This is expected behavior.

To rectify, save the record with the correct/new (non blue) value and you will no longer see the duplicate (blue) value.

To help others (and for me to gain recognition for my efforts), please mark this response correct by clicking on Accept as Solution and/or Kudos.




Thanks, Robbie