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.

Feild value based on value of other feilds

  •
silentmajority37
in The Left Brain

Featured Replies

  • Newbies

I'm not sure how to do this, or if it can be done, so please forgive my ignorance.

I want to be able to calculate a number based on the value of a few other feilds. The values of the other feilds are either "A","V", or "F". If the feilds all have a V, it would calculate a 10, if they all had F's, it would calculate a zero, if it was evenly mixed, there would be a 5.

Does anyone understand what I am trying to say?

I'm having trouble understanding what you want to accomplish.

I think you will probably have to hard code the calculation.

One approach would be to do something like:

Case ( Field1 = "V" and Field2 = "V" and Field3 = "V"; 10 ;

Field1 = "F" and Field2 = "F" and Field3 = "F"; 0 ; 5 )

HTH

Lee

It sounds like your fields should be separate records in a child table. Hard to say for sure with so little information.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

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.