Hi, Simple Up Finally, I found two workarounds 1 - pushing the code on an HTML page with Html Direct service from the script editor on the worksheet (public read access) http://goo.gl/RKOP5N 2 - by hosting my "web folder" (JS file, CSS file and the html page) directly on Google Drive ... http://goo.gl/ftGrvm The two solutions work very well ... just be connected with a Google Account to the first solution (apps script) Thank you again ...
Le mercredi 17 décembre 2014 06:43:39 UTC+1, Jean Gorene a écrit : > > Hi Daniel, > Thank you for your comments. > I 've also test on another sheet which I do not own containing a little > more data and I do not really have this problem, the graphics are > apparently all the time available without user login. Unfortunately I can > not share this spreadsheet. I've done the same way for both leaves, but > I'll try to watch where can be the difference. The script is the same but > only longer and repetitive. > Anyway, working with this API, it is really very interesting ... thank you > again > > Le mardi 16 décembre 2014 20:20:45 UTC+1, Daniel LaLiberte a écrit : >> >> Hi Jean, >> >> It sounds like you are experiencing an issue with authenticating the user >> for access to your spreadsheet to retrieve data. The access restrictions >> will eventually time out and the user will have to log in again. Google >> Charts is not able to open a login dialog to gain access to the >> spreadsheet, at least not yet, so you will have to do it another way. >> Perhaps offer a link to the spreadsheet directly that the user must open >> first. >> >> On Sat, Dec 13, 2014 at 3:15 AM, Jean Gorene <[email protected]> wrote: >> >>> Hello everyone, >>> >>> I use the API to create controls and dashboards with data from a >>> spreadsheet that receives responses from a form ... great! >>> I am doing some tests to have a little more dynamic graphics by >>> preparing some data tabelau before ... >>> >>> it works well for a while ... >>> >>> - but as long as the spreadsheet is opened or a user sends a response >>> - If we let the closed spreadsheet ... after a while ... it looks >>> like the data is not "accessible" and generates me error message? >>> >>> >>> The code should be optimized and probably missing some have a parameter >>> to call the data or perhaps an additional token ?? >>> I was fine to look on the forum and on the web ... difficult for me to >>> find an answer >>> >>> link : FSfidle <http://jsfiddle.net/jeang/cjyjtsb8/6/> and spreadsheet >>> <https://docs.google.com/spreadsheets/d/1apfEk2rTcNPyhpyoQFpuWdsFRsIYphOYau64jlBUFDI/edit?usp=sharing> >>> (I'm >>> french sorry ;) >>> >>> Any idea or help welcome! >>> >>> -- >>> 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. >>> >> >> >> >> -- >> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >> - 978-394-1058 >> [email protected] 5CC, Cambridge MA >> [email protected] 9 Juniper Ridge Road, Acton MA >> > -- 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.
