Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Auto fill from a value list

schlick
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

I have developed a client / job tracking system for our graphic design shop using FM 7. When a new job is created, the user selects a client from a popup list which is related to the Clients table. This works very well, but since we have well over 100 clients, the popup list is getting a bit cumbersome to navigate.

What I'm wondering is this: Is there any way, instead of having a standard popup menu, to start typing in the Client Name field and have FM return a list of values containing the letters you've typed. The behavior would be very similar to how an email client might retrieve a popup list consisting of "David", "Dan", "Darla" when you type the letters "Da".

Hope this makes sense. Thanks in advance for the help.

Regards,

David

Take a look at John Mark Osborne's TypeAhead. http://www.databasepros.com

I prefer to start in the Client table and create a new job from there.

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.