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?
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.