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 [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/3f9940fd-903b-4add-a358-34b114792cbd%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
