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.

Best way to export related records to text field

Featured Replies

What is the best way to grab all the related records for one record and move that data into a text field so I can parse the data and formate it?

I already have a script that sends an email of my invoices as a text email. I do this by pulling up the invoice record. Then a GTRR step (for line items) and moving to a special layout that shows only the fields I need in a list. I then use the copy all records script step. Then move to another layout that has a global text field and paste the data into it. Now I am able to parse the line items data and formate it. Then I use another global text field to create the text email invoice. Then send this to the email program.

What I want to change in this the copy all records step for the line items. This step overwrites all data on the clipboard. This is bad if a user has something already in the clipboard.

Does anyone know of a better way to do this?

You could create a related value list and then use the ValuelistItems function pull up all the data from the related records. Using the ValuelistItems function in a calculated field or in a Set Field script step avoids the use of the clipboard.

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.