ContributionsMost RecentMost LikesSolutionsRe: Quick Hits"" Webinar Tackling HR Process Challenges February 12thIt is working!, Thank you very much...Re: Quick Hits"" Webinar Tackling HR Process Challenges February 12thIt kinda works now, but it's taking you to a project management video. It should be the HR Challenges one found here... https://lp.quickbase.com/TacklingHRChallenges.html?_ga=2.246027143.221332305.1551211559-1130017709.1... Re: Quick Hits"" Webinar Tackling HR Process Challenges February 12thJust curious, the link to watch this webinar just loops back to signing up for Quickbase. Doesn't appear to be available on demand. Was really hoping to watch it and couldn't when first aired...Re: Exact form today's date errorThat worked! Thank you, I always like simpler...Exact form today's date errorJavascript error when trying to print today's date on exact form. Other fields pulling from table print correctly, it's only the field to print today's date. I am using the syntax from the instructions for customizing an exact form as follows: ~=date = new Date();qdb.format(date.getTime()-(date.getTimezoneOffset()*60000), "date")~ Any advice?Re: Sum hours by pay periodI would be interested in seeing how you configured the automation and relationships. I'm getting stuck at the automation, and i didn't quite follow why you copied to a third table. Is the extra table there for something else too? I'm thinking I could just copy it back to my time card entry...Re: Sum hours by pay periodThat sounds very interesting. What I ended up doing works, but still leaves open the possibility of choosing the wrong period.Re: Sum hours by pay periodI don't know if I got myself worked around in knots on this, but I seem to have it working...not exactly as you described but I am able to confidently enter time and report on it for payroll purposes. I very much appreciate your help on this. BrianRe: Sum hours by pay periodThat works very nicely, thank you. Taking this one step further, on my time card form where I now see the pay period drop down box, it would be great if the value of the pay period defaulted to the correct period for the date of the time card. In other words, when I create a new time card entry and select the date I worked, have the pay period set to the correct period for that date. I want to say this should be a filter or dynamic form rule, but I can't quite make the connection.Sum hours by pay periodTrying to sum time cards by pay period. I have one table to collect hours worked. Table is "Time Cards". Contains [Date], [Job], [Employee], [Hours]. Have also built a Pay Periods table for 2019 that contains [Pay Period], [Beginning Date], [Ending Date], [Pay Date] Pay periods are every two weeks starting on 12/31/18. Pay Periods has a one to many relation to Time Cards. At the end of my pay period, I need to add up the hours worked by employee for that pay period. I can make a simple report against the Time Cards by date with a filter that prompts for beginning date and ending date, but the leads to potential errors when selecting the correct date range, so I would like to either attach the appropriate pay period number to a time card record and then group by that, or run a report on pay periods and group by the period. The part I'm stuck on is assigning a date to the pay period range, unless my thinking is wrong and there's a better approach? I previously did this in Excel via a VLOOKUP formula.