Auto Populate Fields in an Order Guide (Slight Twist)

[amacqueen]

I know that very similar questions have been posted before but I can't find a solution to my particular circumstances. 

I have an order guide which does have a requestor variable on it and if I wanted to auto populate other variables based on that I would be fine.

However I want to use another variable as the basis for the auto poulation, that variable is of type email and is called '****_apex_upn_use_email_address', I need to be able to drag information such as first name, last name, location, country code etc from the user record that has the email address provided but right now I can't.

So can I for example replace the text in blue in the following default value to do this?

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

Any help would be much appreciated.

Thanks

[amacqueen · Accepted solution]

I found it out myself thanks to this article from @Mark Roethof https://community.servicenow.com/community?id=community_article&sys_id=49deac8ddb92a010ab0202d5ca961967 Using Catalog Data Lookup Definitions