Reset button from another table

[Kira]

Hi everyone!
I’m new here and I’m having a bit of trouble setting up a button.

My goal is to create a checklist with a reset button. The problem is that I’m working with two tables instead of one: a parent table, which contains the general information, and a child table, which holds the actual checklist items.

For example — in the main menu I want to see “Mountain vacation”, “Beach vacation”, etc. When I click on one of them, it opens a new screen showing the specific checklist (like “Clothes”, “Shoes”, etc).

I’ve already searched for similar cases, but all the solutions I found are for setups using a single table. Because of that, when I try to set up the reset flow, it only lets me target the parent table, not the child checklist — and I can’t figure out how to properly link them so the button works as intended.

Has anyone run into a similar situation? How did you solve it?

Thanks in advance!

[Jeff_Hager]

The below solution should work for you, since it does rely on a value stored in a parent table.

Reset Multiple Rows - copyable template

Just adding this as a resource that can be linked to. The below template demonstrates the basic technique that was described by @Jeff_Hager in this thread. The concept Apps in that thread are all legacy Apps which cannot be copied.

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…