Best answer

JIRA Summary field is not available to lookup

  • 19 April 2023
  • 5 replies
  • 93 views

Hi all,
Need your advise here.

I want to automate this sequence:

  1. create a JIRA issue from new Spreadsheet row. Text in that row will be JIRA summary (name).
  2. After JIRA link is generated, put that link back to the Spreadsheet: in the same row, but in another column.

For that purpose, I need to do Lookup search step. But the JIRA Summary field doesn’t show here in Lookup Value.

How do I make the JIRA summary field available? or is there a better method for this purpose?

Many thanks in advance for any advice or guidance!

icon

Best answer by jayeshkumarbhatia 19 April 2023, 04:27

View original

5 replies

Userlevel 6
Badge +6

Hey @Faww ,

 

You don't have to use Lookup action. You already get row Id from trigger event which you can use that to update the row.

hi @jayeshkumarbhatia thanks for answering.

From the RowID, I can only choose one row. meaning that If I create multiple new rows, it will be updated only into that 1 row always, which is not what I wanted.

I want the multiple links to be placed in correct rows. 

Am I doing something wrong? Please advise

 

Userlevel 6
Badge +6

The Zap will trigger for each row. If you add 50 Rows than the Zap will trigger for all 50 rows and respective Google Sheet rows will be updated. 

I see. thanks @jayeshkumarbhatia !

Userlevel 7
Badge +6

Hi @Faww,

Awesome! We’re glad to know that this is working now.

If you have any other questions, feel free to ask any additional questions by posting them in the Community. We’re always happy to help! 🤗

 

Reply