I’ve successfully created a Zap to Create a Receipt in QB from a New Record in Airtable, but I can’t figure out how to populate the “Payment Method” in QB (several options such as Cash, Check, Billpay, etc.) even though I have the identical information in a field in Airtable. When I select the field in AT to populate the field in the new QB record, it doesn’t recognize it and leaves the “Payment Method” blank. I’m wondering if I have to use the “Payment Method Codes” that are in QB instead of the “text” coming from Airtable. Any suggestions?
UPDATE - SOLVED: Probably not the ideal solution, but as a workaround, I created a formula field in Airtable to change the “Method of Payment” (text) in AT to the corresponding (Payment Method” code (numeric) in QB. I then matched that new code field to the “Payment Method” field in the QB action in the ZAP and that worked.
Best answer by nicksimardView original