Not able to see the choices I add to a drop down field on the form

[shruthi29]

Hi all,

I am facing an issue with the choices I add to a drop down field on the form.

I tried adding the fields in the following ways

        1.by right click on the field->dictionary->add choices.(I tried on list editor as well as on form).

        2.by right click on the field->configure choices-> add choices.

        3. by right click on the field->show choice list-> add choices.

When I save it, the choices disappear and they are not visible on the form as well.

But all the choices I added is visible in sys_choice table.

Kindly help me resolve this issue. Any help appreciated.

Thanks and Regards,

Shruthi

[paramveer · Accepted solution]

Hi Shruthi,

As i can see by screenshot Element name is "u_were_all_approvals_obtained_before_imp" while field name is "u_were_all_approvals_obtained_before_implementation". If you see the query condition in capture2, that is on ''u_were_all_approvals_obtained_before_implementation" while in choice list element is "u_were_all_approvals_obtained_before_imp".

Actually the problem is max length of "Element" field on Choice table is 40. that's why system automatically truncate the element value. To resolve the problem delete/deactivate the existing field and create the field again. while creating the field limit the name to lesser character(less then 40), like below :

Hope this will resolve your problem, in case of any assistance please let me know.

[partner_asha_a_]

Hi ,

I am also facing the same issue .I would like to introduce a sub state called "Decommissioning"under the state "In Use".I have added choice list "Decommissioning"

But the same is not coming in the dropdown

can u please let me know why it is not coming?

Thanks in advance!

[Dhanakoddi]

Hi,

The column label does not take more than 80 characters... 

But I have one requirement which exceeds 80 characters how I can include that in column label?

Any ideas you have please tell me!

Thanks!