On Thu, Feb 23, 2012 at 9:12 AM, mwcog <amayn...@mwcog.org> wrote:
> Thanks in advance. So i have a custom tabbed infowindow that opens using a
> addlistener event. The tabs work correctly (images, text, links) but my
> number values displayed are strange, for example my cost (in fusion tables)
> is 10.00 but in the info window it appears as 10.00000000. How to I round
> this to 2 significant figures?

> I've tried:

>    1. setting the format in google fusion tables.
>    2. using javascript, for example
>    Math.round(((e.row['Cost'].value)*100)/100). Interestingly, this just
>    removes all decimal places and produces 10.

> Here's a portion of my code, does it look incorrect.

> google.maps.event.addListener(layer, 'click', function(e) {
> if(infowindow) infowindow.close();
> else infowindow = new google.maps.InfoWindow();
>     infowindow.setContent(
>     '<div class="tabs">' +
> '<ul>' +
> '<li><a href="#tab-1"><span>tab 1</span></a></li>' +
> '<li><a href="#tab-2"><span>tab 2</span></a></li>' +
> '</ul>' +
> '<div id="tab-1">' +

>  '<b><div class="infowindow_row">Cost:</b> ' + e.row['Cost'].value + '</div>' +
>  .........................

> The testing site is anacostia.net/maps/tabtest.php <http://www.anacostia.net/maps/tabtest.php>.
>    Thanks for any help you can give me.  Another thing to note is that
> its using a merged table, but i also made sure the parent table columns
> were set to show two decimal places.

>  --
> You received this message because you are subscribed to the Google Groups
> "Fusion Tables API Users Group" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/fusion-tables-users-group/-/SWHWRGIcb00J.
> To post to this group, send email to
> fusion-tables-users-group@googlegroups.com.
> To unsubscribe from this group, send email to
> fusion-tables-users-group+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/fusion-tables-users-group?hl=en.

On Thu, Feb 23, 2012 at 6:17 AM, Rob McCausland <rgh...@gmail.com> wrote:
> I just recently noticed a similar problem.  A whole number I'm displaying
> in my Info Window (area TV households) is showing up with a decimal
> followed by 2 digits (zeros).  Other numbers I'm displaying in other
> tables' Info windows are fine.  In the FT web app interface for modifying
> columns, there is no option to choose/deselect decimals and decimal places.

> On Thu, Feb 23, 2012 at 9:12 AM, mwcog <amayn...@mwcog.org> wrote:

>> Thanks in advance. So i have a custom tabbed infowindow that opens using
>> a addlistener event. The tabs work correctly (images, text, links) but my
>> number values displayed are strange, for example my cost (in fusion tables)
>> is 10.00 but in the info window it appears as 10.00000000. How to I round
>> this to 2 significant figures?

>> I've tried:

>>    1. setting the format in google fusion tables.
>>    2. using javascript, for example
>>    Math.round(((e.row['Cost'].value)*100)/100). Interestingly, this just
>>    removes all decimal places and produces 10.

>> Here's a portion of my code, does it look incorrect.

>> google.maps.event.addListener(layer, 'click', function(e) {
>> if(infowindow) infowindow.close();
>> else infowindow = new google.maps.InfoWindow();

>>     infowindow.setContent(
>>     '<div class="tabs">' +
>> '<ul>' +
>> '<li><a href="#tab-1"><span>tab 1</span></a></li>' +
>> '<li><a href="#tab-2"><span>tab 2</span></a></li>' +
>> '</ul>' +
>> '<div id="tab-1">' +

>>  '<b><div class="infowindow_row">Cost:</b> ' + e.row['Cost'].value + '</div>' +

>>  .........................

>> The testing site is anacostia.net/maps/tabtest.php <http://www.anacostia.net/maps/tabtest.php>.
>>    Thanks for any help you can give me.  Another thing to note is that
>> its using a merged table, but i also made sure the parent table columns
>> were set to show two decimal places.

>>  --
>> You received this message because you are subscribed to the Google Groups
>> "Fusion Tables API Users Group" group.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msg/fusion-tables-users-group/-/SWHWRGIcb00J.
>> To post to this group, send email to
>> fusion-tables-users-group@googlegroups.com.
>> To unsubscribe from this group, send email to
>> fusion-tables-users-group+unsubscribe@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/fusion-tables-users-group?hl=en.

>  --
> You received this message because you are subscribed to the Google Groups
> "Fusion Tables API Users Group" group.
> To post to this group, send email to
> fusion-tables-users-group@googlegroups.com.
> To unsubscribe from this group, send email to
> fusion-tables-users-group+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/fusion-tables-users-group?hl=en.

> I see they are formatted  that way in the table.  will reupload this
> weekend.  will let you know if the problem persists.  thanks!
> On Feb 24, 2012 2:51 PM, "Kathryn from Fusion Tables Team" <
> googletables-feedback+kath...@google.com> wrote:

>> Hi Rob,

>> Can you share a link to your table? I'm not able to reproduce this issue
>> with any of my tables.

>> Thanks!

>> Kathryn

>> On Thu, Feb 23, 2012 at 6:17 AM, Rob McCausland <rgh...@gmail.com> wrote:

>>> I just recently noticed a similar problem.  A whole number I'm
>>> displaying in my Info Window (area TV households) is showing up with a
>>> decimal followed by 2 digits (zeros).  Other numbers I'm displaying in
>>> other tables' Info windows are fine.  In the FT web app interface for
>>> modifying columns, there is no option to choose/deselect decimals and
>>> decimal places.

>>> On Thu, Feb 23, 2012 at 9:12 AM, mwcog <amayn...@mwcog.org> wrote:

>>>> Thanks in advance. So i have a custom tabbed infowindow that opens
>>>> using a addlistener event. The tabs work correctly (images, text, links)
>>>> but my number values displayed are strange, for example my cost (in fusion
>>>> tables) is 10.00 but in the info window it appears as 10.00000000. How to I
>>>> round this to 2 significant figures?

>>>> I've tried:

>>>>    1. setting the format in google fusion tables.
>>>>    2. using javascript, for example
>>>>    Math.round(((e.row['Cost'].value)*100)/100). Interestingly, this just
>>>>    removes all decimal places and produces 10.

>>>> Here's a portion of my code, does it look incorrect.

>>>> google.maps.event.addListener(layer, 'click', function(e) {

>>>> if(infowindow) infowindow.close();
>>>> else infowindow = new google.maps.InfoWindow();

>>>>     infowindow.setContent(
>>>>     '<div class="tabs">' +
>>>> '<ul>' +

>>>> '<li><a href="#tab-1"><span>tab 1</span></a></li>' +
>>>> '<li><a href="#tab-2"><span>tab 2</span></a></li>' +

>>>> '</ul>' +
>>>> '<div id="tab-1">' +

>>>>  '<b><div class="infowindow_row">Cost:</b> ' + e.row['Cost'].value + '</div>' +

>>>>  .........................

>>>> The testing site is anacostia.net/maps/tabtest.php <http://www.anacostia.net/maps/tabtest.php>.
>>>>    Thanks for any help you can give me.  Another thing to note is that
>>>> its using a merged table, but i also made sure the parent table columns
>>>> were set to show two decimal places.

>>>>  --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Fusion Tables API Users Group" group.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msg/fusion-tables-users-group/-/SWHWRGIcb00J
>>>> .
>>>> To post to this group, send email to
>>>> fusion-tables-users-group@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> fusion-tables-users-group+unsubscribe@googlegroups.com.
>>>> For more options, visit this group at
>>>> http://groups.google.com/group/fusion-tables-users-group?hl=en.

>>>  --
>>> You received this message because you are subscribed to the Google
>>> Groups "Fusion Tables API Users Group" group.
>>> To post to this group, send email to
>>> fusion-tables-users-group@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> fusion-tables-users-group+unsubscribe@googlegroups.com.
>>> For more options, visit this group at
>>> http://groups.google.com/group/fusion-tables-users-group?hl=en.

>>  --
>> You received this message because you are subscribed to the Google Groups
>> "Fusion Tables API Users Group" group.
>> To post to this group, send email to
>> fusion-tables-users-group@googlegroups.com.
>> To unsubscribe from this group, send email to
>> fusion-tables-users-group+unsubscribe@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/fusion-tables-users-group?hl=en.