Vlookup equivalent function

[Arden Whittleton]

Hello, I'm trying to build in some automated functionality to our new user onboarding ticket where the type of hardware will auto fill based on the role of the user.  has anyone tried this?

[Trudy Claspill]

Hello @Arden Whittleton 

Welcome to the Atlassian community.

Where is the user role information in this scenario? Is it a selection list field in the form or issue?

Where is the full set of hardware options coming from in this scenario?

How are the hardware options associated to roles?

Can a role include more than one hardware option?

My first thought is to leverage the native Assets functionality to define Roles as asset objects and Hardware as asset objects and then use Asset Object custom fields in the issue to select the values. You can create relationships between asset objects and configure the Asset Object field for Hardware so that only the hardware associated with the selected Role becomes available.

[Trudy Claspill]

Alternately, if you don't want the user (or agent) to actually choose the hardware, you could create an Automation Rule that includes a Lookup Table action to create a table of key/value pairs where the keys are Roles and the Values are hardware.

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Create-lookup-table

Set the rule to be triggered by issue creation. Read the information in the Role field. Use the lookup table to find the corresponding hardware. Put that value into the Hardware field in the issue.