Automatically Update an Excel file from various actions in GlideApp

[ThinhDinh]

Historical Analytics by Date

I have the exact need as you for my last project. I think there are 2 ways to go here: If you have access to Glide API’s query (on Business/Enterprise), perhaps you can query the whole tables and do aggregation to get the right numbers (of Users, Events, Events Complete - basically re-calculating them in Make/Zapier), then push those to your analytics table. The alternative is to duplicate your app, which will keep your tables intact. Change your app to fully public, clear all tabs and ad…

I think here’s the best option I can share for now.