Dynamic field

[thomas_esquieu]

Hello,

We have JIRA for the Cloud. I would like to know if it's possible to have dynamic fields in a form linked to a database (e.g., Excel).

I have a list of customers with their ID, first name, last name, and phone number (a custom field is also created in Jira for each piece of information). From the form, I would like to select the ID field from a drop-down list so that the other information automatically populates the other fields.

Thank you.

[Aaron Geister _Trundl_]

@thomas_esquieu 

Welcome to the community and I hope this reply finds you well. 

There are a few ways to do this so I will outline that here:

• Atlassian add-on from Marketplace
• Using JSM premium to take advantage of Assets which can be used across products
• Using JSM Forms to use dynamic fields and sections
• You could right an API automation to your excel sheet
  
  I would recommend using assets for this as this type of situation. You can store each attribute in Jira and then have it be pulled to populate the data with the customer. Then use automation to populate the other fields.