Need help with reference qualifier

vidhya_mouli
Giga Sage

I have a table u_employment. I am creating a catalog item based on this table. I have two variables employee name and employment. Based on certain conditions I am choosing employment value. 

 

Reference qualifier: 

javascript: 'u_employee='+current.variables.employee.sys_id + '^u_active=trueORu_start_dateRELATIVELT@month@ahead@1'

 

This works as expected and returns the employee_id. However, I want to return employment_number. Is it possible?

4 REPLIES 4

pyella
Tera Expert

To get the number you need to have a number field on the table either custom created or the ootb created field

I have this field in the table already. Not sure how to display this field.

Yes it is possible to display the number what exactly you are looking for how to show the field on the form or how to populate the number in that field?

When I chose the Employement, Employment ID is displayed. But I want employment_name to be displayed.

 

 

 

Screenshot 2024-03-04 12.58.28 PM (1).png