ContributionsMost RecentMost LikesSolutionsRe: Sum hours by pay periodHi Michelle, When I return from traveling can provide more details (by Close of Business tomorrow) on how my time card app automatically assigns the correct pay period (based on date of time worked) from the payroll calendar. DamonUse HTML Dropbox List to Populate FieldI have a list of field options for field 48 in Quick Base and I want an internet user via an HTML page to select from and add the choice the the field. I'm trying to get the following html code to execute what I'm trying to do but need help: Reason: <select id="f48"> <option value="Overtime">Overtime</option> <option value="HR Training">HR Training</option> <option value="USDA Training">USDA Training</option> <option value="VDOE Training">VDOE Training</option> </select> <input type="text" value="" id="f48" name="_fid_48"> I have the API call and all else set up, but just need to correct the line of code above. Re: Sum hours by pay periodHi, this is my first time responding to the community, but I had the exact same problem and resolved it using the automation feature. Essentially, when someone enters a time card entry, the automation is triggered based on (adding or modifying) the "Date Worked" field in the Time Card table. After the date is entered, the automation has Quick Base to see if the "Date Worked" value falls between one of the (Payroll Calendar Table) "Beginning Date" and "End Date" values, each pair has an associated Payroll Period. Once QB determines which record ID# row (where the Date Worked fell between a begin and end date on payroll calendar), it copies the Payroll Period (and any other associated fields) to a third, many-to-many table that is linked to both the Payroll and Time Card tables. If you still are looking for a solution, I can provide screen shot details of the automation, relationships and tables.