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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Calculation for specific text order & format

Followers

July 3, 200718 yr

Ok, I have yet another calculation that is stumping me.

I have a checkbox set of provinces. I have created a calculation field (with the help of the some wonderful people here) that outputs the selected provinces with a specific format, in an alphabetically ordered list separated by commas.

So - for a record with Ontario, Quebec, and Manitoba selected - the calculation field for the desired output would be "Canada (Manitoba, Ontario, Quebec)."

Now, I need to create a new calculation field which will take "Ontario" (when it is selected) and remove it from the list and put it at the end. To clarify, the desired output would be:

"Canada (Manitoba, Quebec), Ontario".

I have spent a good day or more trying to come up with a solution but nothing seems to be working properly.

Any help would be greatly appreciated!