Closed

Google Gadget (retrieval form)

I would like to have a Google gadget developed that will take an existing input form created using using google forms and turn it into a retrieval/update form. It is very straightforward to create an input form in Google docs but the data is written to a spreadsheet and the form design controls the order of the columns and you cant rearrange the order of the columns without messing up the input form. This makes it nearly impossible to analyze large form data using the list view, pivot table feature, and/or other gadgets. Here are some features I would like to see for the first release:

- User selects form spreadsheet from there google documents they want to retrieve and/or update data from

- User can drag and drop fields (i.e. column headings) onto gadget they want to retrieve data from

- USERS MUST BE ABLE TO ARRANGE THE FIELDS ANYWHERE THEY WANT ON THE VIEW

- Every field (equal to column name in spreadsheet) on form is a drop down showing existing values in the spreadsheet or the drop down is filtered by what the user types into the field. Example: If I have 1000 rows of data and one of my fields is last name, I can either (1) click down arrow and it shows every value for that column or (2) start to type the value I want and the values in the drop down narrow to only show those values that contain what I typed

- Would like a button to press that allows Edits to be made to the retrieved record. When Button is clicked and edit mode is entered, a submit button is enabled at the bottom of the view

- Would like to be able to print/export the retrieval form

A FEW QUESTIONS/UNKOWNS I HAVE

1) if there are one thousand records and I select "Taylor" in the last name field, and there are 25 entries with the last name "Taylor" how is it displayed? If I then go to first name field and select "John" I would expect the retrieval form to filter by a combination of everything I have selected a value for and populate all of the fields I haven't selected a value for with the query results

Feel free to ask questions or get additional information as needed

Skills: Google App Engine, PHP, Python, Software Architecture

See more: edit google forms data, using google spreadsheet, taylor design, submit press release google, python get type, pivot design, list get python, google spreadsheet example, get press release written, spreadsheet google, arrow up, take google, google forms, click google, create google spreadsheet, drop filter fields, google query, create form using google, form data, google select, export google forms, forms update example, selected records, php drag drop form, php pivot

About the Employer:
( 0 reviews ) Hanover, United States

Project ID: #1282657

2 freelancers are bidding on average $235 for this job

martinchrli

PLEASE CHECK PMB

$250 USD in 9 days
(0 Reviews)
0.0
steveEathelyn

HELLO SIR PLEASE CHECK PMB

$220 USD in 4 days
(0 Reviews)
0.0