User added items generate after array equations

I haven’t finished my app, hence no url.
The problem im having is basically, Im using arrays etc, however when a user add’s a list item within the application, it will only add the item in the Googlesheets , on line item 5 thousand and some, after the array has stopped… I can go in and grab the line item and move it up easily, which kick’s in all the Array equations i have to automatically generate some data. How do I get Glides to add data into the next available row regardless of pre existing arrays or equations? any help?

Just delete all the empty rows under your data. Glide will add a new row under it.

This has been documented, as Kyle said above, hence not a bug.

Please delete all empty rows and consider using your arrayformulas in the header so you won’t accidentally break any functions.

1 Like