I have an app which is now almost fully functioning thanks to a lot of help from AppSheet and this community. The app has a site table and two related meter read tables, Gas and Electricity. The user enters the latest meter reading in the appropriate table and for the site for which he is responsible. That is working well.
At the end of the month, I want the app to automatically send an email to the Manager showing for each site only the most recent reading from each Read table. I can get the email to work but all reads are sent. How can I limit this to only the most recent?
Many thanks again.