Conditional Logic for Data Merges

Updated on:
September 6, 2023
Home
Guides
Portant Data Merge Add-on

Conditional logic is a great setting if you want to create documents only from certain rows within a spreadsheet. It can be selected from the dropdown list within the Data Merge box.

In this article you’ll learn how to:

  1. Set up a condition
  2. Advanced settings for conditions

How to set up a condition

If you would like to set up a condition for a data merge, all you need to do is go to the Data Merge box and select 'condition' in the drop down menu.

After you have selected condition, the next step is to select the field the condition is based on. Open the next drop down menu and select the field. If the field you want is not there you might have to click refresh in the the top right hand corner on the data sources table.

After that enter the value the field has to equal for the automation to run and bam! You're done :)

How to add advanced settings for conditions

It is possible to add a more advance filter that is based on two conditions (or a different operator other than 'equal') by adding another column to your spreadsheet. In this new column you can add a formula that contains the advanced conditions and then use the result of this column for the data merge. For example you could use formulae like these:

Returns 'Merge' when two different words (Apple & Orange) are entered in two seperate columns (Column A & Column B):
=IF(AND(A4="Apple",B4="Orange"),"Merge","")

Returns 'Merge' when either word (Apple or Orange) is entered in one column (Column A):
=IFERROR(IFS(A2="Apple", "Merge", A2="Orange", "Merge"),"")
‍

Then you could set the condition in Portant to Merge based on when this column equals 'Merge'.

This is quite a good guide on using 'IF' & 'AND' functions together:
https://infoinspired.com/google-docs/spreadsheet/combined-use-of-if-and-or-logical-functions-in-google-doc-spreadsheet/

‍

Feedback and feature suggestions

We created Portant in 2021 and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback please feel free to send us an email at contact@portant.co or use our contact form here: https://www.portant.co/support

Thanks,

Blake and James

More than mail merge

You can do a lot more than just mail merge with Portant. Portant is a fully-fledged online document automation solution that can optimise many different document flows. You can use our online document automation platform to optimise your repetitive work, so you can get back to doing the work you enjoy.

Get started
Most Popular Templates

Save hours of manual work in just a few clicks

Transform your work life with responsive, fully customizable, and easy-to-use templates.

Automate contract eSigning

Select a Google Doc agreement template, add an eSignature placeholder and put your contract signing on auto-pilot.

Try it now
➜
Generate batches of invoices

Select a Google Sheet of invoice data, add a Google Docs invoice template, and generate 10, 100 or even 1000's of invoices at a time.

Try it now
➜
Google Forms to Docs

Select a Google Form, add tags to a Google Doc template, and generate Docs every time your receive a Google Form response.

Try it now
➜
Incident reports

Every time a  Google Form is submitted an incident report PDF is automatically generated and shared via email.
‍

Try it now
➜
Google Forms to PDF

Select a Google Form, add tags to a Google Doc or Slides template, and generate PDFs from responses.
‍

Try it now
➜
Automate sales proposals

Systemise your sales proposal decks so they are consistent and accurate. Perfect for sales operations.

Try it now
➜
100 documents/month for Free. eSignatures included
Try Portant for free
No credit card needed