En cours

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

Voir plus : google form data, sort google spreadsheet form, workflow one, use script google spreadsheet, spreadsheet script google, spreadsheet script, spreadsheet javascript, script sheets, script google spreadsheet, script google forms, new spreadsheet app, job spreadsheet, app script spreadsheet, app script form, spreadsheet google script sort, spreadsheet google, google sheet script, google script spreadsheet, spreadsheet input, spreadsheet 2, google sheet, google forms, google app sheets, form data, javascript spreadsheet

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

N° du projet : #1012599

Décerné à :

sritechnocrat

Please check PM.

250 $ USD en 10 jours
(17 Commentaires)
5.7

4 freelance ont fait une offre moyenne de 238 $ pour ce travail

srinichal

I can deliver the same using the google data API

250 $ USD en 4 jours
(21 Commentaires)
5.2
joaojordy

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

250 $ USD en 5 jours
(0 Commentaires)
0.0
LionTheKing

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

200 $ USD en 10 jours
(0 Commentaires)
0.0