Jan 20, 2024 07:44 PM
I have a field where people can enter a birthdate. I want that to show up on a calendar view in Airtable. Unless the year is the current year, it's not showing up on the calendar. I tried using a formula field but then I can't get the formula field to show up on the calendar.
How do I get it so people can enter the actual birthday say 2-6-68 but have it show up on a Feb 2024 calendar view in airtable? Also, do I need to do anything different so that in 2025 it would show up in Feb calendar view?
Apr 01, 2024 03:07 AM
you'll need the team version for this, and you can automate it with date dependency set to+365.25 from that date date with the number of repetitions as needed (example+10 times... or so..
Apr 01, 2024 04:08 AM
“Date dependencies” is the name of a feature in Airtable, which doesn’t handle repetitions nor birthdays. Date dependencies link records together that already have start dates & end dates for project planning.
Unfortunately, there is no built-in feature of Airtable to create repeating calendar events such as annual birthdays.
You could manually do it, though, You could create the first 2 birthday records for a person, and then create a bunch of blank records underneath that, and then drag down the lower right corner of the birthday cell to autofill the rest of the records.
Otherwise, you would need to figure out some sort of an automation that creates all the records that you want. Possibly by writing a custom JavaScript to do this.