Program a google spreadsheet to sort form data

I have a Google Docs Spreadsheet that I use for workflow. I also use a form to collect bids and their category for each job. The bid information from the forms is collected in one of the sheets (Bid Form Submissions). I have another sheet (Bid Intake) that consists of various categories and cells for 3 bids in each category. I would like a script that will collect the form information (from Bid Forms Submission sheet) and input it in the correct category on the Bid Intake Sheet. It would need to determine whether or not a bid has already been entered in the 1st bid location for that particular category. If so, it would need to be placed in the 2nd location. The same would follow if there were already bids in the first 2 categories. It would also need to be able to run each day to look for new bids that have been submitted without overwriting the older bids.

Evner: Google App Engine, Javascript

Se mere: google form data, script sort data google spreadsheet, sort google spreadsheet form, workflow one, use script in google spreadsheet, spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, script sheets, script google spreadsheet, script for google forms, new spreadsheet app, job spreadsheet, google. docs, docs. google, app script spreadsheet, app script form, spreadsheet google script sort, spreadsheet google

Om arbejdsgiveren:
( 2 bedømmelser ) Austin, United States

Projekt ID: #1012599

Tildelt til:


Please check PM.

$250 USD in 10 dage
(17 bedømmelser)

4 freelancere byder i gennemsnit $238 på dette job


I can deliver the same using the google data API

$250 USD in 4 dage
(21 bedømmelser)

Hello, i have a good experience with Google Spreadsheets automation and Google Forms based systems. Best Regards.

$250 USD in 5 dage
(0 bedømmelser)

I'll be glad to work for you and get it done. thanks!

$200 USD in 10 dage
(0 bedømmelser)