Showing addresses in Glide map component

[ThinhDinh]

Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job.

1/ Definition

Arrayformula is defined as “a range, mathematical expression using one cell range …

The copy down script can be adapted from here.

[Ofer_Chama]

@ThinhDinh Perfect - I implemented the script and it works like magic!

Thank you so much for your help

[JohnsonPool]

I keep getting error in the google scripts app with the script. Comes back with “TypeError: Cannot read properties of undefined (reading ‘map’)” Any idea a workaround? Seems google sheets has changed somewhat since 2020 as the scripts app is in a different place than described in this post also…

[ThinhDinh]

If you just need to convert your addresses to coordinates for map displaying, the Radar integration would be able to help with that.