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.

Variable value list flaky in Find Mode

Featured Replies

Hi-

I just can't seem to find a work around for this one...

Here's the scenerio: (running in Find mode)

I have a field called "field_search". This is a pulldown field, where the user decides which field they'd like to search. Search criteria is entered into a field called "search_criteria". What I need to happen is depending on what field is chosen in "field_search", the appropriate value list will appear in the "search_criteria" field.

What I have tried: (all running in find mode)

Enter data into "field_search". Click on "search_criteria" field, which executes a script that populates a global field called "pulldown" with 'set field' with data from "field_search". The script finishes by select/perform in the "search_criteria" field so that the pulldown info should appear. (Note: "search_criteria" is set as a pulldown with the value list from the calculation field "search_criteria copy".

Here is the calc for "search_criteria copy":

If(pulldown="winery",ValueListItems(Status(CurrentFileName),"Winery Name"),If(pulldown="City",ValueListItems(Status(CurrentFileName),"City"),""))

The value lists "Winery Name" and "City" created by referencing their respective fields (Winery Name looks to field "Winery Name" and City looks to field "City")

Here is what happens:

If I reimport the data, it works, but the more I play around with it, the value lists get combined (city and winery end up in the pulldown together.)

If I change the calculation or such, the pulldown will sometimes stop working altogether.

I'm really trying to understand why this is happening so I can figure out the appropriate work around.

Any ideas??

Thanks in advance!!

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.