Hi, Im going to try and explain this the best I can but I have been trying for ages and my head is about to fall off… My app is a Jobsheets App where engineers fill it out when completing a job and then submit a custom form. The Job Tab has all of the job information and the ones that are importa…

This might be perfect timing. [image] Conditional Relations Feature Requests Something is coming later this week… [image] new Query column! This request has been brought to life. https://community.glideapps.com/t/conditional-relations/1381…

As Jeff alluded to, there is a new feature coming that will make this sort of thing trivial. But in the meantime: [image] Matty_Fenny: I now want to be able to calculate the sum of all of the jobs completed in a certain time frame. So in the Relation for Completed by, I need to check if the Co…

[image] Darren_Murphy: Now + MOD(8-WEEKDAY(Now),7) - 6 - HOUR(Now)/24 - MINUTE(Now)/1440 The Total Earned Today worked perfectly Thankyou for much for that! You’ve lost me a little on the This week one if I’m honest.

Ive managed to do the math column and then check if Completed Date is on or after the math column, but how to I check if its within Monday to Sunday? Thanks, Matty.

Okay, relising things as I go along… I just made a math column and calucated (Start of the Week + 6) and it gave me the Sunday. So now I can add another Case after checking if Completed date is on or after Start of the Week, and check if Completed Date is on or Before End of the Week.

You don’t actually need to do that, unless you have completion dates in the future. And I assume that’s not the case? The math column should return a date, which represents midnight on the most recent Monday. So any row with a completion date after that date must be in the current week. Therefore, …

Ohhh that makes sense hahah Thanks!

What would the Math need to be to get the current month?

I would use this: Year(Now) * 100 + Month(Now) That will give you a number that looks like 202305 (for May 2023). Do the same thing for your Date column in the Jobs table, then you can do a direct numerical comparison.

Great thats working thankyou! What would be the best way to store these values? When the month changes, the values will go back to 0 until another job is completed so I need a way of storing each day, week, month and years takings.

Create a List of specific Relation Items

Ask for Help

Jeff_Hager May 4, 2023, 1:27am 2

This might be perfect timing.

Topic		Replies	Views
Conditional Relations Feature Requests	23	3520	May 4, 2023
Can I get a list of all dates between 2 date columns? Ask for Help	6	1341	February 15, 2022
Conditional Rollup within Glide data editor Ask for Help	13	2495	January 17, 2024
Select a date range Ask for Help	1	846	November 29, 2020
Weekly overview Ask for Help	29	570	December 13, 2024

Create a List of specific Relation Items

Related topics