“Auto Complete Anywhere” in Lookups

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Friday, August 26, 2016PrintSubscribe
“Auto Complete Anywhere” in Lookups

Touch UI applications created with Code On Time offer powerful lookups that allow the user to activate the grid view of the lookup controller, use auto complete to find a value, or select the value from a list.

By default, auto complete will search for values that begin with the typed-in query. For example, the picture below shows that typing in “es” in the Supplier Company Name lookup will result in finding the single value “Escargots Nouveaux”.

Touch UI lookups will auto complete for values that start with the search query.

Lookups also support the ability to match values anywhere in the value. In order to enable this functionality, the data field must have Search Options configured with the tag “$autocompleteanywhere”.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab, and expand to “Products / Views / editForm1 / c1 – Products”. Double-click on “SupplierID” data field.

Selecting the SupplierID data field of Products controller.

Make the following changes:

Property Value
Search Options $autocompleteanywhere

Press OK to save the data field, and press Browse to regenerate and open the web app in the default browser.

Navigate to the Products page, edit a product, and start typing in the Supplier Company Name lookup. Notice that the typed text will now be matched anywhere in the lookup values.

The Supplier Company Name lookup now matches the auto complete string anywhere in the lookup value.