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

• 0
• Question
• Updated 2 years ago
• Answered
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!
• 170 Points Posted 2 years ago

• 0
• 31,758 Points 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",
"")
• 170 Points It worked!  Thank you!

Ⲇanom the ultimate (Dan Diebolt), Champion

• 30,434 Points 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

Google: convert Siriometer to Parsecs
https://www.google.com/search?q=convert+Siriometer+to+Parsecs&oq=convert+Siriometer+to+parsecs

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=602
(Edited)