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.

How do you remove the last row in a portal??

Featured Replies

Suppose you have a grid with some items in it, say customer names.

You have a button on the far right, which allows the user to jump to another layout to see more details about the customer record in the grid.

the thing is that there is always a blank record after the last one and it shows a button, but no data?

is there some magic setting to turn off this option?

thanks,

J__ confused.gif

It shows the last row because you have "allow creation of related records" turned on for the TO relationship.

Question: Do you want to enter new records in the portal?

If not, then just turn off the option, in the relationship dialog.

If so, then you'll need to create a Container field, with global Storage, to put the button's graphic in. And a calculation, which checks some essential data before showing the button. Say you have an auto-entered serial ID field (which you usually should have).

_gButtDetails

_cgButtDetails = Case ( not IsEmpty (SerialID, _gButtDetails, "")

Put the calculation field in the portal, as a related field. Voila. No button on the last row.

There is what some would call a bug in 7.0v3 in that the global field must be 1 pixel bigger than the graphic on each side, or it gets chopped (with Crop option, which is the only reasonable one for this).

In earlier versions it could be exactly the same size, with borders on all sides, with line width set to none. Who knows what the future holds?

Duplicate the global field to get the calculation field. Saves some time.

  • Author

excellent. Thanks for the response, I really appreciate it.

But wait!

You make the container field a calculation field?

how does that hide the button? with a case? I'm expecting something like HideButton()?

thanks again for the answer.

sincerely,

J__

Since the button is a container field and there is no record for the last row. There is no button until a record is created.

  • Author

ah, right I get it. yeh duh... I wasn't thinking of it that way.

thanks,

sincerely,

J__

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.