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.

Predefined Value list as result of case function

Featured Replies

  • Newbies

Ok, here's the scoop:

I'm trying to create a dynamic portion to my DB for what will eventually be implemented on the web. Basically I will have a series of drop-down menus where the value list of the second drop down menu is contingent on what is selected in the first value. So I imagine I will use the Case function...

Case(Short_ID="JAZZ"; result is Jazz subcategories appearing in the Subcategory Drop-down list; Short_ID="BLUS"; result is blues subcategories appearing in the same Subcategory Drop-down list... and so on. Does this make sense? is it even possible? Thanks for your help, this exceeds my filemaker knowledge.

Calculation's the wrong approach. You'll need to set up a relationship using "Short_ID" as your key to create a conditional value list.

But there's a catch to your specific requirement ...

Conditional value lists are created by committing the record on IWP. Simply tabbing-out-of/exiting a field won't refresh them on IWP as it does in FileMaker client. This means you'll probably want a script to run after a user selects the first value.

  • Author
  • Newbies

I think I've got you... anyway you could show me a snippet of code for the Conditional Value List?

Thanks!

Create an account or sign in to comment

Important Information

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

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.