Discussions

 View Only
  • 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

    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">https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=602">https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=602