I want the user to be able to select multiple records and then have a csv file emailed with details of the selected records. I know how to create the template and how to make/use a trigger column, but if five records are selected, I only want one file sent to the user. I've tried a zillion options, but none seem to work well.
What's the best way to do this? I already know about trigger columns and about templates, but I can't seem to figure out how to put these things together in a way that works. One way I played with would be to put a datetime value in the trigger column and then have an action that sends the email with records with similar datetime values, but I don't understand how, in a csv template, I can make a select statement that will select all records with a datetime that is greater than now minus five minutes.
Another approach would be to have a separate table with a column that is a list of related records, but with that approach, I'm not sure how to select the records found in the list and how I'd reference the related fields if I did.
LinkedIn
Twitter
