I am creating a fitness tracker application. The google data sheet is very large with 159 columns. I track data on RIDES, RUNS, GYM SESSIONS, etc.
From this data set in google sheets, I have QUERY table in google sheets that selects specific columns from RIDES so I can mine this QUERY table data for specific metrics. So, I’ve created another table (let’s call this table DASHBOARD METRICS table) that uses mathematical formulations referencing the QUERY table to produce metrics like LONGEST RIDE (MAX expression), % change from previous, # of days ago (VLOOKUP in Google Sheets), etc.
In my app, I’ve added this DASHBOARD METRICS table into the app so I can present these metrics in the UX under the card view.
It looks great (see picture), but it DOES NOT update when I sync the app or add new entry. Only when I “SAVE” the table do the metrics update.
Have I set this up correctly in App Sheet? Is pull the DASHBOARD TABLE from GSHEETS which works in the background the correct approach?