Survey123: How to maintain trailing zeros in rounded Lat/Long numbers

[Katie_Clark]

Hello,

I created a survey in Survey123 Connect that automatically records the coordinates of the point and displays them to the user in a Note field.

I have that note field set to round to 6 decimal places, but in cases where there are zeros at the end of the coordinate, it does not display the zero. Here is an example:

For consistency in the final reports, it is important this this field always have 6 decimal places, even when the last number is a zero. Is there a way to accomplish this?

[JamesTedrick · Accepted solution]

Hi Katherine,

There isn't a direct number padding/formatting function in the XLSForm; that being said, we should be able to do this in the future with custom JS function (currently in beta) using the .toFixed() method - JavaScript Number Methods 

[Katie_Clark]

Thanks James. I learned about custom JS functions at the UC and it seems I'll be able to use them to fix several of the roadblocks that I've been facing with Survey123. Very excited about this capability! (now, time to learn JS...)