Can you use a repeater to filter dataset?

I have a group of 2000 members, some with same last names, that I want to be able to enter the last name in and input box letter by letter, having the repeater update the minimum fields in a repeater that identifies that person. Then click on that record to populate a detailed form containing all their data fields. A dropdown box doesn’t work because it can only contain one field. I have it working up to clicking on the repeater record to filter the dataset for the form. Any ideas?

Hello.

Filtering a dataset with a repeater isn’t really an ideal thing. As such, I would suggest using two dropdowns and c hange the options of the second dropdown based on a previous selection. Check out this example: https://www.wix.com/corvid/example/cascading-form

Good luck!

Yes I was thinking of setting first letter of last name ranges like “A-G”, “H-P”, & “Q-Z” in the first dropdown and then using a second dropdown from that pick but I haven’t been successful with that yet.