Jump to content

Field does not work on export


emaven
 Share

This topic is 4384 days old. Please don't post here. Open a new topic instead.

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)

Link to comment
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).

Link to comment
Share on other sites

This topic is 4384 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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