Why are so many lines inserted?

[scienter]

After I entered this formula in a cell: = ARRAYFORMULA (if (M2: M <> “”; VLOOKUP (M2: M; MICRO! $ A: $ B; 2; FALSE); “”)) the form is inserting more 1000 empty lines before posting a new line with the data. Why does this happen?

[Doomba]

You will have to delete all the empty rows in the sheet if you use ARRAYFORMULA in a form. The reason is that the cells that are calculated by ARRAYFORMULA are considered non-empty by Glide, and hence the next row is inserted only after whatever rows are present in the sheet already.

Ref: Check the “Edit” note in the first post in the thread below.

Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet

I can’t take credit for this tip but I just found out about this trick/tip by reading a post here. So the “Normal” way of using an ARRAYFORMULA function is to use it in row 2 of a given column. You just have to be careful not to accidentally deleted it, or have a user delete it. So the next idea was to put it in row 2 but not put any other data in the row and then hide or minimize that row. Basically your data for the non ARRAYFORMULA columns would start on row 3. Then I saw the post I’ll l…