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
4,361,817
Community Members
 
Community Events
168
Community Groups

Is there any way to pull data from inside custom forms and export to google sheets?

I've been using Jira cloud for sheets for some time, organizing my sheets by filters and such. I've come across a board with custom forms dedicated to organizing test data but I cannot seem to pull the data from inside the fields into a sheet, the only fields that are close to them are counts of submitted forms and the like. If I could pull the separate fields contained in these custom forms into separate columns that would be super helpful for organizing metrics surrounding these data points. Any help would be appreciated! 

1 answer

1 accepted

0 votes
Answer accepted

@Harold Clark -

Welcome to the community.  If you are referring to "FORM" component in JSM, then it may not be possible.  However if the "FORM" setup where its elements are mapped to actual JSM issue fields, then you will be able to export the issues with those JSM issue fields to google sheets.

FORM setup/configuration is using the component (formally known as Proforma add-on, but now it is a part of JSM Cloud subscription) which its elements live within the FORM object only if it is not mapped to actual JSM issue field.  The FORM is treated as attachment(s) to the JSM issues by designed, thus it is treated separately.

Hope this helps if I understood your ask correctly.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

This does answer it, thanks so much!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Service Management

An unofficial way to monitor a JSM mail handler for errors

...eturns true if any content is returned for the webResponse.body.data.first s...

718 views 3 20
Read article

Atlassian Community Events