I want to use Workfront Fusion to send a weekly digest email to users listing their overdue tasks from the past week as well as their upcoming tasks and I'm wondering if this is possible.
The scenario that I have set up pulls the list of users who will receive the digest email, searches for each of their overdue and upcoming tasks and aggregates them into two JSONs, and then uses an Email module to send the email.
I have built out a custom email template using HTML and have embedded a Javascript function to run on load that converts the two JSONs into HTML tables; however, the tables are not rendering in the final email that I receive.
I'm wondering: has anybody used Javascript to build dynamic email content in the Fusion Email module? Is this even possible? Is there a better approach to take to build this email?