tableChoiceScript '-- None --' option

[Colleen]

I have added the tableChoiceScript attribute to the sys_email_canned_message.table field to generate a filtered list of tables for selection. The list of tables is being filtered, the only issue is that there is no longer a "--None --" option and the first table in the list is selected by default.  

We want to allow authorised users to create a quick message that is not linked to a table, so need a " -- None --" option. I have tried with no success:

• Selecting "Dropdown with -- None --" as the choice option on the sys_email_canned_message.table dictionary record.
• Inserting an empty string into the list of tables returned by the tableChoicesScript script.
• Setting the default value of sys_email_canned_message.table to "-- None --".
  This inserted a "-- None --" option but when the quick message was saved, in the table column of the quick messages list was "[label] -- None --"  .

Any ideas how to allow the quick message record to be saved without selecting a table when the tableChoicesScript attributed is used?

[Tanushree Maiti · Accepted solution]

Hi @Colleen 

Check the options given in these posts. Hope it will help you.

https://www.servicenow.com/community/developer-forum/table-list-filtered-with-tablechoicesscript-doe...

[Colleen]

Tiny error in referenced article. The attribute for the ' -- None --' option is "includeNone" (lower-case i), not "IncludeNone".

[GlideFather]

Hi @Colleen,

what you can try is to check the sys_dictionary for that field, particularly the Choice options:

https://yourinstance.service-now.com/nav_to.do?uri=sys_dictionary.do?sys_id=ee9eb6210c2032108bb2ce4d4ed10e6f

Eventually an onLoad script to make the field always empty if a new record