Help with Pipeline, loops and emails

If you're open to it - I would suggest actually trying to build out the HTML table in Quickbase first using a rich-text formula that way you can see it and tweak it much easier, and then configure the email by just plopping that field into your pipeline. What that looks like is something close to this: 

1. Create a 'Table Row' field in your timecards. Make it a formula-text field. In that field - build a row object something like:

"<tr>" & 

     "<td>" & [Name] & "</td>" & 

     "<td>" & [Date] & "</td>" & 

     "<td>" & [Hours] & "</td>" & 

     "<td>" & [Activity] & "</td>" & 

"</tr>"

Fill out whatever fields you want here. 

2. In your relationship between contracts and timecards - create a new summary field that is a combined-text and you will summarize the 'table row' field you just made. In this summary field - add your filters for the timecards you want to show

3. In your Contracts table - create a new formula-rich text field called 'Email Table' - and in that formula do: 

"<table>" & 

     "<thead>" & 

          "<tr>" & 

               "<th>Name</th>" & 

               "<th>Date</th>" & 

               "<th>Hours</th>" & 

               "<th>Activity</th>" & 

          "</tr>" & 

     "</thead>" & 

     "<tbody>" & 

          SearchAndReplace(ToText([Combined Summary Row Field]), "; ", "") & 

     "</tbody>" & 

The idea is that your buildind the row in your child table and then putting those rows into the table body dynamically. 

Then in your pipeline - you can search just for the contracts that have timecards to send, and simply put the html contents from the field created into the body.