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.

Taidot: Google App Engine, MySQL

Näytä lisää: sql server price list, publish google spreadsheet 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

Projektin tunnus: #4236692

Myönnetty käyttäjälle:


Hi, can help.

350 € EUR 4 päivässä
(13 arvostelua)

3 freelanceria on tarjonnut keskimäärin 350 € tähän työhön


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 5 päivässä
(11 arvostelua)

Hi! Please see your inbox.

400 € EUR 2 päivässä
(10 arvostelua)