# Vehicle Battery Finder

**URL:** <https://community.glideapps.com/t/vehicle-battery-finder/31120>\
**Category:** Ask for Help\
**Created:** [August 30, 2021, 12:06am UTC](https://community.glideapps.com/t/vehicle-battery-finder/31120 "2021-08-30T00:06:07Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 30, 2021, 12:49am UTC](https://community.glideapps.com/t/vehicle-battery-finder/31120/5 "2021-08-30T00:49:02Z")

</div>

We would advise you to bring as many thing as possible to Glide to enhance your app’s performance. If you do some calculation inside the Sheet opposed to Glide, there will be a delay time for that to sync back.

However if you absolutely need to have the data in the Sheet for other purposes, here’s my tutorial for using arrayformula to apply formulas to all rows.

> [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/):
>
> 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 …

---

_[View the full topic](https://community.glideapps.com/t/vehicle-battery-finder/31120)._
