Forum Discussion
LauraThacker
8 years agoQrew Captain
The drop-down option will cease to function when your source-table has more than 1,000 records; so you would need to set your Record Picker to display the fields (there are 3 placeholders) in the order that makes sense for users typing-ahead their options. It doesn't "show all options" that "contain" the user entry; it follows alphabetically the numbers/text they enter.
However; once your data source gets to 1,000 records; QuickBase will automatically move to the Record Picker Option instead of the drop down.
If the 3 fields in the placeholders are not flexible enough, build one or more formula fields; and then use those formula fields (which can string together more than 1 field of data) in the placeholders so that you get the equivalent of 4 or more fields of data available to view when selecting.
In a Form Layout you can also choose a custom report instead of a record picker for your reference field picker - this is especially useful if you want to use filters to exclude data from the record picker in addition to controlling how many, and the order of fields that appear in the record picker dialog window.
However; once your data source gets to 1,000 records; QuickBase will automatically move to the Record Picker Option instead of the drop down.
If the 3 fields in the placeholders are not flexible enough, build one or more formula fields; and then use those formula fields (which can string together more than 1 field of data) in the placeholders so that you get the equivalent of 4 or more fields of data available to view when selecting.
In a Form Layout you can also choose a custom report instead of a record picker for your reference field picker - this is especially useful if you want to use filters to exclude data from the record picker in addition to controlling how many, and the order of fields that appear in the record picker dialog window.