How to remove choice option from Record Producer

jaubert
Tera Guru

I set two category choices as inactive on my custom table.  When I use the record producer form, those choices are still visible.  How do I set them as inactive on my record producer?

1 ACCEPTED SOLUTION

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

That is because even though the options are inactive they are probably used in some of the records so it is showing in the varibale.

 

Do one thing change the lookup table to sys_choice instead (I am takin the esample of Incident table and category field Please adjust according to your custom table) 

 

Saurav11_0-1666197247716.png

 

Then in the reference qualifier add the below(again adjust the table and field name)

 

javascript:'nameSTARTSWITHincident^name=incident^element=category^language=en^inactive=false';

 

Please mark answer as correct based on Impact.

View solution in original post

8 REPLIES 8

Gontla Mythily
Tera Expert

Hi,

 

Go to choice list and make inactive true of that choice.

For me option has inactivated both on incident form and record producer as well.

 

Mark as correct if it helps
Regards Mythily

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

Are the choices created as a variable with separate choices is it a lookup to the category field?

 

If it has separate choices then you have to make it inactive from the variable.

 

Pease mark my answer as correct based on Impact.

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

That is because even though the options are inactive they are probably used in some of the records so it is showing in the varibale.

 

Do one thing change the lookup table to sys_choice instead (I am takin the esample of Incident table and category field Please adjust according to your custom table) 

 

Saurav11_0-1666197247716.png

 

Then in the reference qualifier add the below(again adjust the table and field name)

 

javascript:'nameSTARTSWITHincident^name=incident^element=category^language=en^inactive=false';

 

Please mark answer as correct based on Impact.

Thank you so much for your help and for teaching me something new. 🙂