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.