Hello everyone. I haven’t been with SeaTable long and am currently working on the calendar. I’m wondering how to display birthdays in the calendar. How do I generate recurring appointments? Thank you for your help.
Lödi
Hi @Loedi.
A simple way could be to create a column with the original date of birth. You could then create a second column of type formula, concatenate the day and month with the current year and use that as the next birthday date.
Something like:
The original column: BD = 16.08.1999
The formula column: date(day({BD}), month({BD}), year(today())) = 16.08.2023 (should be)
1 Like
There is no option to mark an event as recurring in SeaTable. Sorry for that.
This is a simple and straightforward workaround.
1 Like
Thank you for your help. But the result is unfortunately not quite right. What am I doing wrong. Thanks again…
Hi Loedi,
I tested it as well and the resulting birth date is completely wrong as well.
Haha, nice. It’s the wrong way. It has to be date(year, month, day).
1 Like
Yup, that’s the one.
Your code should be:
date(year(today()), month({Geburtsdatum}), day({Geburtsdatum}))
The year should be “today” as you want the current year. months and days are extracted from the Geburtsdatum column
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
