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.

Exporting the first row of portal information

Featured Replies

My main file, Dealers, has a portal that shows the related records from Contacts. I need to be able to export the information from Dealers with only the first Contact from the portal which will probably change each time we export.

My idea is to create fields in the Dealer file for first and last names, email, etc. then create an export script that when selected will take the information from the first row of the portal for contacts and insert it in to the fields in Dealers. That way we are just exporting 1 contact.

Is there a better way?

A calc that just amounts to

Dealer::Name

will automatically pull data from the first related record according to the relation's sort order (creation by default, but I assume you have it sorted differently). Likewise with your other fields.

Oops, I should clarify. I meant that you should include *on* the dealers table layout a field which is Contacts::Name, or define a calc field to be Contacts::Name.

Create an account or sign in to comment

Important Information

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

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.