Better cell editors

Would it be possible to have customizable cell editors. For small datasets we already have the FK dropdown, but it would be nice to have a way to defined which column are shown in selection, or a search over that column.

For dates a proper calendar picker.

Or for text columns a HTML cable rich text editor.

We already have a date editor, it's not a picker but you can at least arrow-up and arrow-down in the segments to increase/decrease their values. Please check that out exactly before requesting a different date editor.

I don't get what you mean by "it would be nice to have a way to defined which column are shown in selection, or a search over that column"

A rich text editor can break your contents, when you for example edit a Typo3 based content, which is not pure HTML, it has elements which need to be preserved. It's dangerous to use a rich text editor here which can break your content. I could imagine to use a HTML highlighter at least, we even have the SynEdit highlighters. But this all definitely needs more exact ideas.

Thanks for the quick reply. The HTML editing might be indeed tricky. The calendar picker would be nice to have instead of the current date input.

About the FK, what I meant is that you could specify that table "book" references "author" via id, but for display you would pick author.name. The dropdown already shows a column (probably the first varchar column or something). Then if there would be more than 1000 rows one could start typing and it would show a search result matching that based on the specified column.

Would that make sense?

Did you check out the current date/time editor with the arrow keys?

The foreign key values editor is indeed a bit unfinished, because of its limitation to save traffic and for the benefit of speed. Searching by typing in a pulldown which does not allow typing does not sound so intuitive to me. At least you need a popup dialog where you can enter a search word. What about a very first pulldown item named "[Search...]", which pops up such a search dialog?

why not make something like the google search suggestions? They work while typing and update the dropdown selection on the fly.

I'm afraid that would blow up the effort a bit, but let me overthink that. Probably I find some similar working idea without reinventing the wheel.