# Help With Calendar **URL:** \ **Category:** Ask for Help\ **Created:** [February 23, 2025, 7:55pm UTC](https://community.glideapps.com/t/help-with-calendar/80286 "2025-02-23T19:55:09Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![bellwinter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bellwinter/32/85513_2.png) [@bellwinter](https://community.glideapps.com/u/bellwinter)\ **Post date:** [February 23, 2025, 7:55pm UTC](https://community.glideapps.com/t/help-with-calendar/80286/1 "2025-02-23T19:55:09Z")
I have been trying to make an app to help me take care of this garden, and with help of ChatGPT, i’ve made a table for information on the plants, and in this first table I also created columns to calculate the next time i need to water the plants and fertilize, i wanted to introduce a calendar for me to know the days i need to do each task, but the calendar options on glide aren’t really good, can any1 help me plz? ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [February 23, 2025, 7:58pm UTC](https://community.glideapps.com/t/help-with-calendar/80286/2 "2025-02-23T19:58:30Z")
What do you want to do exactly? What is your thoughts on this? What have you done so far? ---
**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:** [February 24, 2025, 11:48pm UTC](https://community.glideapps.com/t/help-with-calendar/80286/3 "2025-02-24T23:48:45Z")
I think you should create separate rows for each task that you have for your garden. Is that an option for you? ---
**Author:** ![bellwinter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bellwinter/32/85513_2.png) [@bellwinter](https://community.glideapps.com/u/bellwinter)\ **Post date:** [February 25, 2025, 11:10pm UTC](https://community.glideapps.com/t/help-with-calendar/80286/4 "2025-02-25T23:10:28Z")
I want my app to tell the user when they need to do a certain task, based on a “last day i watered/fertilized” mechanism, i’ll send screenshots along with this explanation. I have done almost everything I wanted, The Only thing i wanted to introduce was a calendar on which the tasks to do everyday would be listed, example: today is the 25th of february, i need to water the lettuce and carrots and fertilize the beetroots, and when I open my app I want it to show those tasks on today’s date, on a calendar. ![Captura de tela 2025-02-25 195111](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fcbf6eecf35e19dfd1b64ef383043b5663d16c65.jpeg) ![Captura de tela 2025-02-25 195719](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0e5b392a4909193e857ee9f5bdf1c33b7101228.jpeg) ![Captura de tela 2025-02-25 200306](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce1279997eabc2360b690f00afa740c418731b18.jpeg) ---
**Author:** ![bellwinter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bellwinter/32/85513_2.png) [@bellwinter](https://community.glideapps.com/u/bellwinter)\ **Post date:** [February 25, 2025, 11:11pm UTC](https://community.glideapps.com/t/help-with-calendar/80286/5 "2025-02-25T23:11:42Z")
I responded some1 else with more details, if u want to take a look… ---
**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:** [February 26, 2025, 12:01am UTC](https://community.glideapps.com/t/help-with-calendar/80286/6 "2025-02-26T00:01:26Z")
So I assume you manually edit the date you last watered and fertilized every time you do it? I think the only tricky thing here is you basically have 2 tasks in one row. I would construct a JSON object like this for each row: ```auto { "Task name": "Water plant X", "Date": "Add date here" }, { "Task name": "Fertilize plant X", "Date": "Add date here" } ``` Then join all rows together to form a joined JSON, separated by a comma and a newline character. Add a template column to wrap it inside square brackets. ```auto [ J ] ``` With J being the template I show in the first step. Then, add a new table, add a lot of rows, like 100, to cover just in case. Follow the steps here to create a row index. > [@Calcul entre deux rows](https://community.glideapps.com/t/calcul-entre-deux-rows/74209/2): > > Create a rowID column for your table. Create a lookup column that points to that rowID, you’ll get an array of rowIDs. Use a “find element index” column, find the rowID from the array you created above. You’ll get a list of index for each row, starting from 0. Create a math column and subtract 1 from the index. Create a single relation column linking the math column to the index column. Create a lookup column to get the mileage from the relation. Now you can subtract the lookup mileage from the… Then, you can use a query JSON column with JSONata to query out each element in that JSON array, using the index. Use that table in your calendar component. ---
**Author:** ![bellwinter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bellwinter/32/85513_2.png) [@bellwinter](https://community.glideapps.com/u/bellwinter)\ **Post date:** [February 26, 2025, 10:37pm UTC](https://community.glideapps.com/t/help-with-calendar/80286/8 "2025-02-26T22:37:53Z")
Thank u so much for the patience and all, but I just joined Glide so I don’t really know how to construct a JSON object for each row, and one for all rows joined together. Can u help me with that? Sorry for my lack of knowledge. ---
**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:** [February 27, 2025, 1:01am UTC](https://community.glideapps.com/t/help-with-calendar/80286/9 "2025-02-27T01:01:12Z")
> **[Watering Plant Schedule](https://go.glideapps.com/template/XOo8NVnfIk55KPmtYYNB-template-published?privateTemplateToken=QMr1U7DdxAa5CB2cNdVq)** Here’s a copyable app. ![CleanShot 2025-02-27 at 08.01.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39d8da938ddc9cc984281f40bd3c4fdc26012bd1.png) ---
**Author:** ![bellwinter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bellwinter/32/85513_2.png) [@bellwinter](https://community.glideapps.com/u/bellwinter)\ **Post date:** [February 28, 2025, 3:21pm UTC](https://community.glideapps.com/t/help-with-calendar/80286/10 "2025-02-28T15:21:26Z")
Thx for the help, it worked! ---
**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:** [March 1, 2025, 5:00am UTC](https://community.glideapps.com/t/help-with-calendar/80286/11 "2025-03-01T05:00:06Z")
Glad to have helped! ---
**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:** [March 8, 2025, 5:00am UTC](https://community.glideapps.com/t/help-with-calendar/80286/12 "2025-03-08T05:00:42Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.