Is there anyway I can limit the string length in the database or before sending latitude and longitude to the database?

[pboloz]

I would like to limit it to 6 digits after dot

[ridxery]

Use Javascript to format it like this:

Number(1.33555).toFixed(2); // 1.34 , toFixed() rounding up too, if you dont believe me test it :

http://jsfiddle.net/FQTqk/730/

[pboloz]

Thanks, but I am afraid I need step by step instruction where to add this JS. Somewhere when I do mapping?

[ridxery]

you can do it on mapping tab like create 2 local variables from right top at data mapping tab, then you can click to add JS (next to the created local variable) you should see a tab saying,

function (value , element) {
parseFloat(value).toFixed(6);
}

PS: you dont need to create local variables to do this, any entity got JS button next to them however saving user's location would be good , you might need it again.

[ridxery]

you dont need to create local variables to the this, any entity got JS button next to them however saving user's location would be good , you might need it again.

[pboloz]

I have put it here but it did not work

Have I done sth wrong?

[ridxery]

var x = parseFloat(value).toFixed(6);

return x;

try this one.

[pboloz]

Awesome! Thanks!

[ridxery]

no problemo