So I followed the Time clock video posted by Appsheet and included it into my app with a template that sends an email with the total hours. I created this a year ago, and now I am getting not only 2022 data, but now also 2023 data on the same template. I only have one person to track but a year ago as part of testing I was also logging hours.
I have fiddled and fiddled with trying to only get this years data to pull with mixed results. I am hoping someone could help me. Ultimately I made a copy of the database and removed 2022 data for now. But I want it all in the same spreadsheet.
These are the queries from the template:
<<If: (COUNT(SELECT([Related TimeCards][ID], [WeekNum]=WEEKNUM(NOW())))>0)>>
This I can change to =WEEKNUM(TODAY()-1)))
And it filters out for the one employee, but the testing I was doing a year ago still lists my time from 2022 as there are no 2023 entries for myself.
Also, the last section just lists hours from "some date" IDK what date this is pulling from, I am assuming the same week in 2022. No matter what I do I can't seem to change what appears here.
Here is the whole template:
Employees
<<Start:SELECT(Employees[Email],TRUE)>>
Email: <<[Email]>>
Name: <<[_ComputedName]>> | Rate: <<[Rate]>> |
<<If: (COUNT(SELECT([Related TimeCards][ID], [WeekNum]=WEEKNUM(NOW())))>0)>>
TimeCard
Date | Time In | Time Out | Calculated Time | Description |
<<Start: SELECT([Related TimeCards][ID],[WeekNum]=WEEKNUM(NOW()))>><<[Date]>> | <<[Time In]>> | <<[Time Out]>> | <<[Calculated Time]>> | <<[Description]>><<End>> |
<<EndIf>>
<<If: (COUNT(SELECT([Related TimeSheets][ID], [WeekNum]=WEEKNUM(NOW())))>0)>>
TimeSheet
Sun | Mon | Tues | Wed | Thurs | Fri | Sat | Total Hours | Total Amount |
<<Start: SELECT([Related TimeSheets][ID],[WeekNum]=WEEKNUM(NOW()))>><<[Sunday]>> | <<[Monday]>> | <<[Tuesday]>> | <<[Wednesday]>> | <<[Thursday]>> | <<[Friday]>> | <<[Saturday]>> | <<[Total Hours]>> | <<[Total Amount]>><<End>> |
<<EndIf>>
<<End>>
LinkedIn
Twitter
