# I would like to be able to add rows to the data source Google Sheet

**URL:** <https://community.glideapps.com/t/i-would-like-to-be-able-to-add-rows-to-the-data-source-google-sheet/68924>\
**Category:** Ask for Help\
**Created:** [December 21, 2023, 1:35pm UTC](https://community.glideapps.com/t/i-would-like-to-be-able-to-add-rows-to-the-data-source-google-sheet/68924 "2023-12-21T13:35:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\
**Post date:** [December 21, 2023, 1:35pm UTC](https://community.glideapps.com/t/i-would-like-to-be-able-to-add-rows-to-the-data-source-google-sheet/68924/1 "2023-12-21T13:35:40Z")

</div>

Click the button to enter data into the Show Form Screen to add table rows.  
However, rows cannot be added in the data source Google Sheet. Why?

The feature was translated by applying the function =ArrayFormula(IF(C2=“”,“”,GOOGLETRANSLATE(C2,“en”,“ja”))) to each column in the second cell of Google Sheet.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 21, 2023, 1:39pm UTC](https://community.glideapps.com/t/i-would-like-to-be-able-to-add-rows-to-the-data-source-google-sheet/68924/2 "2023-12-21T13:39:51Z")

</div>

If you have an array formula in the Google Sheet, you will almost certainly find that Glide is adding new rows way at the bottom of the sheet.

You should make sure to remove any empty rows from the sheet, and then it should work as you expect.

---

<div class="post-metadata">

**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\
**Post date:** [December 21, 2023, 1:48pm UTC](https://community.glideapps.com/t/i-would-like-to-be-able-to-add-rows-to-the-data-source-google-sheet/68924/3 "2023-12-21T13:48:33Z")

</div>

A row can be added, but it is added below 1000 rows.  
Is there a way to translate when adding lines?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 21, 2023, 2:06pm UTC](https://community.glideapps.com/t/i-would-like-to-be-able-to-add-rows-to-the-data-source-google-sheet/68924/4 "2023-12-21T14:06:23Z")

</div>

Yes, as I said if you delete all empty rows at the bottom of the sheet, then it should work.

Although you should adjust your array formula. I would recommend putting it in the first row, and construct as follows:

```auto
={"Translation";IFERROR(ArrayFormula(IF(C2:C="","",GOOGLETRANSLATE(C2:C,“en”,“ja”))),"")}

```

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [December 21, 2023, 3:48pm UTC](https://community.glideapps.com/t/i-would-like-to-be-able-to-add-rows-to-the-data-source-google-sheet/68924/5 "2023-12-21T15:48:30Z")

</div>

> [@\_ffwpu](#):
>
> A row can be added, but it is added below 1000 rows.

So you understand the difference between empty rows (= rows that exist with empty data) and no rows at all.

This is what you want: a table with the minimal amount of rows and columns. And especially no empty rows.

 ![CleanShot 2023-12-21 at 16.34.13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b643044521f9d2cd2085979f05b252ca32f720c.jpeg)

This is what you do _not_ want: superfluous rows with no data

 ![CleanShot 2023-12-21 at 16.31.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c3021d91b203c0992dc00826a41c25d913bf134.png)