Hi! On a related note, I have users fill out a form that enters data into a spreadsheet, and they are then forwarded to a page that graphs responses. Frequently, their response is not shown on the graph because of the five minute publishing delay. Is there any way around this?
Thanks, Hamilton On Nov 26, 11:19 am, Pragan <[email protected]> wrote: > Thanks Mr.Viz! > > It worked. I selected the option "automatically.." and it works > > thanks > pragan. > > On Nov 26, 12:13 pm, VizGuy <[email protected]> wrote: > > > I guess it has to do with the way you publish the data in your > > spreadsheet.Note > > that when you publish data, you can select auto publish, that will update > > the published version every 5 minutes, or you can publish it once, and then > > any changes will only be reflected in the published version once you > > Re-Publish manually. > > > Is this the case? > > > VizGuy > > > On Wed, Nov 26, 2008 at 6:52 PM, Pragan <[email protected]> wrote: > > > > Please reply me as I have to plan other things based on this answer!!! > > > Sorry ! > > > > thanks > > > pragan. > > > > On Nov 25, 4:14 pm, Pragan <[email protected]> wrote: > > > > hi, > > > > > I am just trying this very basic example and have a question about the > > > > data displayed. For example, I just have five symbols in my > > > > spreadsheet and having 3 datapoints(price,low,high). I am trying to > > > >querythe spreadsheet using visulaization api(table package) to show > > > > the result back in the browser(range or individual cell). > > > > > I can see that data is updated in the spreadsheet which is good, but > > > > even if I refresh my browser the values doesn't change. I tried > > > > clearing thecache/cookies if that can be one reason. > > > > I couldn't think of any reason why its not changing even if you > > > > refresh. I can understand that it cannot refresh itself once its on > > > > the browser. At-least, manual refresh should show the current values > > > > from the spreadsheet. The values that I am seeing now are from Friday. > > > > (Nov 21). Can you please explain why this is happening? > > > > > Please see this example: > > > > <html> > > > > <head> > > > > <script type="text/javascript" src="http://www.google.com/jsapi";></ > > > > script> > > > > <script type="text/javascript"> > > > > google.load('visualization', '1', {packages: ['table', 'map', > > > > 'columnchart']}); > > > > google.setOnLoadCallback(initialize); > > > > > function initialize() { > > > > varquery= new google.visualization.Query('http:// > > > > spreadsheets.google.com/pub? > > > > range=E4&headers=-1&key=paMPZbgrLy26_fkHVnLkCSg&gid=3'); > > > > > query.send(handleQueryResponse); > > > > > function handleQueryResponse(response) { > > > > > if (response.isError()) { > > > > alert('Error inquery: ' + response.getMessage() + ' ' + > > > > response.getDetailedMessage()); > > > > return; > > > > } > > > > > var data = response.getDataTable(); > > > > var table = new google.visualization.Table(document.getElementById > > > > ('table_div')); > > > > table.draw(data, {showRowNumber: true}); > > > > var chart = new google.visualization.PieChart(document.getElementById > > > > ('chart_div')); > > > > chart.draw(data, {width: 400, height: 240, is3D: true});} > > > > } > > > > > </script> > > > > </head> > > > > <body> > > > > <div id="table_div" style="width: 700px; height: 240px;"></div> > > > > </body></html> > > > > > thanks > > > > pragan. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
