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.

Case Function Between two Tables

NuttyMoose
in Calculation Engine (Define Fields)

Featured Replies

My Tables:

Main

Policies

Relationship

MainID --> Rel_MainID

Note: There can be many policies per main page

Fields:

Ins_Status - radio buttons (In House Review, Closed)

Policy_Status - Active and Closed

Is there a way to have a case fuction work between two different tables. I would like a case fucnction to do this. Here is an example: When In House review is selected on the main page I would like the policy_status to change to Active and when closed is selected i would like policy_status to say Closed.

I have tried this: for the field Policy_Status

Case(

Main::Ins_Status = "In House Review", "Active,

Main::Ins_Status = "Closed", "Closed")

But this does not work?

Brahim

Hi Brahim, what you've posted looks like it should work. Are you sure the relationship is valid? Test it by creating another field =IsEmpty ( Main::Ins_Status ).

What is returned by this calculation that you do not expect?

Jerry

If the case statement is a cut&paste from your field definition, there's a " missing from after the second "active" in the Case statement.

It looks like you need for your relationship to go the other way....

MainID <-- Rel_MainID

As it is, are the records in "policies" able to determine which records are related? Maybe I just need more caffeine.

Paul

Create an account or sign in to comment

https://fmforums.com/topic/24378-case-function-between-two-tables/
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.