Field Format Calculation

[tmas73]

I have a Radio Button that displays oz and gram.

How can I format the fields from oz to gram when switched? Is it a calculation in the field itself?

Thanks

[bcooney]

Radio buttons contain the text whatever is selected. So, if gram is selected, the field contains the word, "gram."

[tmas73]

Radio buttons contain the text whatever is selected. So, if gram is selected, the field contains the word, "gram."

Thanks,

yes but I need to figure out the calculation. The Radio buttons are like a preference and once clicked between ether entrie the field should display the proper weight in oz or gram. A weight conversion.

[comment]

See two conversion examples in the attached file.

Hint: always keep your amounts (numbers) and your units (text) in separate fields.

Conversion.fp7.zip

Edited April 9, 2008 by Guest

[tmas73]

See two conversion examples in the attached file.

Hint: always keep your amounts (numbers) and your units (text) in separate fields.

Great thanks for the file works great. I just wonder, there is no way to just use the amount field and the Unit field. It cant be done by a calculated value instead of a calculation field?

Thanks for the help. =)

[comment]

Not really. You need to know FROM which units you are converting. You could use a Text field in the form of "###g" or "###oz" - but then you wouldn't be able to summarize it.

[comment]

That is, unless you use a hack.

ConversionAE.fp7.zip

[tmas73]

That is, unless you use a hack.

That is, unless you use a hack.

Awesome thats what I was looking for. What was the hack?

Thanks a lot!

[comment]

The hack is using Get ( ActiveFieldName ) with the field name hard-coded as into the formula as literal text. If you rename the field, it will stop working - until you fix the formula to reflect the change. Not a pretty method, but it will do in a pinch.

[tmas73]

The hack is using Get ( ActiveFieldName ) with the field name hard-coded as into the formula as literal text. If you rename the field, it will stop working - until you fix the formula to reflect the change. Not a pretty method, but it will do in a pinch.

Works great. Fixed my problem. Thanks a lot!

T