I need to insert rows to top of the table using api. So then i can get last one row with query as last row added to table that have specific column value. But as i see i can only add values to bottom and get only from top, so for big data it can be costly
Hi @Timofey_Bolgarin - Unfortunately the API doesn’t provide the ability to add rows to the top of a table, nor change the order of existing rows. Coda tables do have a natural sort order, but most often tables and views are sorted by a column value instead. You could consider adding a column that contains the date the row was added, and then sort on that column’s value (descending) to get the newest rows to appear at the top.
This keeps coming up as a nice to have. When adding new items to tables, it’s very common to want to see them at the top and not have to scroll down on large tables to see it, and moving it from the bottom to the top is clunky.