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.

Field does not work on export

Featured Replies

I created a full name field by calculating First & " " & Last.

All are text.

It works on the layouts. It works when printing to PDf and preview. I actually see the full name.

I then export the fields to a basic file. This gives me plain text, with each field surrounded by quotes.

The fields all are what they should be, except for the full name field. It is "0" in every single instance.

Why does it not produce text instead of 0?

Is there any other way to output the fields as plain text.

I don't really need the quotes, but I do need text in a file (not pdf)

Are you sure the result of the calculation is Text?

Check that the Full Name field calculation is set to return "text" and not "number". Its default is to return a number.

While viewing the field on a layout FMP is being forgiving and displaying the contents of the field as entered (which is non-numeric). However when exporting it appears that FMP is stricter and is evaluating the field contents as a number or boolean (which if the field only contains text is being evaluated as zero).

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.