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.

Reduction of choices available based on previously chosen VL choices

Featured Replies

If my grammar in the title is anything like my calc syntax I'm in BIG trouble. :D

Please refer to the attachment. The plan is to let users, using FMP 9.x, enter then select their search criteria for use in a report; the Custom VL List for all three text fields (named Sort_Choice1, Sort_Choice2, and Sort_Choice3) contains the same labels as what you see on-screen: Date Range, School, Grade, Period, Teacher, Student, and Attendance Code.

What I want to do is prevent users from selecting a choice more than once. For example, if s/he picks Date Range for the primary sort and High School for the secondary sort, I don't want the goof to pick Date Range or High School again for the Tertiary choice. So, I don't know how to approach and solve the problem: Should I create a convoluted calc with test fields so as a choice is made it's eliminated from the available list choices, or...?

With script triggers this would be a little easier to put together but because it's v9.x, well...

TIA for your help and input!

Rich

Screen shot 2011-02-08 at 10.55.53 AM.png

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.