Glitch Posted February 2, 2019 Report Share Posted February 2, 2019 Hi all! Can we create a trigger that sends out like a list of records? I set up a trigger which would send an email if ever a condition was met. The problem is that, it sends me ONE email for every record. So for example, I have 3 records that meet my criteria, it would send me THREE emails. Can we make it like, it would compile all records and send them to one email? Any help would be appreciated. Thanks everyone! Quote Link to comment Share on other sites More sharing options...
0 ChrisCarlson Posted February 3, 2019 Report Share Posted February 3, 2019 Vanellope, Currently it will only send one record at a time. I have been thinking about this issue as well since I am used to manually triggering email summaries (a single email with multiple records) using the bulk edit option on a tabular report to generate the email manually. I have a few ideas in mind that I have not tested yet, such as running a task to append the record as HTML to a central field which would build the table of records, then once completed generate a summary trigger that would send the email with the table of records. This of course is just an idea for now, I will let you know if I am able to get it to work. Glitch 1 Quote Link to comment Share on other sites More sharing options...
0 Glitch Posted February 4, 2019 Author Report Share Posted February 4, 2019 Thank you so much. Can I get an update once you're able to accomplish this? I've been trying to figure this out for a long time now . Is this even possible within Caspio? Quote Link to comment Share on other sites More sharing options...
0 TsiBiRu Posted February 4, 2019 Report Share Posted February 4, 2019 Hi @Vanellope, Is it possible if you can provide us with a screenshot of your table design/structure, as well your criteria/condition? This will allow us to provide you with the best answer to your inquiry, and you can also elaborate on your workflow if possible. Regards, TsiBiRu Quote Link to comment Share on other sites More sharing options...
0 Glitch Posted February 4, 2019 Author Report Share Posted February 4, 2019 Well I'm not referring to a particular trigger, but here's how I set it up. I wanted to atleast know if it is possible to send a single email instead of sending them individually. Like creating a list of records that meets my criteria? If you go over my question, I want to send one email with all the list of my records where Date_due is equal to today's timestamp. However, it's sending me one email per record which means, I will receive 100 emails if there are 100 records that meets my criteria. I know that my trigger would probably be incorrect, since I just put the [field] inside the message. Can I use SELECT statement inside the message perhaps? If not, is there a way to do this? Quote Link to comment Share on other sites More sharing options...
0 Glitch Posted February 9, 2019 Author Report Share Posted February 9, 2019 Hi everyone! Any comments on this one? Quote Link to comment Share on other sites More sharing options...
0 Wernon Posted February 14, 2019 Report Share Posted February 14, 2019 Hi, Vanellope! as far as I know, it is still not possible to concatenate or somehow add several results to a single email. The only solution I found is to create a task, which calculates the number of records that fulfill the conditions and send the email with the number and search criteria. After just filter the data on the Report and change with "bulk edit" from Caspio Bridge. Not sure if it helps you, but here is a short Task for my case: Hope it will help you somehow. Regards, Wernon. ManokNaPula 1 Quote Link to comment Share on other sites More sharing options...
0 DefinitelyNot31337 Posted August 22, 2019 Report Share Posted August 22, 2019 I also think that is currently not possible. I was thinking of a Cascading Trigger workflow would do the trick, but unfortunately, it doesn't. Below is how I simulated it's runtime. === The children table, on record update, would append the value of the updated record to its corresponding parent in the parent table This Task should initially clear out the values in the parent table; After that, update each record in the child table so the trigger would be executed for each record. ==== However, it appears that the "Update child" action on the Task only runs once. They are populating the #inserted temp table with records so only the Top 1 record is written onto the parent table. Not sure if my explanation is clear enough or if you get the gist of it but I hope this helps. Regards, ~DN31337! Quote Link to comment Share on other sites More sharing options...
0 BaySunshine Posted September 24, 2019 Report Share Posted September 24, 2019 Hi everyone, Email trigger does not still allow attachments in Caspio. However, a workaround it is to create another table using a trigger which will store just the email addresses, count of records and any other information as you wish. Make sure that the email address field is unique so you don't accidentally store it more than once. Include IF statement in the trigger and use 'exists' or 'not exists' operator to verify if an email address exists. Add a checkbox field in the new table and also a date field to store the date the email was sent. Run a task everyday which will send out an email for all the email addresses in this table once. Check the box once an email is sent and update the date field. In the email body, include a link that will pass this email address to a filtered report DataPage as a parameter. The users can click on the link to view the records. I hope this helps. Regards, Quote Link to comment Share on other sites More sharing options...
0 DefinitelyNot31337 Posted December 19, 2019 Report Share Posted December 19, 2019 Hi. I was supposed to reply to this thread then reference it to the other one but instead I did it the other way around. Try checking this link: Quote Link to comment Share on other sites More sharing options...
Question
Glitch
Hi all!
Can we create a trigger that sends out like a list of records?
I set up a trigger which would send an email if ever a condition was met.
The problem is that, it sends me ONE email for every record. So for example, I have 3 records that meet my criteria, it would send me THREE emails.
Can we make it like, it would compile all records and send them to one email?
Any help would be appreciated. Thanks everyone!
Link to comment
Share on other sites
9 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.