V
V
Vladimir Zuev2020-07-02 08:38:56
Google Apps Script
Vladimir Zuev, 2020-07-02 08:38:56

How to create a table in a sidebar with a changing number of cells?

Hello.
I ask for advice. It is necessary to create a table in the sidebar like this
5efd6cad88e45227728826.png
. The number of cells can be from one to 30. Cells can be added and removed programmatically. The inscriptions are also different.
Thought so.
Create a sidebar with a table. Each cell has a colored button with the desired text. Buttons to perform some actions in the sheet by clicking on it.
At the top is a color picker with inputs to create a new button. With the specified color and text.
In a separate sheet of the table, write down the button number, color and text.
When loading a sidebar, all data for loading the table and buttons is taken from this sheet of the table.
A sidebar with such buttons is needed as a reference book, with working buttons or cells, when working with a table. And in plain sight.
But I'm asking for advice. You can do it somehow differently and better than what I suggest.
I can't think of anything better than a table with buttons. And I feel like everything can be done in a simpler and more elegant way.
In general, to something similar and not so cumbersome.
I ask for advice.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2020-07-02
@ProgrammerForever

1) Make a sidebar
2) Insert a table header in the HTML code
3) Insert for each cell 4) Close the table tag Data from the table can be transferred like this .
<td> element </td>

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question