Solved

Clould Solution for Members to Access Timesheet

Posted on 2015-02-03
4
142 Views
Last Modified: 2015-02-04
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
Comment
Question by:infiniti7181
  • 2
  • 2
4 Comments
 
LVL 79

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 40588562
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
 

Author Comment

by:infiniti7181
ID: 40588785
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
 
LVL 79

Expert Comment

by:David Johnson, CD, MVP
ID: 40588817
precisely now a web app that the workers can use via their browser would be ideal.
0
 

Author Comment

by:infiniti7181
ID: 40588897
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

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Open the Page in Browser than Download 5 55
Cloud Printing 3 44
Office 365 Quarantine 5 26
OneDrive for Business:  Redirected Folder or Network Drive natively? 3 48
Find out what you should include to make the best professional email signature for your organization.
There is no doubt that cloud is gaining importance. Many of you must have read about this technology and its growing importance. More and more organisations are embracing this technology not forgetting start-ups. The process begins by dipping …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question