# Discussions

View Only

## Bi-directional weigh conversion, Kg to Lbs, and visa versa

• #### 1.  Bi-directional weigh conversion, Kg to Lbs, and visa versa

Posted 09-29-2017 18:50
I have a client that wants us to enhance their data entry form, which among other data collects a patients weight, so that if the weight is entered as Kg's in one field, a separate field right next to that one will auto-populate with the weight in lbs. They also want the reverse to happen, if lbs is entered then Kg's will auto-populate.

Too me, it sounds like I might need to create a bunch of weight formula fields and have form rules determine which ones show when. Has anyone done this, or can anyone think of an easier way?  Need some guidance.

Thanks!

• #### 2.  RE: Bi-directional weigh conversion, Kg to Lbs, and visa versa

Posted 09-29-2017 18:56
You will have 3 fields.  All can show at all times.

1- [Enter Amount]
2- [Weight UOM]  - Multiople choice of either "KG" or "LBS"
3- [Alternative Amount] - Formula text that will evaluate what UOM you selected and show the opposite.

Of course you will have to have the math work both ways.  A case formula should do it;

Case([Weight UOM],
"kg", (math to convert kg to lbs) &" lbs",
"lbs", (math to convert lbs to kg) &" kg",
"")

• #### 3.  RE: Bi-directional weigh conversion, Kg to Lbs, and visa versa

Posted 10-10-2017 15:17
It worked!  Thank you!

• #### 4.  RE: Bi-directional weigh conversion, Kg to Lbs, and visa versa

Posted 09-29-2017 19:10
This is simple to do using the IOL technique. This is how I calculate the distance between Earth and Planet Claire - just enter a siriometer or parsec number and blur the field:

Siriometers & Parsecs Auto Conversion

https://haversineconsulting.quickbase.com/db/bm5hr643j?a=nwr

Siriometer
The siriometer is a rarely used astronomical measure equal to one million astronomical units, i.e., one million times the average distance between the Sun and Earth. This distance is equal to about 15.8 light-years, 149.6 Pm or 4.8 parsecs, and is about twice the distance from Earth to the star Sirius.
https://en.wikipedia.org/wiki/List_of_unusual_units_of_measurement#Siriometer