Birthday

[Glitch]

How can I create a Calendar for Birthdays? 

[AnchovyXL]

Hi,

You must have a table that stores the birthdays to create a Calendar  for birthdays,  Then, use that table as the source. Select the filed that corresponds to the Birthdate.

Also, please refer to this article: https://howto.caspio.com/datapages/calendars/

Hope this helps.

[Glitch]

Hi Anchovy!

 

I know that's how we select Datasource to a table. But Regarding Birthdays, how do we get to disregard them "year"?

The calendar would not let me choose the precision of date and month. http://prntscr.com/lr7b6e

So basically, I want the birthday to show Every Year.

[ManokNaPula]

I replicated this on my end and below is the solution that I came up with. Please follow these steps:

1. Edit your Employes table and add a new Formula field
2. Add the formula:

CONVERT(DateTime,(CAST(Month([@field:date_de_naissance]) AS nvarchar(2))+'/'+CAST(Day([@field:date_de_naissance]) AS nvarchar(2))+'/2018'),101)

3. Edit your Birthdays - employees - calendar DataPage and proceed to Calendar Page Options

4. Choose the "Formula" field as Date Field.

Note: The formula provided works for the year 2018, for the next year you need to update it manually to 2019

You may need to statically update the Year for this, as annual calendar report will not be possible yet.