How to write to other tables (Not just User profile) - using list with checkbox behavior

Hi everyone,

I’m trying to build a daily task list with Glide using the Collection List component (because there’s no other lists). and I want the user to be able to:

  1. Tap an item to mark it as complete
  2. That task should disappear for the rest of the day
  3. then reappear the next day

I was shown a YouTube video where the builder could write data to any table, but in my case, when I try to add an action or set column values, I can only see User Profile as an option, even if I source it to a table I made,

I already have:

  • a task table (premade tasks)
  • a task completion log table
  • user email, current date, status column set up

I would love help with:

  • How can I write to task completion log when someone taps a task in the list
  • how can I filter the list so that it only shows uncompleted tasks for that user for today. and the next day it refreshes and shows all the tasks again
  • and how to show the boolean for a list

Any help or step-by-step tips would be appreciated! I’m very new to this but loving it so far :orange_heart:

-PleaseLaugh

1 Like

You can:

  • Add a “last completed” datetime column to the tasks table, I assume users have their own tasks, so you don’t need to have this column as user-specific. If users share tasks, make it user-specific.
  • On a click, set the current datetime value to the column above.
  • Add an if-then-else column to that same table. Call it “visible”.

If “Last completed” is empty then true.
If “Last completed” is within today then false.
Else true.

  • Filter the collection by “Visible” is checked.
2 Likes

Please show us how you configure your tables and a screenshot of how you see your actions.

Add an add row action to the workflow I mentioned above (after setting the current datetime value to “Last Completed”.

Not sure why you need this, checked tasks will not be visible anyway, is that correct?

1 Like

this is how I configured my table:
List of task completed table:

And how the table of just daily tasks, with relation to the task I’ve completed:

and to add rows,
each column I have to enter a value, like for item name etc. what do I do with these?
what does that mean? I’ll show you, it looks like this:

As for boolean, I want my user to feel good to click on that check mark, and when checked it disappears, if it’s too hard to do it with collection list, I guess I’ll just have to use collection checklist, but if I could do it with list then that would be great, so I can add a different icon for each task

I worked on it for the entire day on Tuesday, and it’s not working, at least yesterday the other task I was working on is working, yay! (it was in another post)

anyways, hopefully today I can get the checklist going, I think now I’m making it so complicated, is there a lean way of doing it? if not, hope it can at least be working

thanks

1 Like

How do I made a last completed datetime column? do I just make a math column and make it “now”?

1 Like

An update in what I did, I successfully matched the two tables between the list of tasks and task completion log with a template:

Hopefully it works, right now when I test fill in one row it’ll match all 3 rows, but at least it worked a little bit

and I filter the matched data, saying if there’s a matched data then it won’t show

and it did hide the matched data (which is all of them for now)

what needs to happen is:

  1. when I click on it it logs on to the completed task table, and there’ll be a match, and it’ll disappear
  2. not everything matches everything, just the task that has the same value would match, like “drink water” only matches with “drink water”, “sleep” only matches with “sleep”

once that’s solved hopefully we can add a boolean or place for check mark so it looks nice.

if add boolean is impossible for a list, I can use checklist instead

if someone can walk me through how to do this, or if you have any other way to do this, either way I would really appreciate it! thanks! >__<!

I did it! I figured it out from your suggestions!!!

Now I’m facing a new problem which I’m not sure if I should make a new post or post it here

the new problem is:

I have a list of tasks the user can choose from, shown in a collection list component when the user taps the + button, they open a screen where they can select which task to show

I want to give them two options:

  • a confirm button to save their new choices
  • a cancel button to discard their choices

to do this, I added a temporary choice Boolean. the user toggles that while in the overlay. if they press confirm, I want to copy the temporary value into the real “selected” boolean that controls task visibility

But the problem is: Glide won’t let me select the temporary column in the confirm button’s action. it only shows columns from the User Profile, not the actual task list. So now I’m stuck.

Is there a way to make this work? thank you so much :folded_hands:

In my original suggestion, my vision for the tables is this:

Tasks Table

Task ID Task Name Last Completed (user-specific) Visible (if-then-else)
T001 Drink Water 2025-07-03T08:00:00Z TRUE
T002 Sleep Early TRUE
T003 Meditate 2025-07-04T06:00:00Z FALSE

Task Completion Log Table

Log ID Task ID User ID Completed At
L001 T001 U001 2025-07-03T08:00:00Z
L002 T003 U002 2025-07-04T06:00:00Z

Users Table

User ID User Email Name
U001 user@email.com Alice
U002 test@email.com Bob

Each click in the task table would do this:

1 Like

So each Task in the Task table is unique to a user? Is that what you mean?

Or is it a field in the Users table where you have users select which pre-made tasks are shown in their profile?

I want to understand the intention here before making further suggestions.

1 Like

I am trying to let user select which task they want to do daily by putting the list in the + button link for the collection ( the previous problem is solved with your suggestions, thanks! now is the new task extended from the previous one, which is to click a + button to add more tasks)

So the user can choose from my whole list which task they want to choose,

I currently figured out how to make the confirm button confirm their choices, which is I figured out how to let the temporary boolean save to the selected boolean, which I made the selected boolean the ones that will show up for the users.

But now there’s a new problem: The confirm button can’t have a second action to close the overlay caused from clicking the + button, means it can’t save and then close, it only saves, and it doesn’t close the overlay >__<! what should I do?!