Create time card sample for V3+ of time card dashboard

[Rabia2219]

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

• create a list of requirements
• find the sample time card
• create the new time card
• Populate sample sheet data (resource 1.01) with data from resource 1.03. The data will go into tabs called 1, 2, 3, etc based on the week.
• Populate sample sheet data (resource 1.02) with data from resource 1.04. The data will go into tabs called 1, 2, 3, etc based on the week.
• review by org
• Make a new spreadsheet template for the roll up using notes from requirements
• release dependency on new issue Create script that rolls up the data from the time sheets #7759

Resources/Instructions

• Google Drive Folder: Time Card

Related issues

• Project Board (see all issues): HfLA Dashboards: Project Board, Time card
• This issue is part of this epic: Epic: Time Card Dashboard #7509
  • Requirements for the Time Card Dashboard #7640
    • Create time card sample for V3+ of time card dashboard #7710 (this issue)
      • Create script that rolls up the data from the time sheets #7759

Current Time Card template (do not overwrite, make copy only)

• TWE: ISXX Time Card

Another template example

• Time Card Sample - from a enterprise job

V3 Sample

• 1.01 Where the data will go: TWE: IS26 Time Card: ID: 003 - Sample data, Instructions tab
• 1.02 Where the data will go: TWE: IS26 Time Card: ID: 005 - Sample data, Instructions tab
• 1.03 Data: TWE: IS22 Time Card (Responses), Data tab, Filter: ID 3
• 1.04 Data: TWE: IS22 Time Card (Responses), Data tab, Filter: ID 5
• To find the start date of weeks 2022 Calendar

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

[ExperimentsInHonesty]

@sofiatajide I cleaned up the action items so that it would be clearer what you had to do.

[HackforLABot]

@sofiatajide

Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.

1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
2. Blockers: "Difficulties or errors encountered."
3. Availability: "How much time will you have this week to work on this issue?"
4. ETA: "When do you expect this issue to be completed?"
5. Pictures (optional): "Add any pictures of the visual changes made to the site so far."

If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.

_{You are receiving this comment because your last comment was before Monday, December 30, 2024 at 11:04 PM PST.}