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.

disappearing portal trick

Featured Replies

In FM6, I used to use the disappearing portal trick described on page 414 of "Special Edition: Using Filemaker Pro 5". Basically you use a portal to make buttons and fields diappear or reappear based on a relationship. I can't seem to make this same bahvior work on FM7. I'm trying to make a "show all contacts" button disappear when the user is viewing the complete set of records, but when the user is viewing a smaller found set, the "show all contacts" button would reappear. Any idea what I may be doing wrong? Or is there a change in behavior in FM7?

it all hinges around a constant .ie a calc of no 1

if xyz field is empty then set field as 0

if xyz field is not empty set field as 1

then create a relationship so it only displays those fields with value 1

this becomes your portal related table choice

  • Author

Yes, I understand that.

Here's how I had it set up in FM6

In my data file:

findportal=if(found_records=total_records,0,1)

found_records=status(currentfoundcount)

total_records=status(currentrecordcount)

in a separate file named constants, I have only one record. I have a number field named "one" which has the value of 1.

Then I have a relationship where "find_portal" from the data file = "one" from the constants file

Then I have a portal with a "show all contacts" button on it. When the found set is less than the total number of records, the "show all contacts" button is visible. When the found set equals the total number of records, the "show all contacts" button disappears.

Here's how I had it set up in FM7

In my data table:

findportal=if(found_records=total_records,0,1)

found_records=get(foundcount)

total_records=get(totalrecordcount)

in a separate table named constants, I have only one record. I have a number field named "one" which has the value of 1.

Then I have a relationship where "find_portal" from the data table = "one" from the constants table

Then I have a portal with a "show all contacts" button on it. But the portal is not disappearing when the total records equal the found records. What's really odd is that when I move to a different record the button does disappear, but when I move back to the original record, the "show all contacts" button incorrectly returns. Since the number of records in the found set has nothing to do with what record I am on, I would expect the appearance or disappearance of the portal to be the same throughout all the records. But that is not the case.

Anyone have any ideas?

Try puting the constant in the the data table. I have had this working in 7 just like it did in pre 7.

You could use get(foundcount) = get(totalrecordcount) since you are usin 1 as you constant.

Create an account or sign in to comment

Important Information

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

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.