Populating one variable based on another variable on a form

[Diana27]

Hi,

I have 2 variables in a variable set that I am using on a form.  The first variable is requested_for using the type Requested For:

I have another variable manager.

All I need to do is populate that variable (manager) with the manager of the user in Requested For.  This should be easy, however it is taking all day and I still cannot get it to work.  I'm about to go insane.

Thanks in advance for any assistance.

Diana

[Diana27]

Thanks, do I also set the table and field in the script form to sys_user and manager?

[Tom Sienkiewicz · Accepted solution]

no... you need to create a catalog client script, not the regular client script. Instead of table, field you select variable set, variable. it should look more or less like this:

[Diana27]

Thank you, thank you, thank you.  I cannot believe how complicated this system is.  This is so easy on our current system.  The fact that what you need is not contained in one area or menu makes it so complicated.

[Tom Sienkiewicz]

No problem 😉 It is vast, but I would not say very complicated. Matter of experience I guess. Good place to start is here - e.g. for the getReference method: https://developer.servicenow.com/dev.do#!/reference/api/paris/client/c_GlideFormAPI#r_GlideFormGetRe...