Automatically populate one variable on a Catalog item based on the value of another variable

[jfinn]

Hi,

I am currently working on a new catalog item to allow for users to submit requests for access to shared drives.   We have the drive information stored in a table called Storage File Shares (cmdb_ci_storagefileshares).   This includes the following information:

• Path
• Approver
• Read Access Group
• Write Access Group

On my catalog item, I have created two variables, one call 'Path' and the other called 'Approver'.   What I am looking to do is have the Approver value automatically update when I select a value in the 'Path' variable.

A basic view of what I am trying to do is below.   The table represents my storage file shares table which is extended off the cmdb_ci table.

Path	Approver
\\fileshare01\test	Tom Jones
\\fileshare01\HR	Mary Jones
\\fireshare02\newfolder	John Jones

If I select \\fileshare01\test in the 'Path' variable (reference field to the table above) on my catalog item when logging a new request, can the second variable then update with the approvers name, ie. Tom Jones?

I am pretty new to all of this and am looking to see if this can be easily done or if this will require more advanced scripting.   I have done some basic scripting recently within the application but am a newbie so to speak.

Any assistance or thoughts on this would be appreciated.

Cheers.

[BryanS413339635]

Just add an approver column to your table and map the approvers to the paths. Then you can do an onChange client script to populate the approver field when the path fields value changes.

[jfinn]

Hi Brian,

Yes, that was what I was thinking would be needed.   However, I have tried a couple of different scripts already but have been unable to pull through the information from the table.

Currently the table fields on my table are called:

Value	Field Name
Path	u_path
Approver	u_approver1

My variables on the catalog item are called:

Variable Value	Variable Name
Path	Path
Approver	Approver

Any ideas?

[BryanS413339635]

In the catalog client script, you would just set the Type to onChange, for variable name pick the variable for your path field. I think the script would look something like this:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

    function populateApprover(path) {

          g_form.setValue('Path', path.u_approver1);

    }

    if (newValue == '') {

          return;

    }

    var path = g_form.getReference('Path', populateApprover);

}

[jfinn]

Hi Bryan,

Sorry for misspelling your name in my previous post and many thanks for your help on this.   I have tried the code that you have suggested but it is still not working.

My variables are both set up as reference variables as I was manually entering the details initially but am looking to now auto-populate the data so wondering if this would have anything to do with why this is not working. I have tried changing this to a Single Line Text variable type but not working still.

The current variables are set up as follows:

Variable Value	Variable Name	Type	References table:	Display field on Reference Table
Path	Path	Reference	cmdb_ci_storage_fileshare	u_path
Approver	Approver	Single Line Text