Uploaded image for project: 'Automation for Cloud'
  1. Automation for Cloud
  2. AUTO-736

Improve "Create Lookup Table" action - allow lookup table keys to populate multi fields when the value is comma-separated

XMLWordPrintable

    • 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.

    • Jira Software

      Suggestions

      • It would be very beneficial to read a CSV file to dynamically import the CSV data to a lookup table. A possible manual way to import data from a CSV to a lookup table in Jira Cloud Automation would also help with this process.
      • As a user, I would like to be able to include multiple values separated by a comma in a single key of the lookup table to populate an array field type.

      For example:

      When creating a lookup table like the following example:
      MultiUser

      key value
      user user@email.com, user2@email.com

      I would like to use smartvalue

      {{MultiUser.get("user")}}

      And as a result, populate a multi-user picker accordingly with values user@email and user2@email.

            [AUTO-736] Improve "Create Lookup Table" action - allow lookup table keys to populate multi fields when the value is comma-separated

            Miles Hayler added a comment -

            I have a 100 line spreadsheet I have to manually recreate in a lookup table. Should be fun. Even basic CSV importing would be such a huge help.

            Miles Hayler added a comment - I have a 100 line spreadsheet I have to manually recreate in a lookup table. Should be fun. Even basic CSV importing would be such a huge help.
            Charlie Gavey made changes -
            Link New: This issue is duplicated by AUTO-840 [ AUTO-840 ]
            Charlie Gavey made changes -
            Description Original: As a user, I would like to be able to include multiple values separated by a comma in a single key of the lookup table to populate an array field type.

            For example:

            When creating a lookup table like the following example:
            MultiUser
            |key|value|
            |user|user@email.com, user2@email.com|

            I would like to use smartvalue
            {code:java}
            {{MultiUser.get("user")}}{code}
            And as a result, populate a multi-user picker accordingly with values user@email and user2@email.             		New: h3. Suggestions
             * It would be very beneficial to read a CSV file to dynamically import the CSV data to a lookup table. A possible manual way to import data from a CSV to a lookup table in Jira Cloud Automation would also help with this process.
             * As a user, I would like to be able to include multiple values separated by a comma in a single key of the lookup table to populate an array field type.

            For example:

            When creating a lookup table like the following example:
            MultiUser
            |key|value|
            |user|user@email.com, user2@email.com|

            I would like to use smartvalue
            {code:java}
            {{MultiUser.get("user")}}{code}
            And as a result, populate a multi-user picker accordingly with values user@email and user2@email.
            Vipul Reddy made changes -
            Labels New: jsw-s13
            Raf (Inactive) made changes -
            Link New: This issue is related to AUTO-743 [ AUTO-743 ]

            Jordan McCombs added a comment -

            Love the idea of the lookup table as it makes my long, ~50 action long automations easier to manage. Still missing a big piece of functionality, the ability to fill in a multi-select field with comma separated values. Without that, we lose alot of potential functionality. 

             

            Jordan McCombs added a comment - Love the idea of the lookup table as it makes my long, ~50 action long automations easier to manage. Still missing a big piece of functionality, the ability to fill in a multi-select field with comma separated values. Without that, we lose alot of potential functionality.   
            Charlie Gavey made changes -
            Summary Original: Allow lookup table keys to populate multi fields when the value is comma-separated New: Improve "Create Lookup Table" action - allow lookup table keys to populate multi fields when the value is comma-separated
            Raf (Inactive) made changes -
            Summary Original: Allow lookup table elements to populate multi fields. New: Allow lookup table keys to populate multi fields when the value is comma-separated
            Raf (Inactive) created issue -

              Unassigned Unassigned
              19d5cab36386 Raf (Inactive)
              Votes:
              31 Vote for this issue
              Watchers:
              14 Start watching this issue

                Created:
                Updated: