# A Diary app with Calendar, Reminders and Notes for the Glide community

**URL:** https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172
**Category:** Project Showcase
**Created:** [February 1, 2020, 3:43am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172 "2020-02-01T03:43:48Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)
#### Post date: [February 1, 2020, 3:43am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/1 "2020-02-01T03:43:48Z")

</div>

I’ve whipped up this demo Diary app for anyone to copy and adapt however they want. It’s a cut down version of my own bullet journal app.

[https://demodiary.glideapp.io/](https://demodiary.glideapp.io/)

The point of it - besides being useful - is to demonstrate a few tricks and techniques, including:

- ArrayFormula() (See _Show on Today_ in the _Calendar_ sheet)
- A Settings page
- Dynamic Categories (optionally create when adding new _Calendar_ entry, _Reminder_ or _Note_)
- Using Sheets’ sort() function (see _Categories_ and _Sorted Settings_)
- Using Sheets’ unique() function (_Categories_)
- Relation columns
- If - then - else columns
- Template columns
- Using a _Choices_ sheet for multiple choice types. (When choices may be added to - like Categories - use a separate sheet)
- Using HTML
- Using sheet formulas
- Use of Glide filters and sorting

Hope you find it useful

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 1, 2020, 7:35pm UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/2 "2020-02-01T19:35:14Z")

</div>

Nice work! That could be useful for me.

---

<div class="post-metadata">

### Author: ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)
#### Post date: [February 6, 2020, 4:51am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/3 "2020-02-06T04:51:53Z")

</div>

V1.0.1

- Have used the new inline style of the Choices component on the Type and Priority fields.
- Have also used it on the About page to have tabs for About and Change log

![CleanShot 2020-02-06 at 15.49.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/98a9e1cc1659395d3b58d3676fa129774fa76f01.png)  
 ![CleanShot 2020-02-06 at 15.58.24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9af81f3e50cee651b9f5b1568334a48da2eca3b5.png)

---

<div class="post-metadata">

### Author: ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [February 6, 2020, 7:04am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/4 "2020-02-06T07:04:51Z")

</div>

@chrishoward that’s amazing!

Now I got it how you did it without the “-“ on the left lol

Just selecting “Required”. Simple and fantastic 👌🏼

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d85fb50e609c9083c7aff91bf8fa521501b690f7.jpeg)

---

<div class="post-metadata">

### Author: ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)
#### Post date: [February 6, 2020, 8:56am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/5 "2020-02-06T08:56:28Z")

</div>

@Lucas_Pires: Firstly, currently, that only works when you use this style Choices component on a static page (i.e. it doesn’t work on the Add or Edit pages). Though they are going to fix that.

Secondly, you have to set the component to “Required”

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [February 6, 2020, 9:28am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/6 "2020-02-06T09:28:49Z")

</div>

To fix, or not to fix, that is the question… In some case, the dash could be useful. For example, the choice component is used to filter an inline list. The dash, by default, could be used to display the whole list without any filter, and the other entries to filter based on a condition or category.

---

<div class="post-metadata">

### Author: ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)
#### Post date: [February 6, 2020, 9:31am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/7 "2020-02-06T09:31:23Z")

</div>

But then you would have an option on the component that says, include “all”. It’s much better than using a dash.

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [February 6, 2020, 9:32am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/8 "2020-02-06T09:32:31Z")

</div>

Much better, not sure. You will have to add calculation within your sheet or the data editor to create this “all” condition or filter. So additional cpu…

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [February 6, 2020, 9:33am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/9 "2020-02-06T09:33:40Z")

</div>

Moreover, it would be “all” in some cases, “nothing” in other cases.

---

<div class="post-metadata">

### Author: ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)
#### Post date: [February 6, 2020, 11:31am UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/10 "2020-02-06T11:31:49Z")

</div>

Yeah, I don’t like that the only way to remove it is by using “required”. I’d like to be able to use the Inline Choices sometimes without making the field required.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 6, 2020, 12:58pm UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/11 "2020-02-06T12:58:38Z")

</div>

That’s the whole point of required though. If required is checked, then there shouldn’t be a blank (dash) option because you are required to pick one of the choices. If a choice is not required, then you should have the option to unselect your choice.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [February 6, 2020, 3:27pm UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/12 "2020-02-06T15:27:47Z")

</div>

Nice work @chrishoward!

---

<div class="post-metadata">

### Author: ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)
#### Post date: [February 6, 2020, 11:30pm UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/13 "2020-02-06T23:30:47Z")

</div>

Ah, indeed, @Jeff_Hager very true.

However, a much tidier UI when the choices component is set “not required” than dash option, is the ability to deselect all “buttons”. Click-on click-off.

This type of UI is how multi-check checkboxes work when they’re “not required”.

So, rather than a visually untidy dash for no selection, I request the Glide devs just allow deselecting to nothing selected. @david

---

<div class="post-metadata">

### Author: ![dina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dina/32/3152_2.png) [@dina](https://community.glideapps.com/u/dina)
#### Post date: [February 7, 2020, 11:01pm UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/14 "2020-02-07T23:01:18Z")

</div>

Great work! Will learn from this.

---

<div class="post-metadata">

### Author: ![akjackson25](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@akjackson25](https://community.glideapps.com/u/akjackson25)
#### Post date: [March 3, 2020, 9:49pm UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/15 "2020-03-03T21:49:10Z")

</div>

This is extremely helpful! Thank you so much for building this out!

---

<div class="post-metadata">

### Author: ![RedHeadKev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/redheadkev/32/2821_2.png) [@RedHeadKev](https://community.glideapps.com/u/RedHeadKev)
#### Post date: [March 3, 2020, 10:36pm UTC](https://community.glideapps.com/t/a-diary-app-with-calendar-reminders-and-notes-for-the-glide-community/4172/16 "2020-03-03T22:36:53Z")

</div>

Thanks for sharing!  
Looks smooth and easy to use. I might add some of this to a conference app in the future.
