Add multiple rows into another table with bots

AppSheet AppSheet Q&A
, ,
1

Hey all,

I have 4 tables:
Quote: QuoteID / Date / Accepted
QuoteDetails: QuoteDetailsID / QuoteID / Job / Qty / Price
Invoice: InvoiceID / QuoteID / JobInvoiceNumber / Date
InvoiceDetails: InvoiceDetailsID / InvoiceID / QuoteDetailsID / Progress

I would like to do is:
IF JobInvoiceNumber = 1 then copy / paste all QuoteDetailsID where QuoteDetails[QuoteID]=Invoice[QuoteID] to InvoiceDetails[QuoteDetailsID]

So far i have set up a bot to do this, but i get stuck in the Process tab. I have gone for Run data action / Add new rows
And, for the InvoiceDetails[QuoteDetailsID], i put: SELECT(DetailDEVIS[DetailDevisID],[DevisID]=[_THISROW].[DevisID]) which is a list…

Any thoughts?

Thanks.

Matt

2

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?filter=location&q=@steve%20faq%20rows&location=category:appsheet-tips-resources&collapse_discussion=true

3

Search - Google Cloud Community

1 Like