Improve This App! (Packing Checklist)
I was interested in making this packing checklist just for the challenge and experience, and I feel like it would be pretty useable. However, I’d like to see two improvements:

  1. It would be better to be able to tap on the progress bars from the home screen to go into those categories, rather than having to open the menu every time.

  2. I’d like to have a Clear All or Restart function.

Any ideas on either?

1 Like

I like your idea. I don’t have anything great as far as ideas. You could add a button below each progress bar that opens the appropriate list. Clearing all of the checkmarks would probably require a script of some sort to clear everything whenever a master switch is flipped.

Thanks, Jeff! I like the idea of having an inline list instead of the progress bars on the main screen. This would allow me to move the individual progress bars into each section. Then I could have a main progress bar on the main screen that shows progress of the entire packing project. The last piece is an easy way to clear all checkboxes. Anyone?

1 Like

@onepixelman You might get inspired from this app

Perfect. Thanks!

Here’s my slight improvement to your app:

I changed the chart to have a transparent background and larger text for the chart legend.

Here’s a little bit of info I’ve found on setting up a script to clear checkboxes. You can set up a trigger to run in onChange. What I would do is have a value on a separate sheet where when you set it to true with a checkbox or switch, the script will see that and set false to the other checkboxes along with the checkbox that triggered the script.

1 Like

Thanks, Jeff!

1 Like

Great idea, Onepixelman.
Did you ever get the clear all and the tapping on progress bars to function?
I would love to peek under the hood of this one!

Thanks, Gregorio. I didn’t make much more progress, but I’ve opened it up so that you can copy it. Let me know if you figure out good solutions.

1 Like

Thank you! Very exciting.

Hi again, onepixelman.

I’ve been playing with your progress bar, checklist app and noticed that the last list doesn’t work.
When I try to make my own list, instead of just relabel your old ones, it doesn’t work either.

I do everything backwards and wonky since I tend to think in the abstract, but here’s what I did:

Create a sheet of questions, go back into Glide and build out the columns, copying your lists exactly. When I use my new checklist in the menu, the results don’t show like the others in the main home screen.

Is there a step by step tutorial I can follow?

Thanks. Still pluggin’ at it…

Looks like each column in the Main sheet has a formula to pull a value from the respective sheet. The Activities column is missing the formula. In this case, if you add a new sheet, you need to add the respective column and formula in the Main sheet. I’m sure there’s better ways to do this with relations and rollups to dynamically handle new lists instead of new sheets. A lot’s changed since November.

1 Like

Exactly the prob!
Thanks again, Jeff.

Spoke too soon!
In my app, it worked for a minute, then stopped.
Then I noticed the same thing happened in the Packing App with clothes.
Is there a trick to writing the formula?

1 Like