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
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.