Hi 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 tas…

Hey @Tombaker You’ll have to use some math columns to sum the hours, take the month’s number and so on… Take a look in this topic, and see what you can take from it [image] Fun with Dates Project Showcase I just remembered something from a long time ago. I don’t rememb…

@Lucas_Pires thanks I’ll have a look!

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 @Robert_Petitto , I’ll give that a try! Love the youtube videos by the way! :grinning:

Similar to Bob’s suggestion, you might find this useful… [image] Today date without user login Ask for Help @Jeff_Hager I just had an epiphany! In my apps, I have lots of columns that look like this: [Screen Shot 2021-05-12 at 11.04.16 AM] As I was creating yet anothe…

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 …

[image] Tombaker: 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. yep, that should w…

Monthly Tasks

Ask for Help

Darren_Murphy May 14, 2021, 12:57am 6

Similar to Bob’s suggestion, you might find this useful…

Topic		Replies	Views
Showing information based on 1 month, each month . How to? Ask for Help	3	204	November 22, 2023
Time Calculations Ask for Help	19	2282	January 17, 2024
How to create a summaries for individual users? Ask for Help	7	316	October 12, 2022
🗓 Month, Day, and Year Math Functions Ask for Help	47	3817	July 15, 2023
Count users per month in a dashboard Ask for Help	3	330	December 13, 2023

Monthly Tasks

Related topics