I am building an app based on Glide tables so can’t use any kind of Google formula that can’t be done in glide tables.
I am working on a volunteer app where a user “commits” to a set number of voluntary work hours per month which I have set up as a number in my user table.
As the user logs tasks, they will log the number of hours it took them to the nearest 30 minutes, however I’d like to show a dash board where the user can see progress bar of how many hours they have done against their monthly target. But I need to find a way of logging tasks against a month so when on the 1st it resets the hours done and the hours required to target.
I hope that makes more sense to you then it does to me
One way to do it is to generate a “month code” that uses a math column to combine the year and month values of the log timestamp. Something like year(timestamp)*100+month(timestamp). This will give you a unique value that you can use for relations and rollups.
Thanks for this really helpful! I’ve found a way to make it work (I think)
I have a math column called “current month” with month(now) and a “current year” with year(now) and then I use a template to combine the 2 values. I do this both on the task sheet and the dashboard sheet then use a relation to look up tasks for this month.
I am using row owners on both sheets so am I correct in thinking it shouldn’t pick up any tasks not for the current user, or should I combine the user email into the templated “month code”?
