In Progress

Google Spreadsheet reading datas from MySQL

I need to create Google Spreadsheet so It will allow me to do this :

1, The spreadsheet will read datas stored on MysQL server and load into rows/columns

2, When I Enter specific SKU code into "reading" field in spreadsheet, it should connect with SQL server, and return a possible products in list. When I choose certain product, it will fill up another cells with its datas (description, price, unit,etc..)

When entering datas into quotation, I want to see a collapsed view : 1 row for 1 product. But sometimes if I need I should be able to view it in different view too : each product should have loaded a thumbnail too (loaded from eshop based on MySQL) .

Basicaly the same option should have customer too if sent by "share link or publish to web" : to see both collapsed and "unfolded" version.

I will be happy to change the functionality if better solution can somebody suggest, I require this, because I have similar template in MS Offce already and it works fine, but I want the sharing feature and more flexibility. I have a MS office template working, which I will be happy to provide to understand it more deeply..After project succesfull I have many other features to implement as another projects.

A existing template in MS Office with Macro function is in attachment, we sort of want similar functionality, but if better solution will be presented I will be happy to change our specification. The Search box could be best if always in that "grey field on left"....The Macro function I think can be done in Google more intelligent way, maybe some button "switch view" to switch between template view available for both us and customers might be best....similar as "Publish to web-as web" function, shows different sheets clickable with "Menu" style....this might be usefull for both parties....
See MS Excell file in attachment ....existing solution which we want to update to "Google + MySQL".

The Macros in MS Excell did the following action :
when pressed CTRL+M it went through the thumbnail library for specific product SKU(library contained SKU code + names of pictures attached to it : SKU / thumbnail1/ Thumbnail 2 /Thumbnail 3/ Thumbnail 4) , and inserted pictures into the Excell for each product line. This way we had reached the "Unfolded view" as we needed (pictures were not present at the time of entering datas, it shows pictures only after all work had been done, and pressed CTRL+M).
Now this could be made thanks to "different unfolded view" with whatever functions, scripts, etc..I am open for suggestions....

Skills: Google App Engine, MySQL

See more: sql server price list, publish google spreadsheet to web, google spreadsheet web app, spreadsheet google, office web app server, row spreadsheet, reading, google suggest, customer spreadsheet, spreadsheet price list, office app 2013, create google spreadsheet, spreadsheet columns, spreadsheet template, quotation engine, mysql web spreadsheet, product eshop, google app enter, mysql spreadsheet, google publish, google app mysql, google spreadsheet code, google engine app, option spreadsheet, spreadsheet sql server

About the Employer:
( 2 reviews ) Banska Bystrica, Slovakia

Project ID: #4236692

Awarded to:

Viqtor

Hi, can help.

€350 EUR in 4 days
(13 Reviews)
4.9

3 freelancers are bidding on average €350 for this job

chirgeo

Hi! Seems interesting project. Google Apps Script is a powerful tool and I think we can accomplish what you need. Contact me and we'll discuss more details.

€300 EUR in 5 days
(11 Reviews)
5.3
GeorgeKazi

Hi! Please see your inbox.

€400 EUR in 2 days
(10 Reviews)
4.4