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.