I do not think we can make this automatic for two reasons: - you would need an extra db query to figure out how many records - the autocomplete widget needs extra parameters and they are not always obvious, you may need to specify some of them manually.
On Wednesday, 5 December 2012 09:36:42 UTC-6, onetwomany wrote: > > Thanks for the suggestion. An autocomplete widget is a good alternative. > On further thought, and in keeping with the spirit of web2py, perhaps a > threshold based on the count of the number of records (say 100 rows) may be > used to determine if SQLFORM selects an options widget or autocomplete > widget by default. This would allow for more graceful degradation as the > real issue isn't so much setting up the field with a particular widget but > the time required to track down the problem... > > --

