Bar code reader

[Jeff_Hager]

You can only set a column value in a single row. If you know that you would only have 5 rows to update, you could create 5 single relations linking AA to each A1-A5 column. The you could have 5 set column actions to set the S1 boolean value on each row. through each individual relation.

I have what a feel is a better alternative here.

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…