Two Queries to Send Email

Can I have more than one db query in 1 action step that will do separate things? Here’s what I have:

!. Query the accounting assistant’s info to whom the email report will be sent
2. Query the data to populate the report to be emailed.

I need the email to be sent after the submit button is clicked to insert that data to the database.

The order of my action steps:

  1. Database Connection
  2. Query accounting assistant’s data
  3. Setup Mailer
  4. Query report data
    a. Repeat this query
    b. Send Mail

See image below:

My Problem : When I start inserting the data bindings into the email, the report data bindings under the repeat step are seen, however the previous query in the steps for the accounting assistance the database name is seen, but the individual data binding results of that table are not seen.

What am I doing wrong?

Thank you for any help.

Community Page
Last updated: