Google Form/Spreadsheet expert - repost

CLOSED
Bids
7
Avg Bid (USD)
$166
Project Budget (USD)
$30 - $250

Project Description:
We have created 2 google forms. These forms populate to 2 spreadsheets, A & B. A= "CRA Responses" B="LCRA Responses"
Spreadsheet B's data is imported automatically into spreadsheet A, all in one tab so they can be compared in a row. Although the import occurs, I believe these rows must be indexed and matched so that the whole row is bookended to it's respective row, linked into one row using the data found in column titled "Report Title" (seen in both CRA Responses and LCRA Responses".
The row data includes email addresses, dates, and text.
In general, here are the problems:
1) 2 forms will submit 2 different sets of data, where one unique id in the data is the text (limitations of text matching is understood). We want these sets to line up on one row in a summary tab.
2) After submitting a form, google forms allows the user to see a url which allows users to return for edits in the future. I'd like to automatically collect this url each time a form is submitted.
2) Lastly, we want a script which sends an email reminder to an email address in the spreadsheet if certain conditions are not met. (ie: a cell is not populated)
We intend to pay $25USD for the project.
Please download a copy to your google drive to imbed formulas: https://drive.google.com/folderview?id=0B_yooTrVfU9Va25zTEE2Q3RZVDQ&usp=sharing
Please submit screenshots of your local project to prove the project is complete. please replay with dear ben.
-Ben

Skills required:
Data Entry, Excel, Google App Engine
Hire benluke
Project posted by:
benluke 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.


$ 66
in 2 days
$ 55
in 1 days
$ 111
in 1 days
Hire GeorgeKazi
$ 68
in 2 days
$ 30
in 1 days
$ 55
in 2 days
$ 777
in 7 days