Google Spreadsheet reading datas from MySQL
This project was successfully completed by Viqtor for €350 EUR in 4 days.Get free quotes for a project like this
Project Budget€250 - €750 EUR
Completed In4 days
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online