Progress bar

[Andrew Apell]

How can I implement a progress bar in apps script?

[Andrew Apell]

My function is structured like this:

function myFunction () {

  // Some stuff here

  // Loop here

  // Process loop results here and return

}

This function is executed via a modal window

[Laurie Nason]

https://www.claudiokuenzler.com/blog/954/how-to-create-visual-status-progress-bar-spreadsheet-google-sheets

You can use this on your sheet, then as you loop through your function, increase the value in the cell that the progress bar is based on - don't forget to SpreadsheetApp.flush() to force the redraw for the user (bear in mind that this may impact the users experience if you are doing a lot of small increments).

--
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/d6639fa4-3404-43af-86d0-a7535a62d2a1n%40googlegroups.com.

--

Laurie Nason 

The KAUST School – Operational Analyst

Information Technology Support
Deep in the Bowels of the School
Landline: +966-12-808-6853

Mobile: +966-54-564-3698

[Andrew Apell]

👍  Thank you.

[Andrew Roberts]

If the progress bar in client-side Materialize is handy: https://materializecss.com/preloader.html

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ff0dfa02-8ede-4053-bbc0-9e6442a01d6fn%40googlegroups.com.

[Andrew Apell]

Looks cool! Reduces the impact on processing as well...

[Pablo Felip]

I am also quite a fan of using SPARKLINE to give visual feedback in Google Sheets. This is a very simple implementation of a GAS-driven SPARKLINE to create progress bars, in case you may find it useful:

https://github.com/pfelipm/progress-bar-sparkline

[Andrew Apell]

How do you implement "materialize" in Apps Script?

[Jonathan Butler]

Add the CDN to your webpage. Create a Linear Determinate Progress bar, and update the width property in javascript.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/d5234b3c-b09b-443b-bb68-d890f1874b30n%40googlegroups.com.

[Andrew Apell]

Thanks Jonathan!

I couldn't find the CDN and that left me confused 🙂

[Jonathan Butler]

No problem!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/e680269a-7261-4a90-8924-310eaefb372fn%40googlegroups.com.