MRVS does not save auto-populate value when Add button clicked

[Tim Sanders]

Hey all,

I'm having an issue with a Multi Row Variable Sets (MRVS) and the Auto-Populate function.

I have an MRVS that captures the Device Name and the Assigned To of that device.  The Device Name variable is a Reference to the Computer [cmdb_ci_computer] table (please see image labeled "device-name").  It contains Variable Attributes to display information about the device.  You might notice that I did not include the Assigned To in the list of columns.  This is because, sometimes, the name of the assigned staff is inaccurate.  However, I do want to pull the name of the assigned staff if it is available to the record and populate it in a different variable called Staff Name.

The Staff Name variable is a Reference to the User [sys_user] table (please see image labeled "staff-name-1").  The Auto-Populate field of the Staff Name variable is dependent upon the Device Name variable and pulls from the Assigned To Name variable (please see image labeled "staff-name-2").  This does work to populate the MRVS popup window (please see image labeled add-row-auto-pop").  However, when the client clicks the Add button, the MRVS does not input the name of the Assigned To into the Staff Name field on the Catalog Item (please see image labeled "missing-staff-name").  In order for the name to actually populate the MRVS in the Catalog Item, the client has to select the Staff Name variable and search for and select the staff's name (please see "manually-search-assigned-to-name").

Has anyone else experienced this issue with MRVS and Auto-Populate?  I do not have this issue when using other variables.

[jcmings · Accepted solution]

I am wondering if your auto-population is pulling in the user's display name and not actually passing the sys_id through (thus resulting in an empty field, since Staff Name expects a sys_id). When you manually search and select, the sys_id is being captured. In staff-name-2, can you change it from "Assigned to Name" to just "Assigned to"?

[Tim Sanders]

Thanks @jcmings !  Such a simple solution and I didn't think to do it, but that did work!

[jcmings]

No problem 😀 sometimes it just takes another set of eyes!