Auto-Populate a label instead of a value

IanH56261521172
Tera Contributor

Hi, all

 

Today, I am working with the "Auto-populate" tab while creating a variable. I am using this feature to reference a field on my sys_user table, User Type. This is working as intended, with one exception. When the field is auto-populated on my catalog item, it is displaying the value of the called item rather than the label. What I need visible to the end user is the label. Is there a way to alter which of these is called? 

1 REPLY 1

J Siva
Tera Sage

Hi @IanH56261521172 
This is the expected behavior. I suspect that the User Type variable is a single-line text type variable, which is why it shows the value instead of the label. To resolve this, change the type of the variable to "Select box" and create dropdown values with the same values and labels from the sys_user table's User Type field.

Catalog variable:

JSiva_0-1745291178328.pngJSiva_1-1745291199624.png

Actual field from sys_user table:

JSiva_2-1745291262502.png

JSiva_3-1745291290131.png

Output:

JSiva_4-1745291327046.png

Hope this helps.
Regards,
Siva