I have a column with single select option. Based on the option selected in Single select, I need a particular formula to be used to make calculations in the next column. There are around 10 options in the single select and 10 formulae corresponding t...
Hi, I’m trying to automate creating an invoice on Quickbooks Online by a button press on Airtable through Integromat. While I’m successful in creating an invoice, the invoice is created for a Customer in Quickbooks. However, I want the invoice to be ...
Thank you for the response, Scott. I did try nested if and switch functions but I thought there must be a better way to achieve this. I have too many variables at play and want to expand this use case to multiple columns with single select.
For eg:
C...
Used ‘Display Name’ of project from Quickbooks to get the Project in Integromat, and filtered using the Parent_Ref value to get the required Project ID. Then used this Project ID as Customer ID to create invoice mapped to the project
