Database as simple table!
To start with, think about the possibility of joining simple tables and collections.
In both cases, we have columns/relations and rows/elements.
Unfortunately, collections are too heavy for a simple table, and simple tables are too basic…
You can see it in the FR from both of them!
On the collection side, we “just” need :
- be able to hide all options (title, views, especially if there’s only one, the “+” for adding relationships, etc.)
- be able to edit it quickly like a table (Excel, Notion, etc…)
- options for data formatting (centering text, colors, etc.)
- no obligation to display the “name” relation
- a “rich text” or “block” relation for multiple lines of formatted text, images, checkboxes, etc.
- … and in fact, Simple table in Anytype are so basic that we already have something similar (and better because data is typed, can be sorted, etc). Including this “block relation” because we can’t do we can’t do much with the simples tables at the moment.
Et voilà! 
Next, you’ll need to include all the features that are sorely lacking on today’s simple tables (such as image integration).
The only limit I can see is cell merging. But we’re so far from that anyway!
Few tools allow for this, and yet in my opinion it would be a huge breakthrough that would enable so many things to be done, and would be a real asset!
If I really can’t convince the team, here’s what it would take for the collections (and yes, it’s partly in line with the things mentioned here)
Collection 2.0 without simple table
-
Hide the name of the collection and other settings
Usercase : I juste want a photo gallery, not all the useless stuff around it (e.g. keep just one “Edit mode” button that redisplays everything)
FR : Embed view (for sets or collection) without displaying title, settings, etc -
“Name” relation must be optional (or must be able to be hidden)
Usercase : I have a list of degustation note, I don’t need “name”, I don’t want it. Or again, a photo gallery…
FR : Ability to hide the Name relation in Sets Grid view
Another FR : Ability to hide the Name relation in Sets Grid view -
Drag and drop files
Usercase : Having files in collections, seeing collections of files… honestly, I don’t understand why this isn’t possible.
FR : Drag and drop files to Collection -
Quick edit values in a collection
Usercase : when I have 100 elements to add or to edit, I want to do it easily like with others apps
FR : Quick edit relation in a collection/set table -
Inline and full page collection must have the same functionality
-
Conditionnal formatting or if not possible at least background color
Usercase : highlight important values (best values in a comparison, critical values, etc.)
Conditional formatting for Sets - #2 by Shampra -
Grouping
FR : Grouping in Sets -
More complexe filter (and more easy and quick to use)
-
Temporary filter
Usecase : a list of what you want (wine bottle?). I want to quickly filter to just show “Red wine” because I want one for dinner. So : filter with as few clicks as possible (that’s a long way off) and that this filter is only used temporarily (no saving in my view, for example)
FR : Temporary set changes - Quick filters / sort -
Filter based on parent
FR : Set Filter based on Parent Object -
** More gallery view customization**
Usercase : again,photo gallery, whisky base,…
FR : Gallery View Customization -
Last but not least, correct two problems on collections with many relations or many objects : keep header and horizontal scrollbar visible when scrolling vertically!
FR : Problem with horizontal scrollbar on large set
and Left to right slider not visible until scrolled to the end of rows in large sets
I haven’t talked about relation, like this problem of number format (adding decoration like degrees or other symbols, numerical format, etc.) or date, two relations that generate a lot of FR, because it’s more an evolution of relationships. Another subject 