How to use an IF statement in Fill A Document with A Batch of Data

Hi! I am trying to create an invoice-like section to a contract for our space and equipment rentals. Pulling the line items from Airtable, I am able to mostly fill the Word doc out as normal until it comes to some conditional places, such as Tables qty is not the same as the other equipment qty because the default equipment rentals are per day, but the tables are per each.

When I put the IF statement in the variable box, it will ignore the contingent factors and just put the fallback factor. Regular math works in the variables, but not these conditional ones. And the conditional variable type is not what I’m looking for because I’m not wanting to return “true” or “false”, I need the actual value of the qty. Same for calculating the total.


Welcome to the Make community!

You don’t need to have Double Quotes around strings in functions.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like

Perfect! Thank you. That worked like a charm.