"Lock-in" a Query Result?

Hello Gliders! Random, hopefully simple question here but I’m stumped. I am working on creating a dashboard to track some of my metrics from an app I have in production. So, for example, I have a query of data and a rollup that counts that data and let’s say the value today is 3. Now, is there a way to write that 3 to a daily log so I can see how we’ve progressed towards our goals over time?

I’m thinking I can have one of my user actions do this manually and just do a very common one so I ensure it happens every day, but that seems to be very redundant and wasteful. Do y’all have any better ideas?

Hopefully you’ll be able to do that soon as part of Glide’s time-based actions. No ETA, but it solves your problem here.

2 Likes