Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Field Format Calculation

tmas73
in Calculation Engine (Define Fields)

Featured Replies

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

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

  • Author

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.

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 by Guest

  • Author

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. =)

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.

  • Author

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!

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.

  • Author

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

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.