Solved

Set up cloud time sheets.

Posted on 2014-12-02
2
127 Views
Last Modified: 2014-12-27
I have 100 employees who currently use Google Docs to document their hours worked. This is done in a simple Google Doc Spreadsheet with about 4 columns... including: Date of appointment, total time there, customer name, notes on appt. They currently are doing them on their phones, tablets or computers right on the Google sheet... not forms or anything.

I needs a system to put all 100 employee's entries onto 1 spreadsheet. It doesn't have to necessarily be real time (although that would be very nice), but it does at least have to be daily. I need them on one table where I can use Microsoft Access to run relevant queries with the data.

Is there a way I can have my employee's enter fill out time sheets and have every entry appear on one large table? My guess is Google Docs will not have this capacity. I obviously only want every employee seeing only there entries. It would be very overwhelming to simply have them all enter onto one sheet.

Any direction you can provide would be greatly appreciated. Thanks!
0
Comment
Question by:cansevin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 36

Assisted Solution

by:PatHartman
PatHartman earned 250 total points
ID: 40477876
Do you have the latest version of SharePoint available?  Have you looked at creating an Access web app with A2013?   You could create a hybrid app with some parts exposed through SharePoint the employees can use for data entry and you can use a standard access app linked to the Azure database to do the collection and reporting.
0
 
LVL 18

Accepted Solution

by:
bonjour-aut earned 250 total points
ID: 40478290
If you do not use Share Point, you can go more basic way, collecting either text-files or XML files programatically to a access table. I did such an application for a customer of mine. An Access appplication queries a webserver, where te XML files are collected from different client sources, imports them via http to an access table.
Using this method, client applications may differ as long as they result in writng text or html files to a server. This you coud also accieve via web-forms. Presentimg the data to the users could go vice versa. There you have the choice, sending them regular mail reports with their data only or put all data to a web application, where the users have to login to get their data filtered.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Riverbed Technology's webinar discusses networking for the cloud era with simplified SD-WAN cloud connectivity.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Both in life and business – not all partnerships are created equal. Spend 30 short minutes with us to learn:   • Key questions to ask when considering a partnership to accelerate your business into the cloud • Pitfalls and mistakes other partners…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

730 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