Short version: How can I populate a choice list of individual numbers where the numbers are all numbers contained within a data’s list of records’ range fields.
More info:
Hello I have a database with around 3k items. Each item has a numeric range - which is the serial numbers of the items produced. Across all 3k records the total serial numbers contained with the record’s ranges is around 6M serial numbers. Roughly the numbers are 1 to 6 million, with a few tens of thousands missing because of serial numbers which were skipped during production.
Currently I have a decent search, where a user can type a number into an input field, and the repeating list of 3k records will filter to show when the input value is found in the records range field.
My issue is that I do not want the input field to be a simple text input field. I want the users number input to be selecting the record itself - So I can instantly without a search, know the record and display other important info.
I think what I am looking to do is essentially make a dropdown-type field instead of an input field - and as the user types, matching individual number choices will populate, with the possible choices being all numbers contained within the ranges of the Record’s each items Range field.