Auto-populate fields in Record Producer

[jevans]

Hello,

We currently have a very basic "Create a New Incident" record producer in our Service Catalog which asks for the user name of the individual, the category of the incident, and a description. The submitter is able to enter their user name or the user name of another person they are submitting the incident on behalf of. I'm trying to add other fields that will populate with information about the user such as their phone number and department from the sys_user table, but I can't seem to get it to work.

I searched for hours to find out how to do this with no luck, and made countless attempts. It seems like something that should be straightforward. Would anyone be able to tell me how to populate these fields once the user name is entered in the record producer?

TIA
-Joe

[Brandon R1]

Hi @w.bouwer,

I'm needing to do this same thing you were needing to do. I recognize this post is from 10 yrs ago but wanted to check if you were able to get this working the way you wanted and if so, can you share what exactly you did??

Thanks,

Brandon

[Priya151]

I have similar kind of requirement to add other fields that will populate with information about the user such as their phone number from the sys_user table. I tried to add below default value in the catalog variable to auto fill that variable on the form.

javascript:gs.getUser().getRecord().getValue('phone');

But If for any user the phone number column is empty in the sys_user table then its taking some other user phone number.

Can you please let me know how I can achieve this by adding a default value.

[Brandon R1]

Were you able to get this working?