We've recently started a 2+ year project that will involve the weekly sending of word docs between 25+editors and a client. Doing this by email will take a long time. So we're looking for someone that can help us set up a google doc and drop box account that be used for automatic file sharing and tracking, to which editors will only have access to their folders dropbox and their data on the google spreadsheet. (If you can recommend any other PM software or tools that can make this easier - we are open to suggestions).
Our requirements are:
1. The spreadsheet must have a master page that is linked to all the individual editors pages. When the PM adds the new file info to the master page, it must automatically link to the editor pages. Similarly, when editors update their pages (for example to mark a piece of work as complete) this must automatically update on the master page.
2. Editors must only have permission to view and edit their pages.
3. We want to set up a dropbox account that will contain a folder for each editor. In that folder there will be a 'To be edited' and 'Complete' folder. The overall process will be that the PM will be able to add files to the 'To be edited folder' and then update the google doc with the details. The editor will see that the files have been added on the google doc, and then edit the files from the dropbox folder, and then save them to the 'Complete' folder, and then mark the files as edited on the google doc.
4. Editors must only have access to their files in the dropbox account.
5. This must be fully scalable and simple to add extra google doc pages and dropbox folders in the future.
If anyone can recommend simpler ways of doing this using other tools - I welcome any recommendations and will be for your time.
We're looking for someone that really knows their stuff and can set this up in a few hours, with 10 dropbox folders and 10 google doc pages. Attached is an example of the information we'll need in the google doc - as you can see it is very simple.
Once we project is completed we may use you again in the future for improvements and other projects.
The rate is negotiable based on what you can offer!
Được trao cho:
I have experience setting up google docs and sheets as task tracking/project update system and providing permissions. I can send an example if needed. I can start working on this immediately.