2020-10-28

Adding a Checkbox to each Pivot Table Row in Google Sheets

Does anyone know how to automatically add a checkbox to the beginning of each result row in a pivot table in Google Sheets?

On this Google page: https://support.google.com/a/users/answer/9308622?hl=en, it seems to say that it is possible, but doesn't say how to:

  • "Use checkboxes to make Google Sheets more interactive. You can use checkboxes with charts, filters, pivot tables, and formulas."

I would like to allow the user to select one or more rows from the pivot table result, and then have a script run over the rows, doing something with each selected (checked) row.

You could add a checkbox beside the pivot table in a huge number of rows (so there would be a checkbox no matter how long the pivot table is), then allow the pivot table to fill in beside each of these checkboxes, but that would be a brute force approach and look bad.

Here is somewhat of an image of what one of the pivot tables looks like. I needed to mock it up somewhat to protect the confidentiality, so it doesn't have some of the elements of a Google Sheets pivot table in it, but almost looks like the original. Pivot Table Example/Mock-up

What I need to be able to do is add a column to the left with checkboxes, where the user can select any (or all) of the rows. Then a script would loop over those and move those rows to another sheet and/or perform functions on the rows.



from Recent Questions - Stack Overflow https://ift.tt/3kB9TCj
https://ift.tt/35F0qUn

No comments:

Post a Comment