I am in need of a way to have the results of a view to be rendered as a select list (drop-down preferably) and that to be a field in a content type. It seems that I'm not the only one looking for something like that:
...although that thread is specifically about entity reference fields, in my case I simply want to use the content type as the means for exposing the options of this select field to specific users and allowing them to edit the list. But this can be on our roadmap because we plan to have references in core anyways AFAIK.
I thought that this could perhaps be implemented as a views display (like we do for views-generated blocks) and then have this as an available option to select the field settings "Allowed values list" (mockup):

I looked in d.org for any related modules. Here are my findings:
Entity Reference View Widget (screencast to see it in action)
This module provides an advanced Entity Reference widget that uses a view embedded in a modal dialog for selecting items. The view can be paginated and have exposed filters.
...not exactly what I was after in my specific use case because it uses a modal while I was after a drop-down select list, but very interesting nevertheless.
EntityReference Dynamic Select Widget
This module provides an advanced Entity Reference widget that uses a special select control for selecting items. The select form element options are generated by a view with a special display. This special display strips out any HTML in the view's row results so that it can be used as select options.
This one renders the view results as a drop-down and also optionally has an AJAX filter for the values of the list (don't really care about that feature in my use case, but thought it's worth the mention)...
The widget filter text box can be used to limit the number of options using view's filters selected in the widget settings. When the widget button is clicked, an AJAX call passes the filter text to the selected view's filters and the select form element is refreshed with the view results.
Here's what it looks like:

Thoughts? Core-worthy you think?
Recent comments
Try using caching in the View settings, set to 24 hours. This should work for anonymous site visitors.
View to show a different node each day
That would actually be a nice usability improvement. A lot of people already build search pages with Views, so having an easier way to convert the default search results into a View would make...
[UX] Convert search to a view.
Have you already played with Views random seed? I belief, what you try to achieve would work with that module. Show only one node and set the sort order to "Global: Random seed" with "...
View to show a different node each day