Forum Discussion
JordanMcAlister
5 years agoQrew Captain
Is it a matter of reading the data, or does the data get exported? If it's the former - you could always have the feet and inches field for editing and a separate field for viewing that combines feet and inches no matter if they decide to put the total amount of inches or not.
What I use is:
ToText([Measured Pole Ht. (Feet)]) & " ft " & [Measured Pole Ht. (Inches)] & " in (" & ([Measured Pole Ht. (Feet)]+Round((0.0833333*[Measured Pole Ht. (Inches)]),0.01)) & " ft)")
If 245 inches were inputted into the inches field, it would display: 0 ft 245 in (20.42 ft)
That way I know what was inputted and then the equivalent in feet and we convert everything to decimal
Other than that I don't know of a way to limit the values in a numeric field - that would indeed be very helpful.
------------------------------
Jordan McAlister
------------------------------
What I use is:
ToText([Measured Pole Ht. (Feet)]) & " ft " & [Measured Pole Ht. (Inches)] & " in (" & ([Measured Pole Ht. (Feet)]+Round((0.0833333*[Measured Pole Ht. (Inches)]),0.01)) & " ft)")
If 245 inches were inputted into the inches field, it would display: 0 ft 245 in (20.42 ft)
That way I know what was inputted and then the equivalent in feet and we convert everything to decimal
Other than that I don't know of a way to limit the values in a numeric field - that would indeed be very helpful.
------------------------------
Jordan McAlister
------------------------------