User input data goes in row 455 rather than next empty row

[Mayuresh_Ganbawale]

Hi All,
I’ve recently made an inventory app on glide that has tabs as follows,
Inventory, User Transaction, Raw Mat. Purchase and vendor database.
Of these tabs, only User transaction tab allows users to input data.
The problem:
Whenever new data is input in ‘User transaction tab’ in app, the data is getting stored in row 455 of the respective sheet and not in the next empty row.

Any help appreciated.
Thanks
Mayuresh G

[ThinhDinh]

You can have a read here.

https://docs.glideapps.com/all/guides/quick-starts/getting-started/adding-items#prepare-your-sheet-for-adding-by-deleting-empty-rows

[Mayuresh_Ganbawale]

Hi, that was a helpful suggestion.
But the problem isn’t quite solved yet, I’ll elaborate.
In the ‘User Interaction’ sheet, I have added formulas for empty cells too, so when new data gets entered additional data will be automatically filled.
And now when I input new data, this data is getting added in a new row where the formula isn’t entered
I’ll attach a screenshot

MMG is the new data, and you can see the formula is present in the above row.

[ThinhDinh]

Because you already have data for those lines, it will not be messed with by Glide, Glide must use a complete empty row to input new data.

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 …

Use arrayformula and give those a null value instead of a 0 here.

[Mayuresh_Ganbawale]

Hi, I read your tutorial and understand it as well but have trouble trying to implement as I’m pretty new to this.
I understand that even if the column/output is empty, it doesn’t get treated as null as the formula is present. But I’m having difficulty understanding where and how should I write the formula.

[ThinhDinh]

@Mayuresh_Ganbawale

I understand that even if the column/output is empty, it doesn’t get treated as null as the formula is present.

If you use an arrayformula, the formula is there and:

• The empty rows won’t be counted towards your row count.
• New rows will have the formula automatically calculated.
• However, you must delete the empty rows because somehow Google sees empty rows as filled and Glide’s inputs are put in the next “not empty” row, which is at the bottom of the sheet.

I have put some formula in there, you can try putting them in your first row.