100% agree this should be in the product. I could do a clumsy alternative by setting text fields as indexed unique values and then doing a series of cascading fields that populate the ID from the selected text, but this should be simple to develop since dropdowns already provide the functionality.

If you have a long list of options, dropdown isn't ideal for the user experience, so you're left having to choose between two poor options within your app.

Gotoassignmenthelp Service endeavors to satisfy the advanced education guidelines of the college/ university through the best quality assignments when you require Assignment Help.
https://www.gotoassignmenthelp.com/blog/times-when-assignments-prove-to-be-of-advantage/

Autocomplete feature can be very useful to be used in Caspio. Let,s say you are a college, who has to maintain a database of students taking Direct admission to Top colleges. They have to use in very different ways as name, age, nationality, etc. There would be very easy to work with this feature. https://www.topbschooladmission.in/bba-pune-direct-admission-admissions-2021top-college-list-eligibility-register-now/

I used Caspio 11 years ago and returned now, and this limitation was back then and was (and still is) so obvious and basic that becomes clear that the product is no evolving at all and it won't do... it is what it is, take it or leave it seems to be the policy here... incredible, but it seems money keeps flowing anyway. Give again votes to this as I did back then... but if 11 years where not enough I'm not confident that anyone at the company is really considering improving this and many other soooo obvious things where Caspio performs poorly.

I researched, and there are four more suggestions about the same functionality of autocomplete fields (as far I understand others). I believe this is a highly needed and valuable feature.

I agree