Set a field in a JSM form to the same asset object as selected in another field in the form

[Fabian Schubert]

Hi community people!

This is what I want to achieve:

In a JSM form the user filling in this form must select the name of a person (from Assets). Based on this selection the mobile phone number of the person (from Assets) is displayed automatically in another field in the JSM form (from Assets).

This is what I have configured:

Assets:

Schema: People

ObjectType: People

Attributes:

• Name (label) -- contains full name, e. g. John Doe
• User name -- contains e-mail / unique
• Mobile -- contains mobile phone number, e. g. +49 123 456789 

To select the name the JSM form has a field "Name" (type is "Asset Objects"),
which is linked to a Jira field (type is "Asset Object")
with this configuration:

(customfield_16896)

• Object schema: People
• Filter scope (AQL): objectType = People
• Filter work item scope (AQL): None
• Allow search filtering by these attributes: Name, User name
• Object attributes to display on work item view: Name, User name
• Object attributes to display on customer portal request details view: Name, User name

--> This works fine and the user of the JSM form can select the name of the person from Assets.

To automatically display the mobile phone number the JSM form has a field "Mobile phone numer" (type is "Asset Objects"),
which is linked to a Jira field (type is "Asset Object")
with this configuration:

• Object schema: People
• Filter scope (AQL): objectType = People
• Filter work item scope (AQL): Name = ${customfield_16896.label}
• Allow search filtering by these attributes: Mobile
• Object attributes to display on work item view: Mobile
• Object attributes to display on customer portal request details view: Mobile

--> This field does not automatically show the mobile phone number after a person is selected. Only when the user actively uses the field, the mobile phone number becomes visible and only the mobile phone number of the selected person can be selected.

How can I make the mobile phone number visible automatically without any user interaction necessary?

[Mikael Sandberg · Accepted solution]

Hi @Fabian Schubert,

Welcome to Atlassian Community!

The short answer is that you can't do this without user interaction with the field on the form. 

[Fabian Schubert]

@Mikael Sandberg Thanks for your quick answer! That is not what I hoped to hear of course ;-) I guess it only works "automatic" if the mobile phone number would be a related object, right?

[Mikael Sandberg]

No, it has nothing to do with the attribute, the issue is that there is nothing in the form that can be done to do an automatic refresh once the user picks the object in the other field, this only happens when the user interacts with the field.

[Fabian Schubert]

I am asking, because in another JSM form I was able to create this:

The value of the laptop field appears automatically as soon as a name is selected (and changes automatically if a different name is selected).

[Fabian Schubert]

Name from Schema: People / Objecttype: People / Attribute: Name

Laptop from Schema: Assets / ObjectType: Laptops / Attribute: Owner --reference to--> People

[Alan Bruce]

Couldn't you add the Mobile phone number attribute to the User Object as a reference and then display it on the form with the User field?

Object attributes to display on customer portal request details view: Name, User name, Mobile

Then you could use Automation after the ticket is created to update the field?

Just a thought.

[Christopher Yen]

Hi @Fabian Schubert ,

The closest solution I've seen to this from the customer portal is the user would submit the form and then you can automatically return the phone number of the linked people object into a field/email/comments for the reporter and auto resolve the work item.

We do this for users who want to see what IT assets are assigned to them in our CMDB.

[Fabian Schubert]

@Christopher Yen Yes, I had the same thought and have now solved it "outside" of the JSM form.

We use this form for people leaving the company to ask the manager what IT has to do with a view to (among other things) the mobile phone of the leaving employee.

I looked up the value for mobile phone now from Assets beforehand, set it to a Jira field and pre-filled the form with this value so the manager will see the mobile phone number right away in the form.