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.

VL show one thing, pass another?

KurtW
in Value Lists

Featured Replies

Hey all:

I want to allow a user to select a month, day and year from popup-menus to create a search date for a find. I want to display the month name as the selection choice, but want to pass the month number as the actual data entered into a global field for my calculation.

I know how to display a second value in the list, but that

Make a table that has 2 fields Month (number) MonthName (text). Use this for your value list Month first value, Monthname second value.

  • Author

Thanks Ralph - I actually did exactly that but found I was seeing both values in the dropdown but FM told me it was passing only the 1st value. I guess I screwed it up, then.

I will try that again from the start.

Kurt

  • Author

AH! I had it backward. The monthName is now just a display tool but the monthNum is entered into the field. I get it.

That should do it for me. Thanks for the help.

Kurt

Or use a calculation of

(Position( "JanFebMarAprMayJunJulAugSepOctNovDec"; Left( yourfield; 3 ) ) + 2) / 3

Create an account or sign in to comment

https://fmforums.com/topic/28203-vl-show-one-thing-pass-another/
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.