Concession Stand Prices using Google Spreadsheet Widget

  • 1
  • Question
  • Updated 3 years ago
  • Answered
I am working on displays for my school and I have no knowledge of HTML.  I am currently working on the concession prices for ballgames and can get the very basic look that you get when creating the widget.  Can someone help me or walk me through an "easy" way to brighten it up cosmetically.  
Photo of Shaun Hicks

Shaun Hicks

  • 82 Points 75 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Hi Shaun,

I'm going to let someone in the Content team know about your question. They may have some suggestions for you!
Photo of Biologyben


  • 3,558 Points 3k badge 2x thumb
Have you seen the templates?  (Presentations > New from Template)  There is a landscape (and vertical) menu board example there.

It is done mainly with text items, but you could place the spreadsheet widget in these placeholders (and delete the text gadget).  Only use full dollar amounts as the cents will round.

Then you can replace the image at the top with your school logo, replace the backdrop with one you prefer, replace the pictures of food with food you are serving at the stand (fresh fruit perhaps?)  
That is probably the easiest way to get started with no HTML know how.
Photo of Alan Clayton

Alan Clayton, Official Rep

  • 8,788 Points 5k badge 2x thumb
If you format the cells for "Plain Text" the decimal values should show as entered into your Spreadsheet. 
Photo of Biologyben


  • 3,558 Points 3k badge 2x thumb
Good to know!
Photo of Biologyben


  • 3,558 Points 3k badge 2x thumb
Just to dissect that template a bit - This is the background it is using (under the 'Settings' Gear icon for the presentation)*RiseVisionTemplates/Menu/landscape/images/t-menu-2-lands...

The rest is in basic place holders (Text & Image) Change some or all of these as you need to make your presentation work.

Here is a preview of the same template set-up to pull from THIS Google Spreadsheet with different graphics.  
Photo of mlm

mlm, Official Rep

  • 4,624 Points 4k badge 2x thumb
Hi Shaun,

To cosmetically enhance the look the first thing I would try is adding a background image behind your content and as Biologyben mentioned you could just take one from our already existing templates or create your own in photoshop, illustrator, sketch or any graphic program that can output a .jpg or .png. 

I think the next thing to look at would be the font choice / color. When you select your font in the widget settings you will notice there is an option for "more fonts". These are google fonts and I suggest using these to break away from the all too common standard web fonts. Try using a big bold easily readable font for the heading and a clean simple font for the numbers like open sans. I would make sure you use a very high contrasting color that stands apart from the background.

The rest of the work will be in laying out your prices and items. I might suggest searching on dribbble for "menu board" for inspiration.

We have a gallery on dribbble of some of our work, although we don't yet have a menuboard.

Also If you are new to Rise Vision I'd suggest taking a look at this article:
Photo of Shea

Shea, Official Rep

  • 5,188 Points 5k badge 2x thumb
Hi Shaun,

Just to add to what Mat said, check out this article for a bunch of free design resources that can help you chose font, colours, and has free stock photos you can use in your menu board:

Photo of Darius -

Darius -, Champion

  • 26,850 Points 20k badge 2x thumb
Ask a student, gifted in arts and HTML, to help you out with that.