Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to import 2k+ values w/ parent/child relationship into lookup library using Forms or Jira field

Hi! I am building a client intake Form (app ProForma lite) plus using custom Jira fields in the portal UI. 

I have two questions:

1. The client would like a drop-down (lookup) field to house 2k+ values so they can search for the appropriate "cost" centers. My understanding is ProForma (paid version) might accomplish this through a data connection to an API? Is ProForma the best route for this type of setup? 

2. (A NICE TO HAVE) The client suggested having a list of managers (parent values) - that would then auto-populate the corresponding large cost center list (child values). And then another field where they would select their client or market, which would auto-populate a smaller cost center. Is this even possible? If so, how? 

Thank you!!

1 answer

1 accepted

2 votes
Answer accepted

Hi Trevor.

The first is possible, the second is possible, but depending on the number of managers and number of client/market it could be extremely tedious.

  1. The data connection that is in Proforma works great. You do need an api that returns the list of "cost centers" and you will need the proper authentication to that api (if needed). Once you create the connection, you can then add a select list field in proforma and tell it to use the data connection.
  2. You would have to have a data connection for each manager. You would need a data connection for each client/market. You would have to have a section and a select list for each manager and a section and select list for each client market...Again, this would be extremely tedious, but doable.

Thanks for the detailed information Garrett!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

251 views 1 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you