I have a simple Zapier table with two fields
- Tax code name
- Tax code value
I have a Zap that converts invoices from InvoiceNinja to Quickbooks.
InvoiceNinja outputs a tax code name (GST, GST Free, Out of Scope) and Quickbooks needs the corresponding tax code value.
As thes invoices have multiple line items I need to lookup the line items. There is a guide here that says it can be done however I am unable to see the images:
https://community.zapier.com/featured-articles-65/don-t-be-afraid-of-the-lookup-table-6373
So far I have used a Formatter to create the line items and now I need to lookup the table for the correct values.
The Table tool has a search function but it only accepts a single value so cannot be used as the source is an array of tax codes.
The Formatter tool allows an array of values to be inputted however I cannot see how to select the output field.
When I run this the outputted data is the row numbers as I have not specified the output field anywhere?