How to set up record producer field to auto-populate information based on selection in a lookup selection box

[Rosie2]

Hi Community.  I'm a newbie Sys Admin and no scripting experience but very interested in learning. I have a project to create a record producer where I need to set up certain fields to auto-populate with information from the User table when a User is selected in a lookup select box.  Any suggestion on setup is greatly appreciated. 

An example is when I select John Smith in the lookup select box, I would like the other field to populate with his Title.  

[Rosie2]

Hi Abdul,

Thank you so much for your help in advance.  I'm very new to all this so if reference field is better instead of lookup I will try that. 🙂 The lookup/reference variable is called "full_name" which references the User table.

Best,

Rosie

[Akshay Patil3]

Hello Abdul,

I am using the same but in record producer I am using list collector variable. How to achieve this for if we select multiple users from slush-bucket then how to populate the job title for them??

Thank you in Advance

[Rosie2]

Hi Abdul,

Thank you so much for your help in advance.  I'm very new to all this so if reference field is better instead of lookup I will try that. 🙂 The lookup/reference variable is called "full_name" which references the User table.

Best,

Rosie

[Kailash Bhange]

Hi

Not Sure if this is relevant, but for sure it can help you!

[SOLVED]: - Dependent variable on Catalog item using Lookup Select Box

https://community.servicenow.com/community?id=community_article&sys_id=1ce7dceedb5914101cd8a345ca961...

If my answer resolves your issue, please mark my answer as ✅ Correct & ????Helpful based on the validations.

Thank You!
Regards,
Kailash

[Rosie2]

Hi Kailash,

Thank you so much for your suggestion. Still trying to figure this out. I'm only referencing one table, User.  I'm trying to follow your example at the bottom and trying to understand the details and plugging in the info but it's not working.  This is what I have so far.  Please let me know what I'm doing wrong.

Thank you so much!