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.

Compétences : Moteur Google App, Javascript

en voir plus : 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, Google Sheet Script, google script spreadsheet, google google docs, google docs is, docs.google.docs

Concernant l'employeur :
( 2 commentaires ) Austin, United States

Nº du projet : #1012599

Décerné à:


Please check PM.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 10 jours
(17 Commentaires)

4 freelance font une offre moyenne de $238 pour ce travail


I can deliver the same using the google data API

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(21 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)