Thanks again Daniel,
I have been trying to break down simpler code. I even tried a
basic "Hello World" HTML screen which did work. It is when one starts
implementing script that the problem comes in. I believe that is exactly
what it is with Google Apps Script, that you need to have a security
certificate as you had mentioned once you get to the point that you are
using scripts. I just don't understand why they removed the UiApp class if
they were not going to have something better than this. Thanks for your
help, at least I was able to pinpoint the problem (I believe). Maybe I can
come up with some resourceful workaround until I hear back on Stack
Exchange or from the folks at Google.
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 [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/fa34a677-322b-46d4-8c44-613b86e806ea%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
