Extract common data field from multiple forms under single Jira ID

[Ellie Ellis]

Hey,

I want to find a way to extract a single field from a form which Agents can add in to existing Jira tickets. 

The form is being used to log and record licenses for images which are licensed to use against the asset which the Jira ticket relates to. 

I can't use a linked Jira field because it's possible that there will be multiple images purchased, and therefore multiple copies of the form.

Ultimately, I want users to be able to search from the list of image ID's logged through the system to see if an image has previously been licensed. 

I wondered if I could automate a workflow whereby image ID's were automatically converted into tickets in a separate project but wondered if there was a more elegant solution?

Any thoughts appreciated!

Ellie

[Jack Brickey]

Hi @Ellie Ellis , if you are referring to JSM Forms, at this time you cannot access/query or use in Automation Form fields. if I am misunderstanding your question I apologize. Feel free to elaborate.

[Ellie Ellis]

Thanks Jack - yes, I mean form fields. 

I could add the option to list multiple image ID's on a single form and create associated Jira fields for each of them? I think the most licenses we've had per ticket is 11. Feels bit long-winded. Is there a cleaner way to gather data from within an existing ticket?

[Jack Brickey]

So I don't fully understand your use case. Could you restate the following?

I want users to be able to search from the list of image ID's logged through the system to see if an image has previously been licensed. 

what are "image IDs" and how or is that data entered? Maybe you mean the name of an attached image file? If so there is not a native means of querying for attachment name via JQL but there are addon options.

[Ellie Ellis]

Not at all - this is my first time using the Community so need to learn how to form effective problem statements:

Below is a grab showing what I mean. The JSM instance is used to request marketing assets. The Form is used to record where we have licensed an image for the asset. Each form currently requires a unique Image ID - you'll note this ticket has 3 images licensed for this asset. I want to collate all the Image ID's recorded using this form and put them somewhere searchable. 

[Ellie Ellis]

I don't suppose there is a way to automate the form data download, and post the relevant fields to Confluence? That would be cool...