allright now i have what i want. this is what i am talking about.. http://www.region3dfg.org/lands/1802-2005-020-03
gadget has the data source hardcoded in and queries a preset field for a value then reformats the results to a nice little report to insert in a google sites page. here is the gadget http://hosting.gmodules.com/ig/gadgets/file/110038818703520461296/reg3_spreadsheet_row-report1.xml now what i need... 1. how can i, in javascript, get the page url and parse it to get the page name. i.e...1802-2005-020-03 for the link above 2. API access to google sites so i can create a page programatically..like at the consummation of a form 3. templates in google sites 4. ability to query based on column label would be nice since it would be more robust overall, but no big deal P.s. junkies at the mystic.. http://www.archive.org/details/cj2007-04-15.SPC4.flac16 On Nov 5, 4:15 pm, Region 3 DFG <[EMAIL PROTECTED]> wrote: > Thanks, i added the gadgetHelper back in but i must have some more > leftovers > and i installed firebug but i havnt figured out how to use it yet > ill keep trying > > do you know of an example out there of a gadget that utilizes.. > > var query = new google.visualization.Query('http:// > spreadsheets.google.com/tq?key=<your key here>&pub=1'); > > instead of having the user set it. > > i just want to grab one row from my spreadsheet and reformat it into a > html table > should be easy but so far i have been flailing around > i have been reading all of the forum posts and examples i can find > but i have yet to find one that really helps me get started > > On Nov 5, 3:35 pm, VizGuy <[EMAIL PROTECTED]> wrote: > > > Hi, > > Just looked at your last post that I assume is related to this question. > > I used the following url to run the gadget on my > > browser:http://04q24a0a-a.gmodules.com/ig/ifr?url=http://hosting.gmodules.com... > > > Then you can see that you get a javascript error (I recommend FireBug for > > javascript debugging and for any other web development related problems). > > The error is that you refer to gadgetHelper, but it is not defined. > > > This is because you manipulated the original code, but there are some > > "leftovers" from the original code. > > > You should define gadgetHelper as it was done in the original code. > > You don't have to use it in order to create the query, adn you can still use > > it to validate the response, but you have to define it: > > > var gadgetHelper = new google.visualization.GadgetHelper(); > > > I believe this will do the trick. > > > And to the specific question - yes, simple Query.send() should also work > > from gadgets. > > > Regards, > > VizGuy > > > On Tue, Nov 4, 2008 at 5:25 PM, Region 3 DFG <[EMAIL PROTECTED]> wrote: > > > > im trying to build a simple gadget using the visualization api and > > > spreadsheets > > > > i started with this tutorial > > > http://code.google.com/apis/spreadsheets/spreadsheet_gadgets.html > > > > from which i took this.. > > > http://www.google.com/ig/modules/spreadsheet.xml > > > > and i created this gadget > > > >http://hosting.gmodules.com/ig/gadgets/file/110038818703520461296/r3-... > > > using the GGE (which seems really buggy in firefox 3 i have to say) > > > > to use with this spreadsheet.. > > > http://spreadsheets.google.com/tq?key=pLhehESOjqJuwxn2M-YzmbA > > > > all i want to do is hard code the spreadsheet in instead of having the > > > user set it when the gadget is added to a google sites page. so i > > > followed this.. > > > http://code.google.com/apis/visualization/documentation/queries.html > > > > here is my test page on google pages... > > > http://region3.dfg.googlepages.com/test2 > > > > the top gadget is the one from the tutorial (spreadsheet_gadgets.html) > > > with the above spreadsheet set as the data source and the one on the > > > bottom is my gadget with that spreadsheet as the data source. mine > > > doesnt work it just spins and spins. anybody have an idea what i have > > > done wrong --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
