Jump 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.

dynamically filtering a value list?

iluro
in Value Lists

Featured Replies

  • Newbies

Hi,

I have a project table where I need to update a contact_id field (a foreign key to a contact table). This is easy with a dropdown list and a value list, but the problem is the contact table is in the thousands of records and therefore it's tedious to locate the one needed (specially when you only know a part of the name).

One solution could be to build up a value list entering a part of the name of the contact on a text field, which then would filter the records that contain this string. I've been strugling with this without success, because all I tried involved calculations that could not be indexed.

Anyone? I'd thank very much any help!

Llorenc

Create an account or sign in to comment

https://fmforums.com/topic/55107-dynamically-filtering-a-value-list/
Go to topic listing

Important Information

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

I accept

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.