XLSform calculation, entering number with 0ne digit like 1 but save with three digit lisk 001

Hello everyone,

I want to enter integer value, if this value has one digit such as 1 it
saves into database with 3 digits like* 001* if enter integer with 2
digits
like 11 it saves like 011 and if enter with three digits it saves
111.

please help me how to do this.

Many Thanks

Integers do not store with leading zeros -- they store as integer values.

Displaying with leading zeros is a formatting choice.

If you must display with leading zeros, there might be a configuration
setting in Google Sheets or Fusion Tables for display purposes. Look at
setting up a publisher into one of those and doing the display formatting
there.

ยทยทยท On Sat, Jan 23, 2016 at 7:41 PM, mohammad mirzaie wrote:

Hello everyone,

I want to enter integer value, if this value has one digit such as 1
it saves into database with 3 digits like* 001* if enter integer with 2
digits
like 11 it saves like 011 and if enter with three digits it
saves 111.

please help me how to do this.

Many Thanks

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com