Static data in controls

10 views
Skip to first unread message

mary m

unread,
Jan 29, 2016, 11:48:06 AM1/29/16
to Google Visualization API
I am creating charts using data from a google form to google sheets. Some of the form options are multi select which has wreaked havoc on my controls. Is there a way to have a static list in the control of the values in the list? 

Example:
Form allows multi select from:
  • hamburger
  • hot dog
  • chicken
  • veggies

Now my control filter looks like this (based on what users have selected in the form).
  • hamburger
  • hamburger, hotdog
  • hamburger, veggies
  • hotdog
  • hotdog, chicken
  • hotdog, veggies
  • chicken
  • chicken, veggies

I know I can build my own controls in javascript and pass them into the query but hoping to avoid that if something exists already! Or if there are better ideas!
Reply all
Reply to author
Forward
0 new messages