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.
Aucun commentaire:
Enregistrer un commentaire