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:
Tap an item to mark it as complete
That task should disappear for the rest of the day
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
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.
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
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:
when I click on it it logs on to the completed task table, and there’ll be a match, and it’ll disappear
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
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?!