# How to write to other tables (Not just User profile) - using list with checkbox behavior **URL:** \ **Category:** Ask for Help\ **Created:** [July 2, 2025, 7:26pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899 "2025-07-02T19:26:55Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\ **Post date:** [July 2, 2025, 7:26pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/1 "2025-07-02T19:26:55Z")
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 🧡 -PleaseLaugh ---
**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:** [July 2, 2025, 11:23pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/2 "2025-07-02T23:23:01Z")
> [@PleaseLaugh](#): > > 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 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. ---
**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:** [July 2, 2025, 11:25pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/3 "2025-07-02T23:25:12Z")
> [@PleaseLaugh](#): > > 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, Please show us how you configure your tables and a screenshot of how you see your actions. > [@PleaseLaugh](#): > > How can I write to task completion log when someone taps a task in the list Add an add row action to the workflow I mentioned above (after setting the current datetime value to “Last Completed”. > [@PleaseLaugh](#): > > and how to show the boolean for a list Not sure why you need this, checked tasks will not be visible anyway, is that correct? ---
**Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\ **Post date:** [July 3, 2025, 12:23pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/4 "2025-07-03T12:23:59Z")
this is how I configured my table: List of task completed table: ![glide screenshot 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e1bb0a80811be3729bde82e7259f7d16646761c.png) And how the table of just daily tasks, with relation to the task I’ve completed: ![glide screenshot 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/2/a27bf44496ef19d41ca4e44f675d46ee86a49cdd.png) 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: ![glide screenshot 3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/2/72afc6fd2046bbe61e094451241391ccbfb5a399.png) 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 ---
**Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\ **Post date:** [July 3, 2025, 12:27pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/5 "2025-07-03T12:27:33Z")
How do I made a last completed datetime column? do I just make a math column and make it “now”? ---
**Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\ **Post date:** [July 3, 2025, 2:23pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/6 "2025-07-03T14:23:21Z")
An update in what I did, I successfully matched the two tables between the list of tasks and task completion log with a template: ![glide screenshot 4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d5967df2046b9cedf7838781aa4f729a785411bb.png) 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! \>\_\_\ **Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\ **Post date:** [July 3, 2025, 4:43pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/7 "2025-07-03T16:43:58Z") 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 🙏 ---
**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:** [July 3, 2025, 11:24pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/8 "2025-07-03T23:24:31Z")
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](mailto:user@email.com) | Alice | | U002 | [test@email.com](mailto:test@email.com) | Bob | Each click in the task table would do this: > [@ThinhDinh](#): > > On a click, set the current datetime value to the column above. > [@ThinhDinh](#): > > Add an add row action to the workflow I mentioned above (after setting the current datetime value to “Last Completed”). ---
**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:** [July 3, 2025, 11:26pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/9 "2025-07-03T23:26:53Z")
> [@PleaseLaugh](#): > > 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 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. ---
**Author:** ![PleaseLaugh](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PleaseLaugh](https://community.glideapps.com/u/PleaseLaugh)\ **Post date:** [July 4, 2025, 2:47pm UTC](https://community.glideapps.com/t/how-to-write-to-other-tables-not-just-user-profile-using-list-with-checkbox-behavior/82899/10 "2025-07-04T14:47:24Z")
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 \>\_\_\