Guide
Google handles public holidays from all countries nicely, so you can use it as a source of Public Holidays in Fibery (for any reason).
For example, you can build an automation that sends messages to Slack about a vacation.
In a Google Account you can subscribe to many calendars, click +, then Subscribe to Calendars and then Browse Calendars of Interest. For example, in this account we have holidays from three countries.
We recommend to setup a different set of Databases for public holidays to not mix them with usual Events.
Create new Google Calendar Sync just for Holidays.
Rename All Day Event to Holiday.
Create proper visualizations
Create a new Calendar or Timeline View, and select Holiday as an item.
🧱 Advanced. Connect Holidays to Countries
Let's see how to link your Holiday database to the Countries database in Fibery. By making this connection, holidays will automatically be associated with the correct country, and you’ll be able to enrich your Holiday entities with additional context such as country flags.
Sync Countries into Fibery - Go to some Space, click Integrate and select World. Configure the sync and you will have a list of Countries.
Now we need to connect Holiday and Country automatically - First we will extract country name from Calendar Name. Go to Calendar database and create a new Formula Country Name with a formula text Replace(Name,"Holidays in ","")
Create a new Relation between Calendar and Country - Set Automatically link Calendars to Countries checkbox and select Country Name for Calendar and Common name for Country Database.
Create a new Lookup field in Calendar from Country to extract flag.
Go to the Holiday Database and create a new Lookup field to see the Country Flag on a Holiday entity.
As a result, you will be able to display Country Flag on all Holiday entities, like this:
🧱 Advanced. Create an automation rule to send holiday notification to Slack
Let's find how to set up an automation rule that posts daily holiday notifications to a Slack channel. This way, your team will always stay aware of upcoming holidays without manually checking the database.
Go to Holidays database, click Automations and create a new On Schedule rule, like this
Connect Slack account and send a message to some public channel, like this
You can use this Syntax as a reference. 🌴{{Country.Flag}} {{Name}} ({{Country.SlackPeople}})
🌴 Understanding the Syntax
The message template uses dynamic placeholders to pull data from your Fibery databases into Slack messages:
🌴 – just a static emoji you add for style.
{{Country.Flag}} – inserts the flag of the country linked to the holiday (from the Country database).
{{Name}} – inserts the name of the holiday itself.
({{Country.SlackPeople}}) – here we use custom field that inserts the people (Slack users) connected to the country, so they are notified in Slack. Make sure you have a similar one
Example Output:
🌴 🇵🇱 Independence Day (@anna @michal)
This way, each Slack message will automatically include a flag, holiday name, and relevant people to mention.