drckarcher Posted December 19, 2022 Report Share Posted December 19, 2022 Hi, I am trying to figure out how I can generate an email to one or many email addresses using a report page and a 'SEND" button This is what my report would look like. I'd need tick boxes to select one, many or all search results and a SEND button. Each entry would receive an individual email. eg To: [email] Subject: Test email Text: Dear {First], this is a text email confirming your email address is [email] and your last name is [last] Is there a tutorial available for this. Maybe I am searching for the wrong terms Quote Link to comment Share on other sites More sharing options...
0 CoopperBackpack Posted December 19, 2022 Report Share Posted December 19, 2022 Hello @drckarcher, Since Trigger can be only executed by some actions in the table (Insert/Update/Delete), you may utilize the "Bulk edit" option on the Tabular Report DataPage. https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ To do so, you need to add a field with the "Yes/No" data type to the table. For example: When the "Bulk edit" option is enabled, a new page is added in the DataPage settings. In my example I left only the 'Send_email' field there: The DataPage example: Please note that the label for the Edit button (point 2 on the screenshot) can be customized under the Localizations: But this is optional. The Trigger example: This Trigger sends individual emails to the updated records. Basically, the condition to send an email is the checking the 'Send_email' checkbox that was not checked. This works if you need to send emails once. However, if you need to be able to send emails multiple times for the same records, the Trigger should be modified. Please let me know if you need to send email multiple times. Quote Link to comment Share on other sites More sharing options...
0 Flowers4Algernon Posted January 28, 2023 Report Share Posted January 28, 2023 Hello! You may also want to check out this link for more information about Triggered Actions: https://howto.caspio.com/tables-and-views/triggered-actions/ Quote Link to comment Share on other sites More sharing options...
Question
drckarcher
Hi,
I am trying to figure out how I can generate an email to one or many email addresses using a report page and a 'SEND" button
This is what my report would look like.
I'd need tick boxes to select one, many or all search results and a SEND button.
Each entry would receive an individual email.
eg
To: [email]
Subject: Test email
Text: Dear {First], this is a text email confirming your email address is [email] and your last name is [last]
Is there a tutorial available for this. Maybe I am searching for the wrong terms
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.