Jump to content
Sign in to follow this  

Field does not work on export

Recommended Posts

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)

Share this post

Link to post
Share on other sites

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).

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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