I have a couple questions about building a automating a daily email that goes out to our campus community.
I have a table that operates like a kind of bulletin board where people can post updates/location/descriptions/links for events that are coming. The button for posting to the table automatically added the date and time it is created.
I then have an "email this page’ button that I want to automate to send out every morning at 4am.
What I want to be able to do is send only updates posted since the last time the email went out (so basically the last 24 hours). It looks like I need to build that into the button rather than the automation but I’m stuck on the formula for filtering the content that goes into the email.
Here is the test page.
Is it possible to set it so that if there is no modified row the last 24 hours, it doesn’t send an email?
Is there a way to format the email that goes out - say include a link back to the webpage, change how the information is laid out in the email, etc.