[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

Clould Solution for Members to Access Timesheet

Dear Team,

I have a scenario . I have a team under me around 15 members who works outside office (most of the time) . I would like to monitor the day to day activities , as they have internet access. I need a solution to have timesheet to be filled by employees.
I am suggesting an excel sheet to be uploaded in the cloud, so that members can access and edit the page . Lets say an example, i have excel sheet with 13 tabs meant for 13 members . Only the particular member can access the tab ( or worksheet ) to do his work and admin can access all the table.
Well the vision i have is highlevel and i dont know how can i acheive it sucessfully. I would like your valuable experience , how can i have this timesheet solution deployed in cloud like Azure, Google etc and be benefited for the organisation . Highliy appreciate your kind help and support.

Regards,

SID
0
infiniti7181
Asked:
infiniti7181
  • 2
  • 2
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
This is where you should use a database and not excel that or have an excel file for each of the 13 workers and then link them into your master

http://www.keynotesupport.com/excel-basics/excel-linking-worksheets.shtml
Master.xlsx
Timesheet-1.xlsx
Timesheet-2.xlsx
Timesheet-3.xlsx
0
 
infiniti7181Author Commented:
Hi David,

Thanks for the info and examples provided. Related with Database, do you mean use Access and a report can be generated .

Regards,
SID .
0
 
David Johnson, CD, MVPOwnerCommented:
precisely now a web app that the workers can use via their browser would be ideal.
0
 
infiniti7181Author Commented:
Thanks any examples so i can refer .
web app can be tagged with mobile app ( iphone or android) and reports can be stored in cloud . Is it something like that ?
Regards,
SID
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now