I’m trying to use a big spreadsheet as a database. Your recent excellent video improved how I can read selected rows of it. But is there a smarter way to add new data? Is there a way to replicate what Forms do on the iPad when using Numbers on the Mac?
Adding a new row to a large sheet, scrolling across to get to all the columns, is far less user-friendly than a classic database ‘add a record’ screen would be. I’d like to find a better option for the spreadsheet I’ve got. (If there is something the equivalent of the filtering to view, this might be better as a suggestion for a new video topic)
—–
Bernard Caddy
Just go to the last row of the table (the End key or Command+down will get you there fast) select the cell in column A and press Return. This creates a new row. Then enter in data, using the Tab key to go to the next column each time. No need to scroll as that is automatic. Then Return for the next row.
Just keep it simple like that. Don’t over complicate it.