I would like to create a a custom field that helps me to choose a customer from a drop down list. The information should be read from a google sheet column. Does Jira support this feature?
I create a ticket, click on the the drop down field customer and select/search for an existing customer that is listed in a google sheet. If that customer does not exist I enter the name of a customer and it is added to the google sheet.
I probably can add customer that do not exist with this addon at https://marketplace.atlassian.com/apps/1220382/jira-cloud-for-google-sheets-official?hosting=cloud&tab=overview ?
Ideally this would be refreshed every time I click on custom field.
Is there a way to display the google sheet column in the custom field?
Thanks for the read, best regards
Hi @mps , this functionality would only be possible with an add-on. Here's one that I have looked into in the past, where you can set up a list of custom field options to be pulled from an external data source - External Data for Jira Fields.
You can connect to this data source via several methods, including URL/REST, which I think would work for Google Sheets. Hope this helps!
Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...
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