I'm a new catalog manager and am trying to build an access request form. We've got a little under 30 tools, with just under 200 different levels of permission. Some of these permissions have restrictions based on the team to which the user belongs. I built a custom table that contains among other things, the fields u_tool, u_permission, u_restriction (which is a reference lookup to the Services table), and u_notes. All permissions are associated with a tool, but only some of them are restricted to specific teams. The others should be selectable by anyone.
I have a catalog item where the requester identifies to which team they belong (u_team). My goal is to use an MRVS to present them only with the valid options (global or team-restricted) from which they can select the access they want/need. They select the tool and permission, and there is a look up to see if there are any notes associated asking for additional information.
Based on a bunch of googling and Community reading, I seemed to need a Script Include to pass the variable (u_team) from the catalog item to the MRVS and a Catalog Client Script to populate a single-line text field (u_lookup) in the MRVS with the sys ID of the restriction. The other fields in the MRVS are lookups to my backend table: u_tool, u_permission, and u_notes. I added a Reference qualifier on my u_permission field in the MRVS of javascript:'u_tool=' + current.variables.tool + '^u_restriction=' + current.variables.lookup + '^ORu_restrictionISEMPTY';
I did get the above to work, though do not like how it displays the MRVS grid in the catalog item. The documentation I'm finding all seems out-dated, so I'm hoping there's something new available. Can I 1/ hide the team from the MRVS grid (it's already hidden in the modal), and 2/ if it can't be hidden, is there a way to change it from the Sys ID to an acronym field on the Service that is being looked up?
Also, is there a way to make the Notes field wider in the grid? Right now, everything is squished due to the Sys ID. TYA!
#catalog #request #mvrs
