Find Jobs
Hire Freelancers

Create Google Docs Calendar Schedule and Satellite Schedules that can Sync

$750-1500 USD

Đã đóng
Đã đăng vào khoảng 9 năm trước

$750-1500 USD

Thanh toán khi bàn giao
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).
Mã dự án: 7529523

Về dự án

3 đề xuất
Dự án từ xa
Hoạt động 9 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
3 freelancer chào giá trung bình $1.374 USD cho công việc này
Avatar người dùng
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 trong 14 ngày
5,0 (2 nhận xét)
3,0
3,0
Avatar người dùng
A proposal has not yet been provided
$1.578 USD trong 20 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED STATES
United States
0,0
0
Thành viên từ thg 4 22, 2015

Xác thực khách hàng

Các công việc khác từ khách hàng này

Classified Ad Poster
$30-250 USD
Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.