Custom email module that contains child company info
Jun 8, 2019 12:09 AM - edited Jun 8, 2019 12:10 AM
We'd like to send a statistics email to our clients every month containing info about their usage of our service.
The data is structured so there's a contact that is linked to a parent company. That parent company has X amounts of child companies (all with different usage stats as custom props).
The goal is to send a single email where the stats from child companies are in a table and are all separated (not summed together).
How can I do that?
I've tested out with custom email modules and there're nice loops/if/else statements there, but how do I get the list (and props) from "all child companies of this company from this contact (who gets the email)"? Then loop through the list of child companies and add them to the email.