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 a repeated field

Featured Replies

I need to export a repeated field into Excel. The export will only pass the first value when 'Excel' is chosen as the file format.

CSV or tab delimited would be ok too as they can be opened in Excel. The repeated field will export, but when opened in Excel, it opens with all values in a single cell.

Is there any way to export a repeated field so that each value in the repeated field has its own cell when the file is opened in Excel?

The general advice about repeating fields is that if you have to ask questions about how to use them, you shouldn't be using them. There are many problems with repeats; this is yet another case in point. It would be better to ditch the repeating fields and use a related table.

  • 3 weeks later...
  • Newbies

Create a new FM file with the same field names as the fields you want to export (matching field types, of course). Import the data into this file and choose "Split Repeating Fields into Separate Records". Then import from that file into Excel.

If you'll need to do this regularly, create another table in the file and use the above technique with it. You could even script the import.

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.