# Help With Calendar

**URL:** <https://community.glideapps.com/t/help-with-calendar/80286>\
**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:** 1\
**Showing post:** 6

<div class="post-metadata">

**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")

</div>

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.

---

_[View the full topic](https://community.glideapps.com/t/help-with-calendar/80286)._