Making a pop-up/pop-down alert on G sheeets

[rob wilson]

I have an onOpen function that can take quite a while to complete. I want to stop the user doing any edits at all until the function has been completed, and ideally the user should get a "Working, please wait" message, 

I've looked at some docs and discussions, but the problem seems to be that the ui.alert() and similar functions actually suspend processing until the user clicks a button (for example).

Any ideas?

[Keith Andersen]

Have you looked at the lock service? A script or document lock?

Try a toast message. The script posts the toast message and then continues on. So you could have a message saying this script will be temporarily locked for x seconds while it finishes processing. Then set the toast time for that amount of time..

Keith 

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/6be4e780-0108-434d-8626-5d51b3f423bbn%40googlegroups.com.

[Keith Andersen]

Or ....

Make a regular pop-up and upon them answering, the calculations begin or you could simply use continue so that the script continues along.

A couple options anyway

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJ8MD4we%2BWLho0O7nQY3MOjK_DotgN4h6uRYVOpN11BGGFa9%3DA%40mail.gmail.com.

[George Ghanem]

You should look at speeding up your script. Unless it is doing massive update on the sheet.

One suggestion may be to change access privileges of other users until changes are complete..

--

[Keith Andersen]

George,

I'm not too experienced here, but wouldn't lock service lock either the document or script from user interference better / easier than redefining user privileges?

Keith 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAA4K68ZFfdZfPc1XS2jM2uS_d89mAJUo6Mzjtshn5r2Ys58okg%40mail.gmail.com.

[George Ghanem]

Lock service will only prevent the script from running, the spreadsheet will still update. I took his question as in wanting to prevent spreadsheet from changing until script completed.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJ8MD4yoJ7%3Dt7Qs%3DBLG_CdJcwhUcUobECgPgG%3DObrFr6kyNa9Q%40mail.gmail.com.

[Andrew Roberts]

Try a modeless dialogue which will not suspend processing.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAA4K68aHzBybL1g9uhZM90%3DN_biOHm0vGVnrH9fRj%2BdesmAcsQ%40mail.gmail.com.

[Keith Andersen]

Thanks George. I'm going to do some experimenting. I'd like to see if the lock document would do the trick.

Cheers

[rob wilson]

The Sheets extension "Crop sheet" does a great job - see screenshot. Just what I'm looking for!

The code is public on github. But I can't see anything in the code that does this, so I guess that it's a built-in function for extensions?

Rob