samedi 17 juillet 2021

Possible to automatically add multiple checkboxes to Excel from SQL Query?

I have the following data in a view that is output to an Excel sheet via a query.

+----------+---------+---------------+
| Verified | Deleted |      Name     |
+----------+---------+---------------+
|     0    |    0    | Sean Hull     |
|     1    |    0    | Bonnie Davis  |
|     0    |    0    | John Smith    |
|     0    |    1    | Evel Knieval  |
|     1    |    1    | Bart Simpson  |
|     0    |    0    | Peter Griffin |
+----------+---------+---------------+

Ideally the first two columns would convert to checkboxes with 1 = Checked, and 0 = Unchecked, but I'm fairly certain that is not possible. I have added two columns to the right the table so the sheet looks something like this.

+----------+---------+----------+---------+---------------+
| Verified | Deleted | Verified | Deleted |      Name     |
+----------+---------+----------+---------+---------------+
|          |         |     0    |    0    | Sean Hull     |
|          |         |     1    |    0    | Bonnie Davis  |
|          |         |     0    |    0    | John Smith    |
|          |         |     0    |    1    | Evel Knieval  |
|          |         |     1    |    1    | Bart Simpson  |
|          |         |     0    |    0    | Peter Griffin |
+----------+---------+----------+---------+---------------+

I know I can add a Checkbox via the Developer area, however I have to then manually format the control to set the Cell Link.

Is it possible to automatically create a linked Checkbox? I don't think I can avoid having to edit the sheet to add the additional columns, but if the checkboxes could be created in some kind of automated way, that would be a huge help as I have a couple views with a couple thousand rows, and manually linking each one isn't really an option.




Aucun commentaire:

Enregistrer un commentaire