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....