Easily display birthdays with templates which are available at the App Gallery.

The name and date information source can be a Google Sheet or a Data Feed. One Birthday App can be fed with a Google Sheet alone, several other designs take data from a Data Feed.

Birthday Announcement App with data from a Google Sheet

For starters, we show you the common Birthday Announcement App which takes input from the Google Sheet. Changes in the Google Sheets are automatically updated on your signage. We start with the instructions on how to create the Google Sheet (A), then how to set up the app (B).

(A) Birthday Spreadsheet

We list all birthdays in the Google Spreadsheet and share it with the signage platform. Note, that the document must be shared with "Anyone with the link" so data is fetched by the platform. Viewing permissions are enough.

1. In your Google Drive, click on "New" in the top-left corner, and then select "Google Sheets" on the drop-down menu.
2. In the new Sheet, enter the names and birthday dates in separate columns. An order is not necessary.
   
3. The date should follow one of these formats:
   • MM/DD/YYYY
   • DD/MM/YYYY
   • YYYY-MM-DD
4. When you are done writing down the birthdays, share the document. Click on the "Share" button in the top-right corner. Another route is the "File" menu on the top-left >"Share" > "Share with others".
5. Change the General Access from "Restricted" to "Anyone with the link".
   
6. The Drive provides an URL by clicking at the button "Copy link".

(B) Creating the App

Now, we will leave the Google Drive aside and go back to your OnSign TV account.

1. Click on "New" and choose "App" from the drop-down menu.
2. From the sidebar menu, select the "Meeting Room & Calendar" category. Here you find all Birthday Apps. The Birthday Announcement App is the one you can use with just a Google Sheet. The other templates are Data Feed enabled. They work in similar ways, but you have more options to provide your data to the App.
   The Birthday Announcement App contains the text "Birthday Announcement" on one half of the App. Next to it, you see a list of names and birthdates.
   
3. Name the app and paste the Google Sheet URL from before.
4. Select how long each birthday will be displayed on screen and also limit the amount of dates you want to display. It can be today's, this week's, or this month's birthdays.
5. Make sure to fill the following fields according to the Sheet you have just created:
   • Date format: MM/DD/YYYY or DD/MM/YYYY or YYYY-MM-DD
   • Name column: In the example above, we inserted all names in column A.
   • Birthday column: In our example, all dates are in column B.
   • Rows to fetch: We wrote down only 7 birthdays, but we will request the App to look at 20 rows for when we add more birthdays in the future. This way, the new info will be synchronized with the screens, even if we don't adjust the row setting in the App.
6. Customize the App to your preference, like changing background and font color, and modifying animations.

Data Feed enabled Birthday Apps

The Birthday Announcement App design is also available in a Data Feed enabled version.

Further designs you can use with Data Feeds are the three Happy Birthday Apps: Happy Birthday has a similar look as the Birthday Announcement App, but it shows the text "Happy Birthday!" on one half of the App and one birthday at a time with a cake image on the other side.  Then, there are the Apps Happy Birthday - Elegant and Happy Birthday - Enterprise.

OnSign TV Academy - Apps