Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Apply current layout’s data formatting to exported data


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

Recommended Posts

Posted

Just verifying that only "number, date, and time data " get carried over. The reason for this is that fm's documentation is, imho, confusing:

 

"  
If necessary, select Apply current layout’s data formatting to exported data to format field data as it appears on the current layout.
FileMaker Pro allows you to format fields on a layout, which makes the data look different on the layout than how it is actually stored in the database file. (For more information, see Formatting and setting up field objects in Layout mode.) Select Apply current layout’s data formatting to exported data when you want to export number, date, and time data using the field formats specified on the current layout. Clear this option to export number, date, and time data exactly as it is stored in the field. (If you’re exporting to DBF format, this option is not available.)"
 
But aren't date, time and number formats non layout specific and set in the db management? Does it then mean that if I bold and set red on field it's going to export that too IF it is a date?
Posted
But aren't date, time and number formats non layout specific

 

Yes - but this feature allows you to override the format used by the file in favor of the format used by the field instance on the current layout. For example, even if your file uses M/D/Y as its date format, you can still export dates as YYYY-MM-DD if you have formatted the date field on the current layout to display the dates that way.

 

Does it then mean that if I bold and set red on field it's going to export that too IF it is a date?

 

No. Text styles are not exported.

This topic is 3853 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
×
×
  • Create New...

Important Information

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