Skip to main content
Known Participant
July 23, 2020
Question

Convert number to feet & inches

  • July 23, 2020
  • 2 replies
  • 2349 views

Good morning, 

 

I need a hand please with code that takes height and converts it to a more detaliked version. 

 

Height would be entered like this for feet & inches: 600 (which means 6 feet & 0 inces). I would like it to to display as multi line like this please: 

 

Ft 6

In, 00

 

Thank you in advance. 

This topic has been closed for replies.

2 replies

try67
Community Expert
Community Expert
July 23, 2020

How would you know if 111 means 11 feet and 1 inch or 1 foot and 11 inches?
You can only do it if the value has to be 4 numbers, for example, or if you artificially cap the maximum (and minimum) values, by assuming the value can't be lower than X or higher than Y. Either way, it's tricky.

 

Bob-DoleAuthor
Known Participant
July 23, 2020

So would it be best to use: Ft: 06 | In. 06 = 0606? Could it be done then? Chances of a 10 foot person or 1 foot person completing this are very slim, but I am okay with it being a four number format. 

Bob-DoleAuthor
Known Participant
July 26, 2020

You can use this code as the field's custom Format script:

if (event.value) event.value = "Ft " + event.value.charAt(0) + "\nIn, " + event.value.substring(1);


WOW, perfect! Danke!

Bob-DoleAuthor
Known Participant
July 23, 2020

Is this even doable? lol