Hi all,Need your advise here.I want to automate this sequence:create a JIRA issue from new Spreadsheet row. Text in that row will be JIRA summary (name). 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!

Best answer

JIRA Summary field is not available to lookup

Forum|Forum|2 years ago
April 19, 2023
5 replies
128 views

Faww
New

Hi all,
Need your advise here.

I want to automate this sequence:

create a JIRA issue from new Spreadsheet row. Text in that row will be JIRA summary (name).
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!

Best answer by jayeshkumarbhatia

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.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+7

jayeshkumarbhatia
Zapier Solution Partner
Forum|Forum|2 years ago
April 19, 2023

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.

Like

Faww
Author
New
Forum|Forum|2 years ago
April 19, 2023

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.