Apps Scripts limits what you can do intentionally to avoid security issues. They might loosen up the restrictions if security can be assured, but you'll have to write to the Apps Scripts folks to get more info on all that.
On Thu, Jan 12, 2017 at 5:59 PM, Dat Viz <[email protected]> wrote: > Thank you for the reference Daniel, > Unfortunately, when I went here > <https://developers.google.com/apps-script/reference/charts/pie-chart-builder> > and tried to create a pie chart, I found a couple of problems.... > first the UiApp is depreciated, so I can't really follow the example > (something Google should take the time to update), and I also found that > when I tried to create a pre-defined array, the > google.visualization.arrayToDataTable > function wouldn't seem to accept a pre-defined array. It seemed that you > had to create static values in the app itself. It doesn't help if you are > trying to make the application flexible to the user so they can select an > array they would like to visualize. I might be doing something wrong here, > but that seems very limiting. I searched around a bit to see if there was > some example somewhere of someone plugging a pre-defined array into the > google.visualization.arrayToDataTable() function, but to no avail. Is > that not allowed? > > On Monday, December 19, 2016 at 10:16:56 PM UTC-8, Dat Viz wrote: >> >> I am a fairly new Apps Script Programmer, so I apologize in >> advance for any questions that might seem obvious to advanced users. I >> looked here >> <https://developers.google.com/chart/interactive/docs/gallery/controls#preparedata> >> to >> learn how to build a dashboard for a Google Sheet. I was able to use some >> apps script that I tested in the Script Editor to crate an array. I seemed >> to follow most of the HTML conventions suggested thus far, but when I got >> to Step 5 I noticed that the options one could specify when setting up >> either a ControlWrapper or ChartWrapper. I clicked on the links specified >> there, but the ControlWrapper >> <https://developers.google.com/chart/interactive/docs/gallery/controls#controlwrapperobjectrtwrapperobject> >> page, >> and the ChartWrapper >> <https://developers.google.com/chart/interactive/docs/reference#chartwrapperobject>page >> didn't really go into the properties; they described the methods that could >> be called. I don't know why Google wouldn't report these, but I am finding >> they leave a lot of information out for you to just figure out on your own. >> Perhaps there is an assumption that one has done some web programming, but >> I haven't so again please excuse any ignorance on my part. Does anyone know >> where I can find a list of the options that can be set for these two >> classes? >> Also, I really didn't see anywhere on the page that showed you >> how to test whether the separate HTML file had worked. I would assume if I >> am making this as an added dashboard to a Google sheet, I would go to >> Publish →Deploy as Sheets web add on, but I wasn't sure. Lastly, in the >> example, they give hand typed/programmed arrays in there, while I used a >> script to populate an array. I was wondering if I would need to push >> categorization for all columns to the top of the array? I can share the >> script I added if this is helpful. I am just a little confused by this >> write up, as it doesn't really "fill in all of the blanks". Thanks for any >> help! >> > -- > 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 google-visualization-api@ > googlegroups.com. > Visit this group at https://groups.google.com/ > group/google-visualization-api. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/google-visualization-api/d28cf49c-873a-456a-aeed- > 1f66a958f6c9%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/d28cf49c-873a-456a-aeed-1f66a958f6c9%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge 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 https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJNorXs7hVysQwTOzNE9YbR829zxy%3D_tX7KFBKnxWcwWrQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
