Update "Selection Field" options with JS

I’m looking for a workaround to “Allow User Add New Options” for cascade selection fields. We have a lot of cities with sub districts, and often need to add a new district for a city without going into change design.

I couldn’t find a reference in the API to updating Selection Field options in general, but it would be pretty powerful there was a way.


The API cannot change the sheet’s design, which means that you won’t be able to add the option of cascaded selection via the API.

If you need to add this option frequently, we suggest that you create a new sheet to record the city and district data, and use Link & Load and Dynamic Filtering to link and filter the data to the original sheet.

Then, you may use the API to create a new record in the new sheet.