Profile cover photo
Profile photo
Andrea Leardini
1,944 followers -
Google Top Contributor, Web developer
Google Top Contributor, Web developer

1,944 followers
About
Posts

Post is pinned.Post has shared content
Sul mio profilo personale sto usando le raccolte per suddividere i miei post in base al tema e alla lingua. Mentre su +Wikilear le ho usate per creare sezioni specifiche per ogni prodotto Google di cui parlo.

Visto che ho partecipato alla fase di test parto avantaggiato.. ;-) 
E tu come userai le Raccolte?
Introducing Google+ Collections, a new way to group your posts by topic

Our happiest Google+ users are those who connect with others around shared interests and passions. So we set out to give people a place to express the things they love. Today, we’re announcing Google+ Collections, a new way to group your posts by topic.

Every collection is a focused set of posts on a particular topic, providing an easy way for you to organize all the things you’re into. Each collection can be shared publicly, privately, or with a custom set of people. Once you create your first collection, your profile will display a new tab where other people can find and follow your collections.

Posts in collections you follow will appear in your Home stream, with a link to easily jump right into the collection so you can get to similar content from that author. Collections give you a great way to find more of the stuff you love from the people you follow.

Collections is available on Android and the web, and iOS is coming later. For Android users, make sure to update your Google+ app to get access to Collections.

For inspiration on interesting topics, check out our Featured Collections page here: g.co/collections

Create your collections today and share what you love.
Animated Photo
Add a comment...

Post has attachment
Forse un esperimento ma funziona solo per iOS, non per Android e Windows...

#ricercagoogle #google #ios
Photo
Add a comment...

Post has shared content
You can create a direct link to a specific line of code in an Apps Script project thanks to the following url parameters:
&f=FILE_NAME&s=LINE_NUMBER

Example with the FirebaseApp library (public project):
https://script.google.com/d/1hguuh4Zx72XVC1Zldm_vTtcUUKUA6iBUOoGnJUWLfqDWx5WlOJHqYkrt/edit?usp=drive_web&f=Code&s=218

Discovered thanks to the new macro record feature
Add a comment...

Post has shared content
I was sure i'd shared this before but seems not.

A handy UI tip I've used a lot recently when using Custom Functions that deal with large data sets, is to conditionally format the results based on the "Loading…" status you see in the cell containing the custom function.

Turns out Google Sheets registers this status as an error of ERROR.TYPE(A1) == 10.

Therefore if you have a raft of cells that are essentially broken while the data isn't yet available from the custom function, you can conditionally format using:

"=ERROR.TYPE()=10"

This I find is massively preferable to having to wrap IFERR() around all those cells as this can hide other 'legitimate' errors.
Photo
Add a comment...

Post has attachment
Add a comment...

Post has shared content
Lucidchart have posted some tips on developing add-ons. Hopefully useful for others

[Note: The post advises using Material Design in add-ons which the official documentation still says you should avoid doing https://developers.google.com/apps-script/add-ons/style ]
Add a comment...

Post has shared content
Building on my recent Form posts, here you'll learn how to set up different question types on a Google Form using data from a Google Sheet. As an example, we'll be setting up a questionnaire with several question types.

It'll include:
*Setting up a global variable
*Using functions within functions
*Javascript methods:
-forEach() to loop through an array
-slice() to extract items from an array
-filter() to remove empty cells from an array
-indexOf() to find the position of an item in an array
*The regular expression /\S/ to look for an empty item

Don't worry if any of that scares you, I'll be going through it step by step, and it's easier than you think!
Add a comment...

Post has shared content
If you've been reading about JavaScript Es6 and maybe even Es7, you'll may feeling a little left behind in the Apps Script Es3/5 environment. However, here's a Paul Miller's es6-shim in the form of an apps script library that you can use now to bring a lot of that Es6 goodness into your apps scripts.

http://ramblings.mcpher.com/Home/excelquirks/gassnips/es6shim

#gde #googleappscript #opensource #blogpost
Add a comment...

Post has shared content
Dealing with File Ids in Apps Script can be a pain, especially if there are multiple versions or copies floating around. Here's a way to use Drive custom properties to abstract IDS away and find files by their characteristics instead of their IDS - of course there's a library to make it real simple.

http://ramblings.mcpher.com/Home/excelquirks/gassnips/drivepropertiesforid

#gde #googleappsscript #blogpost #opensource
Add a comment...

Post has shared content
Here's an article I've written with Google about Stackdriver & Apps Script. Super helpful to investigate on errors and understand how people are using our add-ons Yet Another Mail Merge and Form Publisher!
Add a comment...
Wait while more posts are being loaded