Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Filds don't show value

Pawel Barcik
Mega Guru

PawelBarcik_0-1702237495536.png

 

A regular table reference where it shows the name field which has two values concatenated
last_name and frist_name.
The field is set on the table to be displayed.

but despite this, the value from this field is not visible on the portal.

If I choose, for example, the last_name column to be displayed, I can see the values on the portal, but I want the "name" column to be visible. Because there I have these two values combined. From the table entry, the Name column has concatenated values, but I cannot display it through references on the form. Any idea ?

 

PawelBarcik_1-1702237572095.png

 

1 ACCEPTED SOLUTION

Pawel Barcik
Mega Guru

ok I found the solution,
data that was combined, if I grouped the list, it displayed empty fields. What I did was to combine the fields on the importing table and then I did a transform map to load the values into my table to have these fields filled.

View solution in original post

8 REPLIES 8

Mitsua
Tera Guru

Hello @Pawel Barcik 

 

Please keep type of this variable as lookup select box.  Select table as "sys_user" and Look up value field = "Name" .

 

Mitsua_0-1702289806691.png

 

Please mark this as correct answer/accepted and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

 

Thanks!

MS

my table is "cmdb_x_i" where I have made a "name" field which is a combination of last_name and frist_name from this table.
And the calculations for this field were the same as for the "name" field from the sys_user table and it works.
Only the value from the "name" table in my cmdb table is not displayed on the form

Pawel Barcik
Mega Guru

PawelBarcik_0-1702292721367.png

The filds "name" works good but on form when i creat referenc for table i have 

 

suprevisor i the referenc to the table cmdb_x_i when the fild "name" is displey 

PawelBarcik_1-1702292842205.png

 

Pawel Barcik
Mega Guru

ok I found the solution,
data that was combined, if I grouped the list, it displayed empty fields. What I did was to combine the fields on the importing table and then I did a transform map to load the values into my table to have these fields filled.