Forum Discussion
BrianHunot1
4 years agoQrew Cadet
Hey Mark, I haven't quite built all of the tables and fields to make this work, figuring out the best way to do it. There are a couple of different facets in the relationships. I was considering relating the table to itself, but hadn't thought about conditional drop downs.
I've been hoping I wouldn't have to make a bunch of tables or fields.
It would be convenient to have a formula field that acted like a standard text field, but that doesn't seem to be possible. Is there a way to have a formula field reference the contents of a text field and use it as a variable so to speak for the formula. This can be done in Excel. It's really the same basic CASE formula across all the calculations. And the inches / measurement component is always a number between 0 and 99.
------------------------------
Brian Hunot
------------------------------
I've been hoping I wouldn't have to make a bunch of tables or fields.
It would be convenient to have a formula field that acted like a standard text field, but that doesn't seem to be possible. Is there a way to have a formula field reference the contents of a text field and use it as a variable so to speak for the formula. This can be done in Excel. It's really the same basic CASE formula across all the calculations. And the inches / measurement component is always a number between 0 and 99.
------------------------------
Brian Hunot
------------------------------
MarkShnier__You
Qrew Legend
4 years agoAre you just asking for an example of a single hard coded IF statement to do the conversions all in one long formula. Sure that is possible.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------