Make changes to a list of things - 2 tables

alvin.david · 2024-08-30T12:14:00.703Z

Hi.
I need help.

Based on the quotation ID, I am trying to update a column (Invoice Link) in my invoice table.
I have another table called PDF documents, and there are 2 columns.
Quotation ID and PDF link.

Based on the Quotation ID in the invoice table and PDF documents table, I need it to pick up the PDF link in the PDF documents table and put it back at the invoice table based on their respective quotation IDs

I tried doing this but I failed.

image738×429 20.6 KB

image960×484 27.2 KB

Just to add on that my invoice table Invoice link has some blank cells and some cells have values in them.

Any help is greatly appreciated.
Thanks.
Alvin.

georgecollier · 2024-08-30T14:29:08.680Z

:first item instead of :each item.

Each item would return a list, but Invoice Link should just be one text (as surely there is only one Invoice Link per Invoice)

system · 2024-11-08T12:14:26.086Z

This topic was automatically closed after 70 days. New replies are no longer allowed.