• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Good Explanation of using an "Array Function" in Google Sheets (1 Viewer)

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 16:41
Joined
Jul 9, 2003
Messages
11,976
This is a good explanation of using an "Array Function" in Google sheets, particularly Google Apps Script. The simplest method of addressing data in a spreadsheet is to do it line by line. However this hogs resources and can take a lot longer. Harnessing an array function which extracts all of the values from the sheet in one go, then operates on them in memory and puts the answers back into the sheet. A little bit more complicated to get your head around, but much faster and uses far less resources.

A convenient way for MS Access programmers to think about Google sheets and Google Apps Script:- Think of the Google sheet as a form in datasheet view, think about Google app scripts as the code behind the form, the VBA code, but in a Google App script, you use JavaScript code. Microsoft is gradually moving some of its products over to using JavaScript code, so it is well worth getting a handle on it.

 

Isaac

Lifelong Learner
Local time
Today, 08:41
Joined
Mar 14, 2017
Messages
2,341
Thanks for sharing these, Uncle Gizmo.
Is it still the case that any Sheets that has scripting in it requires the user to "Allow with their Google account" when they first enter it? I think that was the case last time I looked at utilizing Sheets with scripting more, and it kind of turned me off of it.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 16:41
Joined
Jul 9, 2003
Messages
11,976
s it still the case that any Sheets that has scripting in it requires the user to "Allow with their Google account"

I'm not well read up on this, so take what I say with a pinch of salt. I think you need permissions for most scripts that run within in a document like a spreadsheet or text.

The permissions offers you a level protection because you can set it up so that only people with a Google account can run your scripts. If you've got a business account, then just people within your business. Some scripts can run public, anyone can use them.

It appears to be quite a well protected system, and indeed I think several government organisations around the world use the Google system, hence I'm relatively sure that you are well protected because these large organisations have rigorous vetting procedures.
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 16:41
Joined
Jul 9, 2003
Messages
11,976
requires the user to "Allow with their Google account"

Having just imported some JSON files into my Google drive I ran into the problem of where I needed to authorise an app to do anything with these files.

It occurred to me that was actually what you meant. To use certain third-party applications you need to authorise them and give them access to your data, if that's what you meant, then I totally agree with you.

That is a very big failing with Google as far as I'm concerned. You have no idea who has made this apps, you have to rely on Google Vetting them for you, and indeed in their terms they don't take any responsibility for this, it's at your own risk.

This is totally wrong for any business to allow. The only sensible approach for the business is to disable authorisation of these apps, which I think you can do...

So really, until Google gets its finger out and makes a set of applications which are its own design and handle all of the different scenarios that a business might need, or at least have a decent system for vetting the apps provided by third parties, then it's really a no-go for any serious business.
 

Users who are viewing this thread

Top Bottom