After skimming through the docs and looking through the posts on this forum, it's obvious to me that it would take more time than I have to do this, so I'm wondering if there is any existing code available that I could modify or if someone would like to make a few dollars to write this for me:
We have a google docs spreadsheet with a long list of items, each item having a key value (4 or 5 letter code) and a number of cells related to the status of that item. We have an internal application that works on the local data related to those items (data not shared in a google doc) and the interface to that application is a web browser (IE). I can add links and scripts to the web page served to the browser by the application when a worker is viewing a given item. I'd like to be able to add a link or button to that web page, such that when a worker clicks it, the google docs spread sheet is searched for the corresponding items record, and a cell in that line is changed to reflect a new value. It strikes me that this might be a fairly common need: A web page that can update a docs spread sheet by searching for the correct line, then changing a cell value. I do see at least one post in this forum where someone is working on the basic idea of interacting with a spread sheet from client only code, but they haven't published a result and the sample code doesn't search the spreadsheet to find the row to update. If that code exists, I'd very much appreciate someone pointing me to it, and if you think you can write that code for a reasonable price, my boss might just approve the payment. Thanks for taking the time to read this.
