![]() ![]() ![]() If the date already exists in the sheet (as each submission only covers one office, this should be 3 submissions per date, disregarding any updates needed) all non-blank fields are updated. Finally if the date is a date before the previous rows date, the sheet is sorted. If the date doesn't exist in the sheet, it adds a new row, adds the date and copies the formulas, and fills in the agent hours. It takes the information from the submission and adds them to a spreadsheet (currently received by opening the form and grabbing the last submission (rather than taking the event, I found that the event includes all agents across all offices with the rest just being blank, while the last submission only contains the fields that have values)) that has one date per row, all agents in columns and a column for summarizing the total hours for the office, as such:ĭate office1 agent1 agent2 office2 agent14 agent15 etc. On form submission, the script runs and does the following: Timestamp Username Date Office agent1 agent2 agent3 agent30 This Access Template is also a database that provides other tracking data such as Work Code List, and reports such as Billable Hours by Employee, Billable Hours. The form submission columns are structured as such: After which the form continues to one of 3 pages which has the agent names for their particular office, and a field to enter hours. The form has 4 pages, a first page where the date and office is picked. The form updates a spreadsheet with agents (employees) hours worked for a specific date. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |