Robert, as always thank you for this video!!! I though I knew a fair amount about checklists but clearly I was so wrong!!!! Looking forward to your futue videos!
Great stuff! I had to wrestle with this a few weeks ago for a client in a coffee shop that wanted daily opening/closing checklists. I set a similar action to set the current date time of completion but set it on ‘item click’ rather than the three dots. The time setting allows it to reset everyday (using an IFT Boolean column). The only downside is that they have 5 different checklists, each with dozens of items which means it’s running hundreds of updates a day just on the checking action alone.
just what i was looking for - thanks so much. The twist I have is that i need my completed data to be user specific and rather than marking tasks as done-done, i just need to track when the task was done on a daily basis. task 1 for user A done on monday, wednesday and friday for example.
Very helpful! I had some trouble with creating a recurring checklist a few weeks ago and ended up using a collection with a button at the bottom that says “all actions completed”. This way I could capture a timestamp that records how often they’ve done the tasks. I also included a table below that so they could see how many times it was completed in the last seven days.
Yeah... I know. lol It's 181 at the moment and growing. It's for a game. Players have to choose a race track and I wanted to use a drop down list but can't because of the limit. I've been trying to think of a better way to do it.@@RobertPetittoWA
@@RobertPetittoWA Sorry for the novel but... I thought I posted a reply before but I can't see it. Maybe it got flagged or removed for some reason. Looks like I was (partially wrong). The limit is only for the drop-down list. The radio buttons and the chips allow for more than 100 choices... but it's still a problem. One nice thing about the drop-down is that it's compact before and after you make a choice. During the choice it's bad because you can't get rid of the "search box" which takes up a huge chunk of screen real estate on a phone because the keyboard shows up too... and after you make the choice it shows you the choice you made. Let's not talk about the "chip" format because that's REALLY ugly. The radio-button is okay for small lists but if you have more than a bunch it's not a good UI/UX choice. It only shows the choice you made at the choice... so if you accidentally choose something you might not see that you've chosen something because of all the scrolling you have to do. I didn't know about the "selecting multiple and max choice" option to turn them into checkboxes... so thanks for that. 😀 I have thought about the "two stage" option or splitting it into 2 or 3 or 10 different drop-down lists, as you suggested, but that's extra hassell for the user and a lot more work for me trying to figure out what the stages would be and how to make it work. For the first time user it also makes it look like you have to make more than one choice. I thought about making the extra drop-downs disappear after you make a choice but that falls apart if you change your mind about the choice you made. At the moment I'm still using one drop-down list with a note letting users know that they can search for the rest of the entries. The problem with that is that searching for "n" searches for that letter in any part of the result... not just at the beginning, plus it doesn't show the rest of the entries, it just shows entries with the letter "n" in them. I have made a test setup where the choice is now on a new screen. You push a button to get to the new screen (more work for the user) and then you have a really long list of options to make the choice from. Target is set to Main so that the Submit but is big and it can have a function attached to it. This creates more problems though because if I make the new screen an Edit Screen it edits the current row and if I make it a Form Screen it creates a new row and then the previous screen has to be an Edit Screen and if the user makes choices in the wrong order... even more problems. Also, when you return from the new screen the choice you made is not visible. I fixed that by turning the text on the button to the choice but that's kind of clunky. I'm thinking that I should make a video to show what I mean but if we could just have unlimited drop-down lists with the option of turning off the Search Bar... that would be great! 🙂
Robert, as always thank you for this video!!! I though I knew a fair amount about checklists but clearly I was so wrong!!!! Looking forward to your futue videos!
Thanks for the kind words!
Great stuff! I had to wrestle with this a few weeks ago for a client in a coffee shop that wanted daily opening/closing checklists. I set a similar action to set the current date time of completion but set it on ‘item click’ rather than the three dots. The time setting allows it to reset everyday (using an IFT Boolean column). The only downside is that they have 5 different checklists, each with dozens of items which means it’s running hundreds of updates a day just on the checking action alone.
If you’re on the new Glide plans, no updates yet if you’re using Glide Tables!
just what i was looking for - thanks so much. The twist I have is that i need my completed data to be user specific and rather than marking tasks as done-done, i just need to track when the task was done on a daily basis. task 1 for user A done on monday, wednesday and friday for example.
Best is to create a log of task completions and track the data you need. Use a Glide Big Table because you’ll need that log to scale!
Always learning new tricks. Thanks.
You bet! Thanks for your continued support and feedback!
Very helpful! I had some trouble with creating a recurring checklist a few weeks ago and ended up using a collection with a button at the bottom that says “all actions completed”. This way I could capture a timestamp that records how often they’ve done the tasks. I also included a table below that so they could see how many times it was completed in the last seven days.
Neat hack!
Everytime I'm hoping Bob picks up his guitar and plays us a little song!
That would be a fun bit. I could end every video with a 60-second musical recap
Do the regular check list components recur/reset each day?
Nope :(
How do you create emojis in naming tables and fields in Glide, thx in advance
I use a chrome plug-in called Joy pixel. On my Mac, I have an application called rocket that lets me add an emojis after typing a colon
👍
Choice components are also limited to 100 items... which kinda sucks.
Interesting. You need a checklist of 101+ items?!
Yeah... I know. lol It's 181 at the moment and growing. It's for a game. Players have to choose a race track and I wanted to use a drop down list but can't because of the limit. I've been trying to think of a better way to do it.@@RobertPetittoWA
Can you categorize them and then break them into two lists? The second filtered after selecting the first?
@@RobertPetittoWA Sorry for the novel but...
I thought I posted a reply before but I can't see it. Maybe it got flagged or removed for some reason.
Looks like I was (partially wrong). The limit is only for the drop-down list. The radio buttons and the chips allow for more than 100 choices... but it's still a problem.
One nice thing about the drop-down is that it's compact before and after you make a choice. During the choice it's bad because you can't get rid of the "search box" which takes up a huge chunk of screen real estate on a phone because the keyboard shows up too... and after you make the choice it shows you the choice you made.
Let's not talk about the "chip" format because that's REALLY ugly.
The radio-button is okay for small lists but if you have more than a bunch it's not a good UI/UX choice. It only shows the choice you made at the choice... so if you accidentally choose something you might not see that you've chosen something because of all the scrolling you have to do. I didn't know about the "selecting multiple and max choice" option to turn them into checkboxes... so thanks for that. 😀
I have thought about the "two stage" option or splitting it into 2 or 3 or 10 different drop-down lists, as you suggested, but that's extra hassell for the user and a lot more work for me trying to figure out what the stages would be and how to make it work. For the first time user it also makes it look like you have to make more than one choice. I thought about making the extra drop-downs disappear after you make a choice but that falls apart if you change your mind about the choice you made.
At the moment I'm still using one drop-down list with a note letting users know that they can search for the rest of the entries. The problem with that is that searching for "n" searches for that letter in any part of the result... not just at the beginning, plus it doesn't show the rest of the entries, it just shows entries with the letter "n" in them.
I have made a test setup where the choice is now on a new screen. You push a button to get to the new screen (more work for the user) and then you have a really long list of options to make the choice from. Target is set to Main so that the Submit but is big and it can have a function attached to it.
This creates more problems though because if I make the new screen an Edit Screen it edits the current row and if I make it a Form Screen it creates a new row and then the previous screen has to be an Edit Screen and if the user makes choices in the wrong order... even more problems. Also, when you return from the new screen the choice you made is not visible. I fixed that by turning the text on the button to the choice but that's kind of clunky.
I'm thinking that I should make a video to show what I mean but if we could just have unlimited drop-down lists with the option of turning off the Search Bar... that would be great! 🙂
First
You win 😉