You're welcome. I appreciate the offer, but I wouldn't feel right accepting money. If you'd like to help, pay it forward instead; give someone else a hand when he or she is stuck.
On Wednesday, April 10, 2013 9:45:23 PM UTC-4, Isaac Paulsen wrote: > > got it ! the XML feed worked! thanks! what is your paypal email so I can > push you some money! > > On Wednesday, April 10, 2013 7:27:56 PM UTC-6, Isaac Paulsen wrote: >> >> here is my site that I am trying to get it to run on, here is the page, >> http://sandscout.com/hcar2 when you click on the link it just reloads >> the page? >> >> On Wednesday, April 10, 2013 6:54:40 PM UTC-6, asgallant wrote: >>> >>> Hmmm...I can view the link you posted, but the query URL still says >>> access denied. >>> >>> Here's a version that uses the XML feed: >>> http://jsfiddle.net/asgallant/JrDkK/2/ >>> >>> Note that this version uses jQuery to handle the AJAX request to fetch >>> the XML and to parse it for the URL; you don't have to use jQuery - it can >>> be written in other libraries or as vanilla javascript. >>> >>> On Wednesday, April 10, 2013 7:41:35 PM UTC-4, Isaac Paulsen wrote: >>>> >>>> Th sheet is published @ >>>> https://docs.google.com/spreadsheet/pub?key=0Ag7YUwVcZvsRdEZyZC1OZjJsbVJVOEZmWXVQQ29FT1E&single=true&gid=0&output=html >>>> >>>> I tried to put this into my site... dose not seem to be working.... any >>>> ideas? >>>> >>>> >>>> <a href="" id="myLink">This is the target link</a> >>>> >>>> <script >>>> google.load("visualization", "1", {packages:["corechart"]}); >>>> google.setOnLoadCallback(getURL); >>>> >>>> function getURL () { >>>> var query = new google.visualization.Query(' >>>> https://docs.google.com/spreadsheet/tq?range=B1&key=0Ag7YUwVcZvsRdEZyZC1OZjJsbVJVOEZmWXVQQ29FT1E&gid=0&headers=-1' >>>> ); >>>> query.send(function (response) { >>>> if (response.isError()) { >>>> alert('Error in query: ' + response.getMessage() + ' ' + >>>> response.getDetailedMessage()); >>>> return; >>>> } >>>> >>>> var data = response.getDataTable(); >>>> document.getElementById('myLink').href = data.getValue(0, 0); >>>> }); >>>> } >>>> >>>> </script> >>>> >>>> >>>> I also have " <script type="text/javascript" async="" src=" >>>> https://ssl.google-analytics.com/ga.js";></script>" place on the header >>>> of my site... >>>> >>>> Is there a way to get the url by using this feed? >>>> https://spreadsheets.google.com/feeds/cells/0Ag7YUwVcZvsRdEZyZC1OZjJsbVJVOEZmWXVQQ29FT1E/od6/public/basic/R1C2 >>>> I see that the url is found in the <content type='text'> >>>> http://www.woot.com/</content>" portion on the feed? >>>> >>>> >>>> Any ideas? really trying to get this to work, I will seriously paypal >>>> you money if I can get this to work! it has been driving me crazy! >>>> >>>> thanks >>>> >>>> >>>> On Wednesday, April 10, 2013 2:46:59 PM UTC-6, asgallant wrote: >>>>> >>>>> Here's an example: http://jsfiddle.net/asgallant/JrDkK/ >>>>> >>>>> That should work, but I can't test it since your spreadsheet isn't >>>>> published. >>>>> >>>>> On Wednesday, April 10, 2013 2:32:36 PM UTC-4, Isaac Paulsen wrote: >>>>>> >>>>>> would you mind posting a javascript example with the link to the >>>>>> google doc spreadsheet like I provided?!!! >>>>>> >>>>>> thanks for you help >>>>>> >>>>>> On Wednesday, April 10, 2013 12:17:40 PM UTC-6, asgallant wrote: >>>>>>> >>>>>>> You have to use javascript to fetch the data, but once you have the >>>>>>> URL, you can embed it in a link as the href parameter. >>>>>>> >>>>>>> On Wednesday, April 10, 2013 1:48:29 PM UTC-4, Isaac Paulsen wrote: >>>>>>>> >>>>>>>> I have a similar problem, I have a google spread sheet that I am >>>>>>>> using as a data source. I have url( or links) in the cells of the >>>>>>>> spread >>>>>>>> sheet. I would like to have a button on my external web site use the >>>>>>>> link >>>>>>>> that is found in the cell on the google spreadsheet. Preferably with a >>>>>>>> just >>>>>>>> some type of url, or would I have to use Javascript on my site? >>>>>>>> >>>>>>>> I have this that returns the information about a particular cell.. >>>>>>>> https://docs.google.com/spreadsheet/tq?range=B1&key=0Ag7YUwVcZvsRdEZyZC1OZjJsbVJVOEZmWXVQQ29FT1E&gid=0&headers=-1 >>>>>>>> >>>>>>>> that is getting the value as a data source, when you past that into >>>>>>>> a browser you get back the info about the data source. and you see >>>>>>>> htat the >>>>>>>> cell value is = "v" which is = "www.woot.com" which is just an >>>>>>>> example of a url. >>>>>>>> >>>>>>>> any help would be much appreciated. >>>>>>>> >>>>>>>> On Monday, April 2, 2012 6:59:29 PM UTC-6, Philco wrote: >>>>>>>>> >>>>>>>>> I'm doing a project to create a website with a chart of donations, >>>>>>>>> like a big rising thermometer in a sidebar and then have the total >>>>>>>>> number of donations displayed in a h1 tag. >>>>>>>>> >>>>>>>>> I'm using the Visualization API to create a Column Chart from a >>>>>>>>> Google >>>>>>>>> Spreadsheet and embed it on a site. That works great. >>>>>>>>> >>>>>>>>> Next, I want to display the contents of a single cell on the site >>>>>>>>> in >>>>>>>>> an h1 tag and style it. >>>>>>>>> >>>>>>>>> What's the best way to do this? Do I create a >>>>>>>>> visualization.DataTable >>>>>>>>> and then style away all the tr tags? >>>>>>>>> >>>>>>>>> Thanks! >>>>>>>>> >>>>>>>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
