Help With Calendar

[bellwinter]

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?

[MaximeBaker]

What do you want to do exactly? What is your thoughts on this?

What have you done so far?

[ThinhDinh]

I think you should create separate rows for each task that you have for your garden. Is that an option for you?

[bellwinter]

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.

[bellwinter]

I responded some1 else with more details, if u want to take a look…

[ThinhDinh]

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:

{
"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.

[
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

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.

[bellwinter]

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.

[ThinhDinh]

Watering Plant Schedule

Here’s a copyable app.

[bellwinter]

Thx for the help, it worked!

[ThinhDinh]

Glad to have helped!