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.

Savings to Excel with Field Title Modified?

Featured Replies

Hello all,

I have been asking this question in the past and I just want to know if there will be any ideas on this? Thanks..

I am doing parsing from reports (generic reports parsing). I want to know if FileMaker can modify the Field Title when savings to Excel.

For example: I have 3 Fields which are Account Number, Names, and Balance. I would like FM to export to Excel like this:

Account Number Names Balance Date

12345 John Doe 123.55 02/02/08

55555 John Smith 15665.66 01/01/08

But the unique thing is I should set up the "Field Title" in other fields because the field name can change. For the next report, the field could be like this:

Account Number Names Date Misc.

12345 John Doe 02/03/07 Paid

55555 John Smith 05/05/07 UnPaid

Is that possible for FM to do that? Or is there workaround? I tried to modify field to TEXT field, however, when I exported to Excel, it would ask to convert to a number field.

If you need more information, I can give more explanation.

Thank you.

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.