CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Jordando
Jordando

Reputation: 356

How can I change a textBox when a user selects a new cell?

I have a small GUI made in google scripts for a spreadsheet. I have several text fields that I would like to dynamically change, whenever a user selects a new cell in the spreadsheet. I am basically asking if there is a trigger or event handler that can fire each time a user selects a new cell. I have searched, but can't seem to find how to do this.

Thank you in advance.

Upvotes: 0

Views: 55

Answers (1)

Serge insas
Serge insas

Reputation: 46812

There is no such trigger in spreadsheet and UiApp won't allow you to get that functionality.

But there is a possible workaround by polling the spreadsheet from an HTML sidebar in the new version of spreadsheets : see this brilliant answer by Mogsdad...

Of course it implies quite a lot of changes in your existing script... HTML Service works with client JavaScript and html,which has not much in common with UiApp.

Upvotes: 1

Related Questions