My AirTable database has checkmark entries (Yes/No) for the forms (several) that a client has completed. I am trying to figure out a scenario where a client gets a reminder to complete the forms that he/she has not completed yet.
- Get AirTable entires with missing forms (I Use AirTable formula)
- Get Name and Email variables as well as the forms that have no checkmark.
- Generate an email to a client with a set of links (depending on which form has not been completed)
Not that there can be more than one client and more than one form per client that is not completed.
This would be easy we the If-Then module but I don’t know how to do this in Make.