Table without a value to display

[mariavic1998]

Hi Eeveryone, I'm creating a catalog Item but I have a variable of type 'Reference' which table referenced does not have a display value, all the columns are set as 'false' on the display field, So when I make the reference in a variable of a catalog item it is being shown like this: 

it shows just the 'created date/time' field. I can't configure the table in oder to display a value for obvious reasons, so I wanted to know if there is a way of showing just the parents of the table with some script include or other option without having to change the displays values of the table. Thank you in advance.

[Anurag Tripathi · Accepted solution]

Well the most obvious solution here is to add a display value to the table. That is what you should look to do.

Alternatively you can use ref_ac_columns to show meaningful colums to search and select records, please see the link below

Auto-complete for reference fields (servicenow.com)

It should be something like 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department,ref_ac_order_by=department

This will still not solve the issue when you select a record, what do you see on the field,. you still will see the created date. Maybe add a Text field (read only) that you populate when a record is selected on this table and populate it with the meaning ful value of the record.

[Anurag Tripathi · Accepted solution]

Well the most obvious solution here is to add a display value to the table. That is what you should look to do.

Alternatively you can use ref_ac_columns to show meaningful colums to search and select records, please see the link below

Auto-complete for reference fields (servicenow.com)

It should be something like 

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=department,ref_ac_order_by=department

This will still not solve the issue when you select a record, what do you see on the field,. you still will see the created date. Maybe add a Text field (read only) that you populate when a record is selected on this table and populate it with the meaning ful value of the record.

[Dnyaneshwaree · Accepted solution]

Hello @mariavic1998 , 

Please refer the below article and make changes as per your req:
https://www.servicenow.com/community/developer-articles/display-multiple-column-values-in-reference-...

Please accept my solution if it works for you and thumps up to mark it as helpful.

Thank you!!