# Calendar with user-specific computed dates **URL:** \ **Category:** Ask for Help\ **Created:** [August 5, 2025, 4:59am UTC](https://community.glideapps.com/t/calendar-with-user-specific-computed-dates/83652 "2025-08-05T04:59:33Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Nislin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nislin/32/90975_2.png) [@Nislin](https://community.glideapps.com/u/Nislin)\ **Post date:** [August 5, 2025, 4:59am UTC](https://community.glideapps.com/t/calendar-with-user-specific-computed-dates/83652/1 "2025-08-05T04:59:33Z")
Hey everyone, I’m building an app for young parents who’s baby is about to arrive our has just arrived and one of the features I want to offer is a calendar that would show important dates for various mom and child’s test, doc’s visits, vaccinations and so on. So far I have two “key” dates - date of conception and date of child birth and I have about 20 “important dates” that should be computed based on one of those dates (I also have offset period for each date if that matters). Ofcourse each user will provide their own “key dates” (in user profile settings during initial onboarding) and right now I’m struggling to create a table that would enable me do that. As I understand date of conception and date of birth should be in Users table as columns (along with name, email, d.o.b, etc.) but how should the “Events” table look like so that every user can have a calendar with dates recommended particularly for them? ---
**Author:** ![Nicolas\_Joseph](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicolas_joseph/32/76105_2.png) [@Nicolas\_Joseph](https://community.glideapps.com/u/Nicolas_Joseph)\ **Post date:** [August 5, 2025, 7:13am UTC](https://community.glideapps.com/t/calendar-with-user-specific-computed-dates/83652/2 "2025-08-05T07:13:16Z")
Hi @Nislin 🙂 First of all, congratulations on your baby. And welcome! You perfectly describe the expectations and the way to get to the point ( **`Users`** table to store unique dates for each user, **`Key Dates`** to make it dynamic and easy to maintain…). So, here’s the last steps to get to the result: 1. Add two columns in the **`Users`** table to store `Date of conception` (DoC) and `Date of birth` (DoB) data (as you mentioned) 2. Create a **`Key dates`** table with - for the moment - at least 3 columns: 3. Add a _Query_ column to retrieve the `Active User`: 4. Retrieve the `DoC` and `DoB` data for this specific user thanks to 2 new _Lookup_ columns. Here’s the set up of `DoC` (just duplicate it and change DoC to DoB for the second one…): 5. Create two new _Math_ columns to calculate targeted dates. This will be `DoC + duration` and `DoB + duration` in this walkthrough: 6. Lastly, find which is the correct date to display using a _If → Then → Else_ column (`DoC or DoB`): You should obtain something like this. Dates for each event is related to the values available in the active user profile row so everything is totally dynamic here: ![Key dates](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fe2907aeb4cc0b638b6da2f94ec6397afc03132b.png) > Originaly, I created the _If → Then → Else_ column prior to the 2 _Math_ columns to optimize the logic. However, when I tried this, the result of the calculation was not relevant, probably due to casting operations. Because date calculations could become very tricky and it’s only adding one more column here, I totally assume this choice 😃 Let us know if this works as expected! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 5, 2025, 11:24pm UTC](https://community.glideapps.com/t/calendar-with-user-specific-computed-dates/83652/3 "2025-08-05T23:24:10Z")
That’s a clever suggestion! ---
**Author:** ![Nislin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nislin/32/90975_2.png) [@Nislin](https://community.glideapps.com/u/Nislin)\ **Post date:** [August 7, 2025, 4:25am UTC](https://community.glideapps.com/t/calendar-with-user-specific-computed-dates/83652/4 "2025-08-07T04:25:36Z")
Hey @Nicolas_Joseph , that is exactly what I was looking for! Huge thanks to you for such a detailed instruction!🙏 I spent several hours trying to find a solution on YouTube, Chatgpt and Glide’s AI assistance and just got the result by following your guide, thank you once again, sir!🫠 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [August 14, 2025, 4:26am UTC](https://community.glideapps.com/t/calendar-with-user-specific-computed-dates/83652/5 "2025-08-14T04:26:13Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.