How to make a dropdown list with new items added?

Question

Google Apps Script

I have a drop-down list that fills a cell from the specified range, example: prntscr.com/7rv2cq
But, I want it to be like this www.planetaexcel.ru/techniques/1/35
How did I do this?

Answer 1

Hello,
there is no access to IU manipulation. Whether the developers will add this feature is unknown. The issue was raised over a year ago on the Disk import forum. Then one of the options was a sidebar , but it's inconvenient.
The idea behind larionov_n is like shooting sparrows from a cannon. Why not just use a normal database instead of a castrated spreadsheet? But, at the same time, I can say that manipulating the Table through an external application with AngularJS on the front is the most popular in my orders. Those. I can't find an answer to my question.

Answer 2

Well, you have a collection of Combobox values ​​somewhere, when you update the collection it updates the storage Combobox. What else could be the connection... You can use Kendo UI. JqxWidgets. So they seem to know how, judging by the link viewing. It's even easier to use AngularJS. two way data binding. You can also do web excel with it.