Newest functions Upload a function Leave a tip My account

There are 2,570 functions in this library.

convertWeight ( value ; input ; output ; precision ; separator )

Converts input of weight to grams, ounces or pounds

  Be the first to rate this function Log in to vote

Jonni™ - Show more from this author

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( [ ~value = value ; ~input = input ; // 1:gr ; 2:oz ; 3:lbs ~output = output ; // 1:gr ; 2:oz ; 3:lbs ; 4:auto_us ; 5:mixed_us ~precision = precision ; ~separator = Case ( separator = 1 ; Char ( 9) ; separator = 2 ; Char (13) ; separator ) ; ~basevalue = Case ( ~input = 1 ; ~value ; ~input = 2 ; ~value * 28.349523125 ; ~input = 3 ; ~value * 453.59290944 ; ~input ) ; // base value is always converted to grams ~result = Case ( ~output = 1 ; Case ( ~basevalue ≥ 1000 ; RoundUp ( ~basevalue / 1000 ; ~precision ) & ~separator & "kg" ; RoundUp ( ~basevalue ; ~precision ) & ~separator & "gr" ) ; ~output = 2 ; If ( RoundUp ( ~basevalue * .03527396195 ; ~precision ) < 1 ; "0" & RoundUp ( ~basevalue * .03527396195 ; ~precision ) ; RoundUp ( ~basevalue * .03527396195 ; ~precision ) ) & ~separator & "oz" ; ~output = 3 ; If ( RoundUp ( ~basevalue * .00220462262185 ; ~precision ) < 1 ; "0" & RoundUp ( ~basevalue * .00220462262185 ; ~precision ) ; RoundUp ( ~basevalue * .00220462262185 ; ~precision ) ) & ~separator & "lbs"; ~output = 4 ; Case ( ~basevalue * .03527396195 ≥ 16 ; RoundUp ( ~basevalue * .00220462262185 ; ~precision ) & ~separator & "lbs" ; If ( RoundUp ( ~basevalue * .03527396195 ; ~precision ) < 1 ; "0" & RoundUp ( ~basevalue * .03527396195 ; ~precision ) ; RoundUp ( ~basevalue * .03527396195 ; ~precision ) ) & ~separator & "oz" ) ; ~output = 5 ; Case ( ~basevalue * .03527396195 ≥ 16 ; Round ( ~basevalue * .00220462262185 ; 0 ) & ~separator & "lbs " & If ( RoundUp ( RoundUp ( ~basevalue * .03527396195 ; ~precision ) - ( Round ( ~basevalue * .00220462262185 ; 0 ) * 16 ) ; ~precision ) < 1 ; "0" & RoundUp ( RoundUp ( ~basevalue * .03527396195 ; ~precision ) - ( Round ( ~basevalue * .00220462262185 ; 0 ) * 16 ) ; ~precision ) ; RoundUp ( RoundUp ( ~basevalue * .03527396195 ; ~precision ) - ( Round ( ~basevalue * .00220462262185 ; 0 ) * 16 ) ; ~precision ) ) & ~separator & "oz" ; If ( RoundUp ( ~basevalue * .03527396195 ; ~precision ) < 1 ; "0" & RoundUp ( ~basevalue * .03527396195 ; ~precision ) ; RoundUp ( ~basevalue * .03527396195 ; ~precision ) ) & ~separator & "oz" ) ) ] ; ~result ) // Input parameters: // 1 : grams (divide kg values by 1000 before entering) // 2 : ounces // 3 : pounds // Output parameters: // 1 : grams (will output kg with set precision when output value is above 1000 gr) // 2 : ounces // 3 : pounds // 4 : auto_us (outputs anything under 16oz as ounces and as pounds if greater or equal than 16 oz // 5 : mixed_us (outputs whole pound units as pounds with remaining weight trailing as ounces) // Separator: // 1 : Inserts a tab character to separate values and legends // 2 : Inserts carriage return to separate values and legends // # : Set any text in quotes to add as separator ( " " : for space) // Written by jonni@me.com // V 1.3 Click to copy

An input of weight as grams (1), ounces (2) or pounds (3) will output

1 : grams, will output kg with set precision when output value is above 1000 gr
2 : ounces
3 : pounds
4 : auto_us, outputs anything under 16oz as ounces and as pounds if greater or equal than 16 oz
5 : mixed_us, outputs whole pound units as pounds with remaining weight trailing as ounces

Set precision parameter to indicate number of decimals in the returned response. The function will only return decimals for ounces when using mixed_us output format.

Separator:

1 : Inserts a tab character to separate values and legends
2 : Inserts carriage return to separate values and legends
# : Set any text in quotes to add as separator ( " " : for space)

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: