Hi - am am currently working through METRIC RAT'S AIi's CRUDII Google Sheet App example and have picked up a problem of my own making.
I changed the first column of the google sheet to an index column with the following formula in cell A1
which automatically updates the ID number with each new entry. The problem I picked up, here and in other apps I am experimenting with is that as soon as you call data with ListView as that it lists all vacant rows until the bottom of the sheet which seems wasteful of resources.
Can anyone help me with a way to limit the listing of vacant rows using that or similar formulas.