Daily Checklist Log

[FabriMC]

Hi everyone, basically, my idea is to be able to create a checklist for each day from the “Checklist” section. Within this, a list of predefined tasks will appear. These tasks won’t change. Here, they can be checked or unchecked as completed. However, I want these tasks to be recorded for each checklist created, since only one will be created per day. How can I do this?

I’ve seen some tutorials that save the date and you can complete them again the next day, but I want them to be saved for each checklist, basically like generating another table with the same tasks for that day.

These are the tables I have made:

[nathanaelb]

There are probably many ways of doing it. I’m assuming your checklist is a template, it is always the same checklist every day.

One approach: one table, one date per row, checklist tasks are attributes, each task has a name and checkbox (or better a timestamp).

Date	Task 1 Name	Task 1 Timestamp	Task 2 Name	Task 2 Timestamp	Task 3 Name	Task 3 Timestamp
Date 1	repeat with a single value or template	timestamp with checked	…	…	…	…
Date 2	repeat with a single value or template	timestamp with checked	…	…	…	…
Date 3	repeat with a single value or template	timestamp with checked	…	…	…	…

etc.

Data editor

1. Create a table called Dates and add 1000+ rows to it
2. Create a row ID column
3. An index column (either manually or automatically using the row IDs)
4. Then you’ll need a column with Dates: with a play with the index column, a template column set to “now” and a math column, create a column with dates starting today and then they increment by one day row by row.
5. Create a column with the “Task 1 Name” and “Task 1 Done Timestamp”. Repeat for your list of tasks.

Layout editor

1. A screen with a collection of “Dates”. Sort them from most recent, show only the last 10 instance.
2. When the user taps the date, show edit or details screen, and let the user write to the table by checking boxes. Checking a box will write the timestamp.

Something like that. The approach is not very elaborate but that would be my first go at it.

[FabriMC]

I don’t understand your explanation, and to top it off, I don’t know English.
Can you make a template? If you can, thank you.

[nathanaelb]

Are you familiar with DeepL? I use it daily. Maybe you could copy-paste my suggestion into DeepL and follow the steps in your native tongue.

DeepL Translate: The world's most accurate translator

[FabriMC]

@nathanaelb

An index column (either manually or automatically using the row IDs)

I use it, but some words lose meaning, I don’t know if I’m doing it right, this is what I understood:

[FabriMC]

I finally got it, thank you very much my friend.

This is what I did, do you know how the saving works, let’s say I want to see the tasks completed X day

[FabriMC]

@nathanaelb

Then you’ll need a column with Dates: with a play with the index column, a template column set to “now” and a math column, create a column with dates starting today and then they increment by one day row by row.

I don’t know if this is what you said, could you help me to correct it?

[nathanaelb]

For now I wouldn’t worry about getting the formulas right.

Just write a few values manually to see if you basically get the right data in the table and from it can build satisfactory layout.

Automating some of these manual values can be dealt with later.