Question

Best way to email a table based on a search results

Workflow

Updated December 6, 2021

asked on December 2, 2021

Good Morning,

We are having well drillers upload batch forms to us through forms. The batch is separated and process using quick fields. I would like to create a workflow that would do a search every Monday for forms submitted for the previous week and send each well driller a table with the list of submittals we received from their company. This way they would get one email instead of 50 emails at one time.

Has anyone done something like this before or know of a way I can accomplish this?

0 0

Answer

SELECTED ANSWER

replied on December 6, 2021

I haven't seen a friendly way to do it, but it can be done by assembling the HTML for the table yourself.

1. fetch your set of forms

2. create a token (I used "table") and fill it with:

your <style> info
the open table tag: <table>
your header row: <tr><th>Column 1</th></tr>

3. use a For Each (Entry|Row|etc) to iterate over your forms

4. in the loop, add the row to your table token: %(table)<tr><td>Value 1</td></tr>

5. after the loop, add the closing tag: %(table)</table>

6. in the body of the email, reference the formatted token: %(table#()##"HTML"#)

1 0

Replies

replied on December 6, 2021 • Show version history

Thank you. I finally figure it out today. It is weird though.

1 0

You are not allowed to follow up in this post.

Question

Question

Best way to email a table based on a search results

Answer

Replies

Sign in to reply to this post.