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.

is question mark as a record a problem in Find?

Featured Replies

Hello,

I have a field which is formatted as value list (strict, do not allow modification). Some of the values also contain a question mark (among other characters). When I want to perform a find and I select an item from the value list, which contains such a question mark I get the message that the field value I've choosen as a find criteria is invalid (accept this value does not work). Why is that, and how can I avoid it?

Thanks.

csb

In find mode, a question mark means "invalid date or time". It's in the list of symbols that show up in the status bar when in find mode.

Basically, the answer is not to use the question mark in find mode. Just look up the rest of the value.

  • Author

My problem is that the question mark formes part of a record. So I have a value list containing a value which looks like: What happened to Herodotus? Problems of Classical History. Say this is a book, which is a collection of essays. I have a database where I record all the individual essays in different recrods, and select as source title for each record the book title above. When I want to filter all records that belong to the same book I choose the title via a script from the value list (returns all articles that are to be found in the same book). The problem however appears when the title (which is used in the filter function) contains a question mark. Since the filtering is automated I am not able to change the value that FM is about to filter.

Do I have to include a line in the script to tell how to handle those records from the value list, which contain a "?" ?

csb

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.