You are here:
< Back

Scenario:

Lets say, you want to display the upcoming birthdays of your staff, with their names, birth dates, images and some personalized message.

 

Solution:

1., At first create your google spreadsheet with the following columns and fill the table with some sample data

 

BirthDate Name Picture Age Message
09.18 Faith Edmundsss https://img3.stockfresh.com/files/k/kurhan/m/91/390405_stock-photo-happy-woman.jpg (22) Faith! God bless you!
10.09 Victor Smith https://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 (23) 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 2am

function myFunction() {
ss = SpreadsheetApp.getActiveSpreadsheet();
sheet = ss.getSheetByName("Sheet1");
var d = new Date();
var month = '0' + (d.getMonth()+1);
var day = d.getDate();
var range = sheet.getRange("A2");
var value = range.getValue();
var cellMonth = value.substring(0,2);
var cellDay = value.substring(3,5);
if (cellMonth == month && cellDay < day){
sheet.deleteRow(2);

}

}
Here is a 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.

 

 

5., 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 than import a sample content from here.

 

6., Test your content and fill it with actual information and data before using it in a live environment

 

7., Maintain your spreadsheet every day and fill it with the upcoming birth dates
Comments are closed.