I want my app to send data every hour to my email, is there a way to automate it in Glide so that it sends without me having to press a button(without the use of Make/Zapier).
Short answer: no.
I have instead made a date computation column that tells me when transactions have been open for an hour, how would I implement that into my collection?
So from the User Interface perspective: You see a collection of all your transactions, then click a switch/checkbox to only see transactions that have passed an hour.
Assuming that your switch writes to a user specific boolean column, you could use that as a visibility condition on a second collection. So, two collections - one visible when the switch is checked, and one visible when it is not. And have one collection filtered by your date column.