Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
dynamic units from formulas
My application allows users to input volumes by different units (gallon, quart, liter...) for different products. I have a product name column and a unit column that is a reference to a units table containing unit names and conversions. I can create a formula - text field where I can concatenate the two for display. However when I'm entering the amount of product it would be nice to have the amount field have gallons (or whatever the unit may be) displayed immediately next to it.

I suppose this would be handy with applications that deal with multiple currencies and their conversions.


ID
443
Category
Customization
Author

Jeff Zortman
Date Created
5/1/2011 6:29:30 PM
Date Updated
3/1/2017 7:15:03 AM
Status
New Idea
Score
40
Promoted By
Rick CogleyScott MillerArnold Hakobyan
Jeff Zortman
Comments
Jeff Zortman 3/1/2017 7:15:03 AM
When editing the column Units it would be nice to have the bracket syntax available to be able to reference another column with the unit text. This would make Forms much more compact and elegant.

"Rate" Column setup
Units: [Rate Unit]
Feedback
 
Back to Search Results