Find Jobs
Hire Freelancers

Create Google Docs Calendar Schedule and Satellite Schedules that can Sync

$750-1500 USD

Closed
Posted about 9 years ago

$750-1500 USD

Paid on delivery
We have a large medical practice with numerous doctor employees. Currently, there is one large Master Schedule which is a Google Docs Spreadsheet Calendar. The columns are hospital work locations. The hospital schedulers can enter the work required. The practice supervisor can then assign the doctors. Each doctor can review the schedule and see where they are working. We are seeking to create multiple small schedules that can sync bidirectionally with the Master Schedule. That way each worker wouldn't be aware of every other workers job. Additionally, each scheduler wouldn't be aware of work at competing hospitals. Synchronization would need to support: -Creation of events in all locations -Modification of event details in all locations. -Deletion of events in any will propagate to all location There are 3 parties and jobs involved in running the schedule. 1. Multiple Hospital Schedulers & Calendar Each work site has a scheduler. They book or schedule upcoming cases. Sometimes things changes and they edit or cancel previously scheduled cases. I would need each hospital scheduler to have their won individual calendar schedule which ONLY they would view. I need them to be able to edit their schedule calendars and have that appear on my Master Schedule. 2. Worker Schedule & Calendar Each worker should have a schedule calendar of the sites where they commonly work. They should ONLY be able to view their schedule calendars. There is no need for them to edit anything. They only view. 3. Master Schedule & Calendar This is what I view and edit. After the Hospital Schedulers (#1) schedule cases on their calendars and they have synced with my Master Schedule, I place worker names on my Master Schedule which should sync with the individual Workers Calendar(#2) and the Hospital Schedulers Calendar (#1).
Project ID: 7529523

About the project

3 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $1,374 USD for this job
User Avatar
Hello, I'm an experienced developer. I have used Google apps for my personal projects and also I have done Google apps projects here on freelancer, my last 2 projects are Google apps projects. I have gone trough your project details and this is how i would finish your solution from reading your description. If you don't have them I would create spreadsheets for hospital and worker schedulers based on your master spreadsheet or your design. 1. Part I would use onEdit spreadsheet trigger to save the changes in a hidden sheet. When the user is done editing he would click a button somewhere on the ui, most likely sidebar what would push the changes to you master sheet. This can be done in many ways but from reading about it it seems the best way. You can set the edit/view permissions manually. 2. Part This part seems easy since it's a one way sync. You can set the view permissions manually or create a viewable link. 3. Part Hospital and worker schedulers would be in there separate folders, I would sync with all files in a folder. I would probably detect edits the same way as in part 1 but the sidebar would have separate controls for hospital and worker sync. This isn't for certain but just a general idea since don't know how your master schedule looks like and if you don't have the spreadsheets already made I would like to have some kind of a design. Feel free to contact me if you have any questions Regards, Ognjen Jaric
$998 USD in 14 days
5.0 (2 reviews)
3.0
3.0
User Avatar
A proposal has not yet been provided
$1,578 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Apr 22, 2015

Client Verification

Other jobs from this client

Classified Ad Poster
$30-250 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.