Skip 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 calculation to mimic a portal?

Featured Replies

  • Newbies

I have the following problem: The child table is records of line items with an AmountPaid field related to the original parent table by a numeric field, ApplicationNumber. I have six calculation fields in the parent that need to contain the AmountPaid values for the first six related records (one-to-one) from that child table for export (along with a ton of other data from other related tables) to a csv file for upload to a mainframe.

The user doesn't need to see/manipulate these values, so I don't need a portal in a layout. The original programmer created 6 different relationships with 6 fields in the parent table composed of ApplicationNumber & ".1", ApplicationNumber & ".2", etc. In the child table he had a field composed of ApplicationNumber & "." and a field which was a lookup on a Count calculation of related records back in the parent table, mimicking the behavior of Get(RecordNumber) in a Find operation to get the requisite match. It worked, but it hurts my brain everytime I see it. Is there a clearer, easier way to do this?

Thanks,

MichaelE

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.