
1. Re: Calculate inches to feet
philmodjunk Jun 5, 2014 4:50 PM (in response to notJames)Feet will be:
Div ( HeightInInches ; 12 )
Remaining inches will be:
Mod ( HeightInInches ; 12 )

2. Re: Calculate inches to feet
RiannaStar Aug 7, 2014 2:16 PM (in response to notJames)This forum helped but I cannot get it to display as in and feet.
i.e. I was able to format the field "lowered height" = 135
to "lowered height ft" = 113.
I need it to say 11' 3"
Can anyone help?

3. Re: Calculate inches to feet
philmodjunk Aug 7, 2014 2:25 PM (in response to notJames)Let ( [ ft = Div ( HeightInInches ; 12 ) ;
in = Mod ( HeightInInches ; 12 ) ] ;
If ( ft ; ft & "'" ) & in & "\""
) 
4. Re: Calculate inches to feet
philmodjunk Aug 7, 2014 2:26 PM (in response to notJames)"'" is a single quote enclosed in double quotes.

5. Re: Calculate inches to feet
notJames Aug 9, 2014 10:33 AM (in response to notJames)So I used that last calc to format a height field with the height and inch marks.
Now I want that field to be the result of one of two different entries. I have a popover that allows the user to enter either total inches (Field 1) or feet and inches (Fields 2 and 3). What calculation should I use for that?
Or alternatively, how do I override the calculated height field so that the user can just enter the feet and inches manually?

6. Re: Calculate inches to feet
philmodjunk Aug 9, 2014 10:06 PM (in response to notJames)There's more than one way to do that. Here's one:
If ( IsEmpty ( HeightInInches ) ;
FeetFIeld & "' " & InchesField & "\"" ;
Let ( [ ft = Div ( HeightInInches ; 12 ) ;
in = Mod ( HeightInInches ; 12 ) ] ;
If ( ft ; ft & "'" ) & in & "\""
)// Let
) // IF 
7. Re: Calculate inches to feet
philmodjunk Aug 9, 2014 10:07 PM (in response to notJames)There's more than one way to do that. Here's one:
If ( IsEmpty ( HeightInInches ) ;
FeetFIeld & "' " & InchesField & "\"" ;
Let ( [ ft = Div ( HeightInInches ; 12 ) ;
in = Mod ( HeightInInches ; 12 ) ] ;
If ( ft ; ft & "'" ) & in & "\""
)// Let
) // IF 
8. Re: Calculate inches to feet
RiannaStar Aug 11, 2014 11:16 AM (in response to notJames)Hello,
Thank you for the replies.
Let me be more specific because I for some reason can't figure it out.
The first field "lowered height" I manually enter in inches.
The next field is "Lowered height Feet" I need it to auto populate from the "Lowered height" field but display in ft & in.
i.e. if I type in 109" "Lowered Height Feet" to display automatically as 9ft 1in.
I currently have it formatted as "Div ( Lowered Height ; 12) & Mod ( Lowered Height ; 12 )"
and the Lowered Height Feet is displaying as "91" instead of 9ft 1in. ....
Can anyone help?
Kind Regards,
Rianna Star

9. Re: Calculate inches to feet
philmodjunk Aug 11, 2014 11:23 AM (in response to notJames)That's why I set up the calculation like this:
Let ( [ ft = Div ( HeightInInches ; 12 ) ;
in = Mod ( HeightInInches ; 12 ) ] ;
If ( ft ; ft & "'" ) & in & "\""
)//LetIf ( ft ; ft & "'" ) & in & "\""
Is the part that takes the values computed by the Div and Mod functions and inserts the needed foot and inches symbols. in the expression, ft & "'", you have a single quote (for the feet symbol) enclosed in double quotes.

10. Re: Calculate inches to feet
RiannaStar Aug 11, 2014 11:38 AM (in response to notJames)I'm sorry I guess I don't understand.... the only way I could get it to work was with the inserted "lowered height" in the formula but I guess I'm not Pro savvy enough to translate yours to mine....
Thanks though

11. Re: Calculate inches to feet
philmodjunk Aug 11, 2014 1:20 PM (in response to notJames)Let ( [ ft = Div ( Lowered height Feet; 12 ) ;
in = Mod ( Lowered height Feet; 12 ) ] ;
If ( ft ; ft & "'" ) & in & "\""
)//Let 
12. Re: Calculate inches to feet
RiannaStar Aug 11, 2014 3:01 PM (in response to notJames)Ok I got it! I thought for sure I had already tried it like that, but must have done something wrong. It works now! Thank You!