Table View tweaks to improve usability

[Matt_Blais]

• During cell editing, adopt “standard spreadsheet behavior” for TAB and Shift+TAB; I.e., finish editing the current cell and move to the next/previous cell. If at the end of the row, move to the first cell in the next row; If at the end of the last row, create a new entity.

• For RTF columns, allow editing the cell value via a small, fast popup. It would be very useful to allow quick, seamless entry/editing of RTF field contents without having to open the entity view (even if that means we can’t do complete RTF formatting).

• For RTF columns, replace the “page icon” currently displayed in the cell with the actual (truncated) text value. Even unformatted text would be preferable to nothing.

---

REF:

Entry speed improvements

Entry speed leads to saving time, follow is some suggestions to speed up the process of inputting things into the table: Import, Export from whatever table related tools: excel, airtable, notion, coda … Navigation by keyboard hotkeys Ability to input content to the active cell without pressing Enter. (just like google spreadsheet and Excel)

Improvements to table view

I’m really glad to see the table view got batch delete options and soon batch copy-paste, however I would like to request a few other features that we need quite a lot. Speed improvements, especially on scrolling and creating new items - even for small datasets the scrolling is laggy, the new scrolling performance for card views is amazing… this is what I would expect on tables as well. When creating a new item, it’s also slow - i understand it waits to create a new entity but it should be th…

[YvetteLans]

Agree!

@Matt_Blais

During cell editing, adopt “standard spreadsheet behavior” for TAB and Shift+TAB; I.e., finish editing the current cell and move to the next/previous cell. If at the end of the row, move the the first cell in the next row; If at the end of the last row, create a new entity.

This would be also very helpful for tables within documents/rich text fields

[nathan_jay]

Adding to this for improvements suggestions:

• Right align column headers for Number
• Choose alignment for Text (right, left, centre). In the example below, I want the Text field to be right align because its actually a number which I must store as text because it’s too large.
• Number formats use similar notation to Excel so I can display “-” for 0 and (Red) for negative. It make’s it far easier to visually scan tables and find outliers and opposites (positive/negative) in data

Examples for the Excel like formatting:

Define the cell formatting with notations: