Hello all and thanks for any responses in advance.
I am trying to create a log for my job. My employees send and give powerpoint presentations daily. Assume it is a work place 4 supervisors and two technicians. I was wondering if I can create a work log woth the following features:
• An entry form with boxes:
- Date picker
- Time
- Supervisor (with an "add supervisor" button for collaborative projects)
- Technician (also with add button)
- Presentiation Type (dropdown menu with 8 types)
- Location
- Presentation name
- Submit button
• After the submit button is pressed, the information is added to a spreadsheet with the ^categories in columns
• I would like a dashboard that displays the total amount of presentations we have entered, then a tally of each presentation type.
• I would also like the dashboard to list each person and how many presentations they have given and a tally of each type.
• Editable previous entries.
I know this is a lot but I am a newbie that learns fast so I am ready if this is possible.