Yes, the 0, 0 are the row, column coordinates of the cell to get the value
from. You could drop the range from the URL, but you would then likely
have to add a select statement to the query, so it doesn't make much
difference either way.
The variable "flipNumber" has the value of whatever is returned by that
query, so you can do whatever you like with it from there. Assuming it is
an <img> tag, you could insert it into your HTML inside the "flipnumbers"
div, for example:
document.getElementById('flipnumbers').innerHTML = flipNumber;
On Tuesday, October 16, 2012 3:36:12 PM UTC-4, Billy Bones wrote:
>
> Thanks for this!
>
> where you have var flipNumber = data.getValue(0,0); - is that my column
> and row that I am after info from? In which case, I could drop the
> "&range=A1" from the query url?
>
> where you say "do something with flipNumber" do you mean that the above
> function goes and gets the value, and now I can do something with it?
>
> I'm sorry that the questions are very beginner. Do I need to create a div
> to do something with the flipNumber? Do I do something inside the body? Can
> you give me a simple piece of code that would display whatever was in that
> cell?
>
> Billy
>
> On Tuesday, October 16, 2012 10:58:02 AM UTC-7, asgallant wrote:
>>
>> Ahh, ok. So basically, the implementation of the ChartWrappers using
>> query's is a bit quirky, so there isn't actually any way to get the
>> DataTable back out when doing that (at least, not when I last checked,
>> which was admittedly a long time ago). What you should do here is switch
>> to using a regular query, something like this:
>>
>> google.load('visualization', '1', {'packages': ['corechart']});
>> google.setOnLoadCallback(drawVisualization);
>>
>> function drawVisualization() {
>> var query = new google.visualization.Query('
>> https://docs.google.com/spreadsheet/ccc?key=0ArzcNGBduYipdDc3VUtSQUQ4dUNRdnVRZUYzTGRjZVE&range=A1
>> ');
>> query.send(function (response) {
>> if (response.isError()) {
>> alert('Error in query: ' + response.getMessage() + ' ' +
>> response.getDetailedMessage());
>> return;
>> }
>>
>> var data = response.getDataTable();
>> var flipNumber = data.getValue(0, 0);
>> // do something with flipNumber
>> });
>> }
>>
>> I'm not certain what will happen when you query a cell with an image in
>> it; that's not something I've ever seen done before. You should be fine if
>> it returns an <img> tag with the appropriate url, though.
>>
>> On Tuesday, October 16, 2012 1:05:57 PM UTC-4, Billy Bones wrote:
>>>
>>> Thanks ASG!
>>>
>>> I'm in over my head. I am using chart wrappers to draw the charts. I am
>>> giving them a containerId at this time. Then I am creating a div that it
>>> sits inside of. Do I scrap that to call the DataTable#getValue method or is
>>> that something I do inside of the chart wrapper? When I set up the chart
>>> wrapper to call the data table, it will import numbers into my dashboard,
>>> but I have a flip number as a jpg associated with each real number, and I
>>> was trying to bring those over from the spreadsheet. I imagine that there
>>> is a much better way to do what I am trying to do.
>>>
>>> <!DOCTYPE html>
>>> <html>
>>> <head>
>>> <meta http-equiv="Content-Type" content="text/html;
>>> charset=UTF-8"></meta>
>>> <title>Home Page</title>
>>> <!--Load the AJAX API-->
>>> <script type="text/javascript" src="http://www.google.com/jsapi
>>> "></script>
>>> <script type="text/javascript">
>>> //Load the Visualization API and the ready-made Google table
>>> visualization
>>> google.load('visualization', '1',
>>> {'packages':['corechart']});
>>> </script>
>>>
>>> <script type='text/javascript'>
>>> function drawF() {
>>> // Define the chart using setters:
>>> var wrap = new google.visualization.ChartWrapper();
>>> wrap.setChartType('Table');
>>> wrap.setDataSourceUrl('
>>> https://docs.google.com/spreadsheet/ccc?key=0ArzcNGBduYipdDc3VUtSQUQ4dUNRdnVRZUYzTGRjZVE&range=A1'
>>> );
>>> wrap.setContainerId('flipnumbers');
>>> wrap.setOptions({'title':'Total
>>> Clients','width':480,'height':410,});
>>> wrap.draw();
>>> wrap.getChart();
>>> }
>>> function drawVisualization() {
>>> drawF ();
>>> }
>>>
>>> google.setOnLoadCallback(drawVisualization);
>>> </script>
>>> </head>
>>> <body>
>>> <div id="flipnumbers"
>>> style="position:absolute;left:10px;top:0px;border:5px black
>>> solid;border-radius:25px;
>>> -moz-border-radius:25px;height:420px;width:500px;padding:6px;"></div>
>>>
>>> </div>
>>> </div>
>>>
>>> </body>
>>> </html>
>>>
>>> On Monday, October 15, 2012 3:17:33 PM UTC-7, Billy Bones wrote:
>>>>
>>>> Hi folks, I know this is child's play to most of you. I am using google
>>>> docs forms to populate google docs spreadsheets which populate a dashboard
>>>> of google visualization charts on my website. There are times when I would
>>>> just like to take one number from a spreadsheet and post it to my site in
>>>> a
>>>> customized way. Ideally, I could use large "flip chart" style numbers to
>>>> display the number in my google docs spreadsheet. I am able to place a
>>>> table on my site to get the information there, but I would like to be able
>>>> to draw individual numbers from my spreadsheet in stylized colors, sizes,
>>>> or fonts. Any ideas for me?
>>>>
>>>> Billy
>>>>
>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/0asmqUFJ44IJ.
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.
