Glasstream Posted February 4, 2017 Posted February 4, 2017 I am pulling data out of FileMaker 10 server to a web page and displaying numbers in a table, everything works great! until a number goes over 9,999.00 then it just doesn't display at all. Anyone have any idea what is causing this and how to fix it? I assume it would lay in my php code since the number 11,000.00 is showing in the database, just not in my table on the web page. My code: <?php echo '$'.number_format(round($Number_row->getField('iAverage'),2),2); ?> Any help would be much appreciated!
Glasstream Posted February 5, 2017 Author Posted February 5, 2017 I figured it out, it seems Filemaker wants the straight number 10000 instead of entering 10,000.00. It shows the same in the database, but when carried over to the web page it doesn't.
Lee Smith Posted February 5, 2017 Posted February 5, 2017 Hi Glasstrean, version 10 lacks a lot of the finer formatting tools through the Inspector (introduced in version 11). Go to the Menu Bar >> Format >> Number and you will see the menu like the attached. HTH Lee
Recommended Posts
This topic is 2848 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 accountSign in
Already have an account? Sign in here.
Sign In Now