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.

modifying a value list

peggymcl
in Value Lists

Featured Replies

  • Newbies

Is there a way to set a field to look up information from other fields, and yet still allow modification? Specifically I have a donor with names and addresses etc. I have fields for title, first1, last1, title 2, first2, last2. I want the data base to automatically enter Mr. and Mrs. George Smith, unless I know the donor prefers to be listed as The Smith Family, in which case, I'd hand enter that listing.

Add an override field and then change your calculation to:

Case (not IsEmpty(Override), Override, X)

Where "X" is your original calculated entry.

You can elaborate on this technique with another field for Greeting:

Case (not IsEmpty(Override), Override,

Greeting = "Formal", Title & " " & Last,

Greeting = "Informal", First,

Greeting = "Family", "The" & " " & Last & "Family)

Create an account or sign in to comment

https://fmforums.com/topic/4308-modifying-a-value-list/
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.