Submitting Time card & Updating Roll Up sheet
#### Script One
- Create final template
- [ ] create a button for the text 'Submit Time Card' that is only available to click at the end of each week (once there is a value in the final date column)
#### Script Two
- Automate the final template
_**The automation runs when 'Submit Time Card' is clicked**_
- [ ] read 'Date to Process' from the 'Global Values' tab
- [ ] read 'Tab to Process' from the 'Global Values' tab
- [ ] from the 'Tab to Process' locate the 'Date to Process' and read values from column A if there is any corresponding value in column B
- [ ] add the values to an external sheet called ' Rollup'
- [ ] +1 the to the value in 'Date to Process' and repeat the steps till the last date for the tab is reached
- [ ] add a new tab with the same template for the next week, naming it with the 'Tab to Process' +1 value
- [ ] generate the dates for the new week
- [ ] Update 'Global Values' tab
- [ ] replace the value for 'Date to Process' with the first date in the newly created tab
- [ ] replace the value for 'Tab to Process' with the newly created tab number
#### Script Three
- Send Slack message
- [ ] send Slack message to remind intern to submit the time card before the Sunday, midnight PST deadline
Added a script to handle the selection of 'Other' from the activity list. If selected, a popup asks for input and adds it to the cell where 'Other' was selected.
[ ] create a button for the text 'Submit Time Card' that is only available to click at the end of each week (once there is a value in the final date column)
Script Two
Automate the final template
The automation runs when 'Submit Time Card' is clicked
[ ] read 'Date to Process' from the 'Global Values' tab
[ ] read 'Tab to Process' from the 'Global Values' tab
[ ] from the 'Tab to Process' locate the 'Date to Process' and read values from column A if there is any corresponding value in column B
[ ] add the values to an external sheet called ' Rollup'
[ ] +1 the to the value in 'Date to Process' and repeat the steps till the last date for the tab is reached
[ ] add a new tab with the same template for the next week, naming it with the 'Tab to Process' +1 value
[ ] generate the dates for the new week
[ ] Update 'Global Values' tab
[ ] replace the value for 'Date to Process' with the first date in the newly created tab
[ ] replace the value for 'Tab to Process' with the newly created tab number
Script Three
Send Slack message
[ ] send Slack message to remind intern to submit the time card before the Saturday, midnight PST deadline
Overview
We need to create a time card for the newer version (V3) of the time card dashboard so that we can collect the data for the dashboard visualizations.
Action Items
Resources/Instructions
Related issues
Current Time Card template (do not overwrite, make copy only)
Another template example
V3 Sample
Script Requirements
Submitting Time card & Updating Roll Up sheet
#### Script One - Create final template - [ ] create a button for the text 'Submit Time Card' that is only available to click at the end of each week (once there is a value in the final date column) #### Script Two - Automate the final template _**The automation runs when 'Submit Time Card' is clicked**_ - [ ] read 'Date to Process' from the 'Global Values' tab - [ ] read 'Tab to Process' from the 'Global Values' tab - [ ] from the 'Tab to Process' locate the 'Date to Process' and read values from column A if there is any corresponding value in column B - [ ] add the values to an external sheet called ' Rollup' - [ ] +1 the to the value in 'Date to Process' and repeat the steps till the last date for the tab is reached - [ ] add a new tab with the same template for the next week, naming it with the 'Tab to Process' +1 value - [ ] generate the dates for the new week - [ ] Update 'Global Values' tab - [ ] replace the value for 'Date to Process' with the first date in the newly created tab - [ ] replace the value for 'Tab to Process' with the newly created tab number #### Script Three - Send Slack message - [ ] send Slack message to remind intern to submit the time card before the Sunday, midnight PST deadline