The range is correct and chart is updated after 2 minutes or more Roni Segoly 0546466264 On 26 Jun 2014 17:00, "Andrew Gallant" <[email protected]> wrote:
> If you open the page and leave it alone to update by itself, does it > eventually get the new data? > > Your query string specifies a range on the spreadsheet (B1:I104); is your > new data in that range? > > On Thursday, June 26, 2014 1:43:34 AM UTC-4, Roni Segoly wrote: >> >> As far as I can see it sends requests to server and no update reason >> not_modified >> >> >> >> >> >> >> *Roni Segoly * >> >> *+972-54-6466264 <%2B972-54-6466264>* >> >> >> * >> <http://s.wisestamp.com/links?url=tel%3A%252B972-54-6466264&sn=cm9uaS5zZWdvbHlAZ21haWwuY29t>*יוזמה >> פרויקטים חברתיים וסביבתיים בע"מ <http://www.yozma.net/> >> >> Yozma - social & environmental projects <http://www.yozma.net/> >> >> >> >> >> Google+ Page [image: Google Plus Page] >> <https://plus.google.com/u/0/+RoniSegoly/about> >> >> * <http://en.wikipedia.org/wiki/Mohandas_Karamchand_Gandhi>* >> >> >> On Wed, Jun 25, 2014 at 10:42 PM, Roni Segoly <[email protected]> wrote: >> >>> It shows all right but brings me to another issue >>> I created a chart and embedded it in HTML >>> And also displayed it as table query using the URL within >>> >>> http://docs.google.com/spreadsheet/tq?key=0Am19V2tYPHDHdE1wbG5QLVJ2NUowU >>> TBrODFGc3REbVE&transpose=0&headers=0&range=A1%3AD1&gid=0&pub=1 >>> >>> But then when I changed the data in the spreadsheet it was not updated >>> in the table query nor in the chart, so no matter how often the chart in >>> HTML is refreshed the data is not refreshed >>> >>> So back to the method I use today.I use Python and PHP to extract the >>> cell values and return it and build the chart on the fly, for charts that I >>> want to show immediate changes, and use your proposed method for charts I >>> do not need to show immediate udpats >>> >>> >>> >>> >>> >>> >>> *Roni Segoly * >>> >>> *+972-54-6466264* >>> >>> >>> * >>> <http://s.wisestamp.com/links?url=tel%3A%252B972-54-6466264&sn=cm9uaS5zZWdvbHlAZ21haWwuY29t>*יוזמה >>> פרויקטים חברתיים וסביבתיים בע"מ <http://www.yozma.net/> >>> >>> Yozma - social & environmental projects <http://www.yozma.net/> >>> >>> >>> >>> >>> Google+ Page [image: Google Plus Page] >>> <https://plus.google.com/u/0/+RoniSegoly/about> >>> >>> * <http://en.wikipedia.org/wiki/Mohandas_Karamchand_Gandhi>* >>> >>> >>> On Wed, Jun 25, 2014 at 9:54 AM, Roni Segoly <[email protected]> wrote: >>> >>>> Will try again today >>>> >>>> Roni Segoly >>>> 0546466264 >>>> On 24 Jun 2014 21:04, "Andrew Gallant" <[email protected]> wrote: >>>> >>>>> It works for me: http://jsfiddle.net/asgallant/DPET3/ >>>>> >>>>> On Tuesday, June 24, 2014 1:10:08 PM UTC-4, Roni Segoly wrote: >>>>>> >>>>>> If I add it, it will not display at all. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> *Roni Segoly * >>>>>> >>>>>> *+972-54-6466264* >>>>>> >>>>>> >>>>>> * >>>>>> <http://s.wisestamp.com/links?url=tel%3A%252B972-54-6466264&sn=cm9uaS5zZWdvbHlAZ21haWwuY29t>*יוזמה >>>>>> פרויקטים חברתיים וסביבתיים בע"מ <http://www.yozma.net/> >>>>>> >>>>>> Yozma - social & environmental projects <http://www.yozma.net/> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Google+ Page [image: Google Plus Page] >>>>>> <https://plus.google.com/u/0/+RoniSegoly/about> >>>>>> >>>>>> * <http://en.wikipedia.org/wiki/Mohandas_Karamchand_Gandhi>* >>>>>> >>>>>> >>>>>> On Tue, Jun 24, 2014 at 7:36 PM, Andrew Gallant <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> I suspect that all you need to do is add a "refreshInterval" >>>>>>> property to the object in the script tag: >>>>>>> >>>>>>> <script type="text/javascript" src="//ajax.googleapis.com/aja >>>>>>> x/static/modules/gviz/1.0/chart.js"> >>>>>>> {"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0ArVG >>>>>>> QYDunAPqdEFiMFZuZTJGXzd4Zm55a3ZlcUd0ZGc&transpose=0&headers= >>>>>>> 1&range=B1%3AI104&gid=9&pub=1","options":{"titleTextStyle":{ >>>>>>> "bold":true,"color":"#000","fontSize":16},"vAxes":[{"title":null," >>>>>>> useFormatFromData":true,"minValue":null,"viewWindow":{" >>>>>>> min":null,"max":null},"maxValue":null},{"useFormatFromData":true," >>>>>>> minValue":null,"viewWindow":{"min":null,"max":null}," >>>>>>> maxValue":null}],"title":"\u05e9\u05d3\u05d4 >>>>>>> \u05d1\u05d5\u05e7\u05e8 \u05d5\u05d2\u05d3\u05e8\u05d5 >>>>>>> \u05ea","curveType":"","booleanRole":"certainty","height": >>>>>>> 371,"animation":{"duration":0},"legend":"right","width":600, >>>>>>> "lineWidth":2,"hAxis":{"useFormatFromData":true,"minValue":null," >>>>>>> viewWindowMode":null,"viewWindow":null,"maxValue": >>>>>>> null},"tooltip":{}},"state":{},"view":{},"isDefaul >>>>>>> tVisualization":false,"chartType":"LineChart","chartName":"Chart2"," >>>>>>> refreshInterval":60} >>>>>>> </script> >>>>>>> >>>>>>> refreshInterval takes an integer for the number of seconds between >>>>>>> updates. >>>>>>> >>>>>>> On Tuesday, June 24, 2014 6:04:40 AM UTC-4, Roni Segoly wrote: >>>>>>>> >>>>>>>> Google spreadsheet enable publishing charts as images or >>>>>>>> interactive scripts such as the example at the bottom >>>>>>>> >>>>>>>> When I include the script in HTML it is displayed as expected, but >>>>>>>> not updated at all or after many minutes >>>>>>>> In this page I included HTML refresh which is ugly solution >>>>>>>> http://212.150.200.169:84/combo3.php >>>>>>>> >>>>>>>> I can build the charts on my HTML page but when I need lots of data >>>>>>>> or nice design features it's easier to build on the sheet itself >>>>>>>> >>>>>>>> I have the below example where chart is built in PHP page and only >>>>>>>> data is retrieved and then refreshed and it's nice solution >>>>>>>> http://212.150.200.169:84/g.php >>>>>>>> >>>>>>>> So the question >>>>>>>> For the below script can I use draw function based on the content >>>>>>>> of the script? For me it's Greek >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> <script type="text/javascript" src="//ajax.googleapis.com/aja >>>>>>>> x/static/modules/gviz/1.0/chart.js"> >>>>>>>> {"dataSourceUrl":"//docs.google.com/spreadsheet/tq?key=0ArVG >>>>>>>> QYDunAPqdEFiMFZuZTJGXzd4Zm55a3ZlcUd0ZGc&transpose=0&headers= >>>>>>>> 1&range=B1%3AI104&gid=9&pub=1","options":{"titleTextStyle":{ >>>>>>>> "bold":true,"color":"#000","fontSize":16},"vAxes":[{"title":null," >>>>>>>> useFormatFromData":true,"minValue":null,"viewWindow":{" >>>>>>>> min":null,"max":null},"maxValue":null},{"useFormatFromData":true," >>>>>>>> minValue":null,"viewWindow":{"min":null,"max":null}," >>>>>>>> maxValue":null}],"title":"\u05e9\u05d3\u05d4 >>>>>>>> \u05d1\u05d5\u05e7\u05e8 \u05d5\u05d2\u05d3\u05e8\u05d5 >>>>>>>> \u05ea","curveType":"","booleanRole":"certainty","height":37 >>>>>>>> 1,"animation":{"duration":0},"legend":"right","width":600," >>>>>>>> lineWidth":2,"hAxis":{"useFormatFromData":true,"minValue":null," >>>>>>>> viewWindowMode":null,"viewWindow":null,"maxValue":null >>>>>>>> },"tooltip":{}},"state":{},"view":{},"isDefaultVisualizati >>>>>>>> on":false,"chartType":"LineChart","chartName":"Chart2"} >>>>>>>> </script> >>>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to a topic in >>>>>>> the Google Groups "Google Visualization API" group. >>>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>>>>>> pic/google-visualization-api/Jqvk7dytThc/unsubscribe. >>>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>>> [email protected]. >>>>>>> To post to this group, send email to google-visua...@googlegroups. >>>>>>> com. >>>>>>> Visit this group at http://groups.google.com/group >>>>>>> /google-visualization-api. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "Google Visualization API" group. >>>>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>>>> topic/google-visualization-api/Jqvk7dytThc/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at http://groups.google.com/ >>>>> group/google-visualization-api. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "Google Visualization API" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/google-visualization-api/Jqvk7dytThc/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
