Google Apps Script(s) to Deploy a site, group, and several Google docs folders

IN PROGRESS
Bids
2
Avg Bid (USD)
$500
Project Budget (USD)
$250 - $750

Project Description:
I’d like a Google apps script to help me setup a new project on form submit. (I have a template site called HIPP_Project)
The script would work as such:
1. Form input: Project number, Client Name, Project Lead and Deploy Project Site = Yes or No (drop down)
2. On form submit:
o The data would populate a spreadsheet Row with column labels: Project Number, Client Name, Project Lead, Deploy Site, Location, Google Group, CAD Lead, Folder Link, Site Link
o Calculated Columns
o Location: [=If(left(1,1)=A, “Augusta”, if(left(1,1)=R, “Raleigh”,””))
o The Google Group field/cell should be populated with [=Concatenate (ProjectNamber,”@domain.com”]
o CAD Lead: The CAD lead should rotate through a list of 3 names from sheet 2. Each form submit gets assigned the next name.
1. (If possible it would be great to check for the CAD leads email address on our vacation calendar and if they are out, skip that person and move to the next.)
o File Link: field should be populated with \Y:\projects\Location(ie. Raleigh or Augusta)\project number.
o Sites Link: [=if(Deploy Project site = yes, sites.google.com/a/domain/clientname_projectnumber, “NA”,)
3. SPREADSHEET
o The script should run simple mail merge and send an email to the Google group [] “The project for $clientname has been setup at the following location: File link field. A project site was deployed $yes_or_no. If a site was deployed you can find it at $site link.
4. GROUPS
o The script would then create a new google group [project#@domain.com]
? Set the owner to with delivery set to no email
? Add people from a list in sheet2 ,
? Assign these people to manager roles
? Set email delivery to no
? Set permissions to: Post = Anyone, Join the group = Anyone in the organization, View topics = All organization members



5. DRIVE
o Create a new folder with the project number as the name. Based on the location field; Place this new folder under either Projects\Raleigh\ NewFolder OR Projects\Augusta\ NewFolder
o Next create new subfolders based on the following list.
o NEWFOLDER
? Calculations
1. Elec,
2. Fire
3. HVAC
4. Inst,
5. Plum
6. Proc
? Client-Received Materials
? Correspondence
1. Agenda
2. Email
3. Faxes
4. Letters
5. Meeting Minutes
6. Memos
7. Telephone Call
8. Reports
9. Transmittals
10. Trip Reports
? Deliverables
1. Basis of Design
2. Covers
3. Detailed Package
4. Field Data Study
5. Preliminary Package
6. Report
7. Specs
? Drawings
1. Client Originals,
2. Disciplines,
3. Incoming,
4. Issue Archive,
5. Outgoing,
6. Vendor Drawings
? Equipment
1. Equipments List,
2. Vendor Cut Sheets
? Information Logs
1. Action Items,
2. Distribution Matrix,
3. RFI’s,
4. Submittals
? Job Closeout
1. Lessons Learned,
2. Punch List,
3. Redline Notes,
4. Turnover Documents
? Pictures
? Project Schedule
? Temp
o
6. SITES
o If I choose deploy project site = yes on the form, the script would deploy our site from the template (HIPP_Project)
? Set the new site name as: Client Name_Project Number
? Set the new site category as projects
? Place your assigned Project Lead is: Project Lead Name on the front page
? Place your assigned CAD lead is: CAD Lead Name on the front page
? Place the google group iframe on a page called Correspondence [https://sites.google.com/a/domain/client Name_project number/correspondence]
? Push the Client Name, Project Number, Project Lead, CAD Lead, Location, File link Url and Site Link Url to a list on the following site list page. [page https://sites.google.com/a/domain/project /activeprojects/ ]

Skills required:
Google App Engine, Javascript, Software Architecture
Hire aaronsink
Project posted by:
aaronsink United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire GeorgeKazi
$ 250
in 30 days
$ 750
in 30 days