- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2022 07:29 AM - edited 10-19-2022 07:31 AM
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?
Solved! Go to Solution.
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2022 09:35 AM
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)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2022 08:16 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2022 08:30 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2022 09:35 AM
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)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2022 10:08 AM
Thank you so much for your help and for teaching me something new. 🙂