How do I allow users to create their own private or public to-do lists? And track what’s been completed. I want to link it to Google Tasks, but I don’t know if that’s possible. Or other to-do apps. Also, I want to make Daily, Weekly, Monthly, etc. lists. Do I create a template that they can revise? Thanks.
1 Like
Google Tasks does offer an API, but I’d be wary of maintaining a two-way sync with an external service. Same for other to-do apps.
I would just build this in Glide. Do you have access to a paid plan that can use workflows? That can be helpful with building daily/weekly/monthly tasks, but there might be workarounds worth exploring.
Your structure can be like this:
Users Table
| ID | Name | |
|---|---|---|
| U001 | Kelly | kelly@email.com |
| U002 | Alex | alex@email.com |
Lists Table
| ID | UserID | Name | IsPublic |
|---|---|---|---|
| L001 | U001 | Home | FALSE |
| L002 | U001 | Work | TRUE |
| L003 | U002 | Fitness | FALSE |
Tasks Table
| ID | ListID | Name | Type | IsCompleted | DueDate |
|---|---|---|---|---|---|
| T001 | L001 | Drink water | Daily | TRUE | 2025-07-09 |
| T002 | L001 | Check emails | Daily | FALSE | 2025-07-09 |
| T003 | L002 | Finish report | Weekly | FALSE | 2025-07-10 |
| T004 | L003 | Weigh-in | Monthly | FALSE | 2025-07-31 |
How this works:
- Each user (Users) can have multiple lists (Lists).
- Each list contains tasks (Tasks).
- Each task has a Type (Daily, Weekly, Monthly, etc.), which you can use for automation or recurring logic.
- You can show users their Daily, Weekly, or Monthly tasks, or to automate the creation of new tasks based on type (using Workflows)
3 Likes