Issues with "Save as Excel"
In a table layout, I have a "full name" field which is a calculation of first and last name. It works fine in FMP and shows up as I want it to, but when I go to save it as an excel, it puts zeros in those fields (no names at all). What am I doing wrong? Do I need to change the calculation? I have it as a
FullName= FirstName & " " $ LastName
I know I can do a calculation field in Excel, but I'm trying to make the export as painless as possible for my end-users who need this information in an excel format.
Check the result type specified for your calculation. My guess is that Number is specified in place of text.