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.

using a compound if function

Lougee
in Calculation Engine (Define Fields)

Featured Replies

I'm using John Osborne's visibility trick to hide a menu button when it's not applicable. I defined the field 'visibilityLodging' as a compound IF function -- if (attending? = "yes" and commute? = "stay", 1,""). The relationship is valid (visibilityLodging on the left; constant on the right) and the correct fields are in the correct portals.

Can anybody tell me what I'm doing wrong? Does the visibility trick not work on a compound IF? Or (horrors!! shocked.gif ) have I defined my field wrong? It seems such a simple thing and I don't get any FM error message when I save my field definition.

Feeling totally brain dead -- ti's been a long, hard day... confused.gif

I know that someone out there (probably EVERYONE out there) can give me the right answer.

Abbe

For testing, first make the calculation really simple -- like =1. Then see whether the protal is doing its thing correctly. If its not then fix it. If it is, then the calc needs looking at.

Do your field names actually contain "?"....sometimes fields with such characters don't do well in calculations. Just a thought!

Do your field names actually contain "?"....sometimes fields with such characters don't do well in calculations.

This was my initial thought, but I checked and it seems that ? is not on the list of forbidden characters.

I think what you have to do is break it down first and try one at a time before you combine them. You might find that there is a problem somewhere else.

Your compound IF statement is fine, and there is no problem using such a statement as the driver for portal invisability.

Just a wild guess, but you might like to check whether the visibilityLodging and constant fields that are used for the relationship are both the same result/data type. If, for example, one of then is set to produce numbers and the other is set as text, then that could lead to a problem!! ... ooo.gif

Maybe the calculated key is an unstored calc. That will disrupt the relationship. If it is unstored, try to change it to indexed.

I see now that your calc is on the left side of your relationship, so this is unlikely to be the culprit.

Create an account or sign in to comment

https://fmforums.com/topic/12927-using-a-compound-if-function/
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.