Scenario:

You want to display the upcoming birthdays of your staff. You want to include their names, birth dates, images, and some personalized messages.

Solution:

1. First create your Google spreadsheet with the following columns and fill in the table with some sample data

Birthdate : 09.18

Name : Faith Edmundsss

Picture https://img3.stockfresh.com/files/k/kurhan/m/91/390405_stock-photo-happy-woman.jpg

Age : 22

Message : Faith! God bless you!

Birthdate : 10.09

Name : Victor Smith

Picturehttps://thumb9.shutterstock.com/display_pic_with_logo/818215/558986872/stock-photo-single-handsome-muscular-black-man-with-shaved-head-folded-arms-and-cheerful-expression-558986872.jpg

Age : 23

Message : Vick! God bless you!

Example: here.

2. Create a Google Script for handling the spreadsheet and create a� trigger that will run the script automatically every day at 2 am
Here is documentation about GoogleScript.
3. Publish your spreadsheet on the web and add it as a datasource into our system
You can find more information about these steps here.
4. Create a new content and use the datasource elements to create the content to your own liking that will display your data
  • You can use the image element to display images from your datasource
  • You can use the text element to display texts from your datasource
With both elements you need to use the Datapicker function to select the row and column from your datasource
You can download and import a sample content from here.
5. Test your content and fill it with actual information and data before using it in a live environment
6. Maintain your spreadsheet daily and fill it with the upcoming birth dates
ABOUT WALLBOARD

Leverage Wallboard's powerful suite of tools to create, automate, and manage dynamic digital signage that your audience will remember.

Ready to Get Started?

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.