Checkbox to determine line items included in email body
I'm fairly new so this might be an easy fix. I have a portal listing line items of product needed to order on the main dashboard. I've included a checkbox field called 'email' which is meant to indicate the line items to be included in the body of an email. The checkbox has a value of 1 when checked.
The intention is to select multiple checkboxes and then execute an email script via button. Currently I am using the List ( myTable::description) function as a calculation in the body portion of the email to list products needed but I can't seem to figure out how to limit the list to only records where myTable::email = 1.
I appreciate any help in the right direction.