2 Replies Latest reply on Dec 7, 2015 1:30 AM by Stu412

    Create table view auto formats to percentage

    Stu412

      Hi there

       

      I just want to create a table view of an existing layout which I've already created.  Each time I create it and add fields, the numbers are auto formatted as percentages which is pretty useless.  These numbers are not formatted as percentages on the original layout and I've no idea why FM is doing this, but having a foreign key auto format to a percentage is pretty rough.

       

      Any suggestions how to get this sorted, given I cannot seem to find the inspector on 'Modify' view when setting this table up.

       

      Thanks in advance all

        • 1. Re: Create table view auto formats to percentage
          Extensitech

          Not sure what this means:

           

          I cannot seem to find the inspector on 'Modify' view when setting this table up.

          Do you mean Layout mode? If so, go into layout mode and look in the View menu for "Inspector".

           

          Now, to your problem at hand.

           

          If all new number fields that you add to your layout are set to display as percentages, I suspect that you've inadvertently set this in the inspector as your "default".

           

          Try this: Go into layout mode, and open the inspector. With no layout objects selected, go to the Data tab on the inspector, go down to the bottom where the "Data Formatting" section is. Click the ".01' button for number format. In the popup where it says "Format", change that from "Percent" (which is what I suspect it says now) to "General".

           

          When you set or change settings on the Inspector without any specific layout object selected, those options are considered your defaults for when you add new layout objects. If you were to follow the steps in the previous paragraph, for example, and set the format to "currency" with 2 decimal places, FM would assume that any new layout objects (that are numbers) should be formatted as 2-decimal currency.

           

          HTH

           

          Chris Cain

          Extensitech

          • 2. Re: Create table view auto formats to percentage
            Stu412

            Thanks for that Chris, couldn't find it for looking. 

             

            Regarding the other point you questioned, when I'm in table mode, I can click Modify to add/remove fields, but cannot use the inspector in this view.  Perhaps I have things set up slightly incorrect.

             

            Thanks