Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-349

Better display when selecting "sub-rows" in Google Sheets

    XMLWordPrintable

    Details

    • Feedback Policy:

      Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Description

      Summary

      When using the Google Sheets integration, there are some fields that contain "sub-rows" to be selected.
      For example, Sprint, Linked issues:

      The values in the main field are static, meaning that they don't change based on the selections. The result might be misleading for users since there will be duplicate rows.

      For example, when it comes to linked issues, if you select Linked Issues.linkType along with the main field Linked Issues, you will see multiple rows of the same issue because the integration needs to show a row for each link type corresponding to each linked issue. But since the Linked Issues value is static, it will show all linked issues in the same cell in all rows, despite those being associated with the link type displayed in the row or not:

      PS. In the case above, you should go for Linked Issues.id instead of the main Linked Issues field to have a more accurate result.

      Suggestion

      Make the main fields' column results adapt to the sub-rows selected. Or, give more configuration options to users so they can choose the behaviour.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            lalmeida@atlassian.com Leonardo De Almeida
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: