Issue with Populating 'Customer' Field from Reference Table in ServiceNow

NikhithaNikki
Tera Contributor

I am experiencing an issue with a select box field named "customer" in ServiceNow. The field has the following choices and backend values:

  • Very Low (1)
  • Low (2)
  • Moderate (3)
  • High (4)
  • Very High (5)

This field is populated from the cmdb_ci_business_app table using dot-walking. When I select "existing digital platform," the customer field should be populated from the table. However, if the customer value is empty (none), it should display as "None" or remain empty in the form. Currently, it is showing as '0'.

Could you please help me understand why this is happening and how to fix it?

Thank you!

14 REPLIES 14

GlideFather
Tera Patron

Hi @NikhithaNikki,

is this somehow different from the previous question:
https://www.servicenow.com/community/developer-forum/issue-with-populating-customer-field-from-refer...

Or is it the same? Please mark one of these as Accepted to close it and let just one in the Forum for better solution, as currently with the duplicity it will shatter the focus from people who are willing to help and they might have cooperated in one thread instead of get lost in two... 

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


Yes same question, as you suggested I have tried using default value as none in the cutomer variable but it still showing me as 0 when value is not there.

Then please close this and let's continue in the previously open, not to lose the flow

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


mayankkumar
Tera Sage

Hi @NikhithaNikki,
------------------------------------------------------------------------------------
Could you please check Default value of "Customer" field in the Dictionary.
and let me know if it resolved or not.
---------------------------------------------------------------------------------------------------
Please Mark my Response Helpful and Accept as solution.
Thanks & Regards
Mayank