If you had a function that converts the feet and inches of heightPref to a numeric inches field, that would be the cleanest and not prone to the issue noted above. Or you could simply create a lookup collection with those two fields (height and heightInches), populate it with all of the possible heights, and have that be the data source for the dropdown. You would then store the inches the user enters, and that would be the field the filter uses.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Filter dataset not working | 5 | 907 | December 3, 2018 | |
| Issues with Filtering | 14 | 2170 | May 6, 2019 | |
| Populate table based on _createdDate. | 8 | 369 | February 15, 2018 | |
| how to create a filter search for repeaters | 9 | 1654 | February 26, 2018 | |
| Filter dynamicDataset causing repeater to show nothing | 1 | 150 | March 10, 2019 |