Jump to content

Limit to text in calculation fieldAt th


This topic is 5758 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

I am trying to make a calculation field that uses "if" logical functions to result in a text strings, but there seems to be a limit to the amount of letters you can have in a text string. Is there a way around this?

Here's the calculation I would like to create:

If(Membership Category = "$25 Contributing", "The Interpreter newsletter and program and book discounts.", If(Membership Category = "$50 Supporting", "The Interpreter newsletter, program and book discounts and a second program participant discount.", If(Membership Category="$100 Sustaining", "The Interpreter newsletter, program and book discounts, a second program participant discount, plus an invitation-only behind the scenes tour of Sugarloaf Cove.", If(Membership Category = "$250 Sponsor", "The Interpreter newsletter, program and book discounts, a second program participant discount, an invitation-only behind the scenes tour of Sugarloaf Cove and a copy of the year's best North Shore interpretive book.", "other" )) ))

At this point the calculation still works, but if I add another "if" with and even longer text string, I get a notice saying the text is too long within the "".

I would like to use this as a merge field in a Word document.

Any ideas? Am I even on the right track?

I only have FM 6.

Thanks, MT

Link to comment
Share on other sites

Hi

Use the Case function, something like:

Case(

Membership category = "$25 Contributing", "The Interpreter newsletter and program and book discounts.",

Membership category = "$50 Supporting", "The Interpreter newsletter, program and book discounts and a second program participant discount.",

Membership category="$100 Sustaining", "The Interpreter newsletter, program and book discounts, a second program participant discount, plus an invitation-only behind the scenes tour of Sugarloaf Cove.",

Membership category = "$250 Sponsor", "The Interpreter newsletter, program and book discounts, a second program participant discount, an invitation-only behind the scenes tour of Sugarloaf Cove and a copy of the year's best North Shore interpretive book.",

"other"

)

BTW: if a string in a calc is longer than 255 chars, use fields. So the above calc becomes:

( A,B,C and D are global fields )

Case(

Membership category = "$25 Contributing", A ,

Membership category = "$50 Supporting" , B ,

Membership category = "$100 Sustaining" , C ,

Membership category = "$250 Sponsor" , D ,

"other"

)

Link to comment
Share on other sites

I believe a better solution would be to add a file of MembershipCategories, with fields for Category, Fee and Bonus(?). Define a relationship from your current file to MembershipCategories based on Category, and lookup the Fee and the Bonus from the related record.

This way you can change the fees and the incentives without changing your calculation, and more importantly, without messing up your history.

Link to comment
Share on other sites

This topic is 5758 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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