allow me to select an autocomplete value field that is separate from the field filtered on
When adding an autocomplete field to a form, I would like to be able to select the table/view, the field to filter on AND the field value to store in the record. So that, for example, if I am using an autocomplete field to let someone choose a person, I should be able to choose the 'fullname' field for autocomplete to scan, but 'personid' should be the value that gets stored in the record when it is submitted.
Kamil Baran commented
Another idea with the same suggestion: http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/43534743-make-the-autocomplete-and-dropdown-fully-interchan
Matt Parkan commented
This would be very useful. The virtual autocomplete field doesn't work for tabular reports.
Terry Coates commented
I was able to re-create this function. I created a virtual autocomplete field and used that to do the autocomplete based on the field I want the user to search on. The actual field I need to populate I then set as a Cascading Text Field. It then looks up the virtual value. Check the box for "Make field non-editable when filter only finds one match" and it works perfectly.