Completed

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

This project was successfully completed by GeorgeKazi for $250 USD in 30 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$250 - $750 USD
Completed In
30 days
Total Bids
2
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,”@[url removed, login to view]”]

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, [url removed, login to view], “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#@[url removed, login to view]]

? 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 [[url removed, login to view] 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 [url removed, login to view] /activeprojects/ ]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online