Jump to content

Muddled Sort


Sagaces
 Share

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

Recommended Posts

  • Newbies

I have a calculated field that is derived from three other fields, "Organization, Last Name, and First Name." The fields appear in the calculated result in the order shown. The calculated field might display as

Organization

or

Organization / Last Name, First Name

or

Last Name, First Name

depending on which of the composing fields have values.

The problem is that a sort, even when including only the calculated field in the sort definition, seems to always be based on the contents of the Last Name field.

I've been unable to locate any parameter in FileMaker which would produce this behavior, so here goes the old "Help" cry.

Link to comment
Share on other sites

You're sorting only on the calculated field? Is it set to a result type of text? Please provide your calculation and an example of the data and sort order. Or just post the file.

Link to comment
Share on other sites

  • Newbies

I've gotta bow my head in shame -- I forgot to set the result type to "text." With a slight grump in my favor, I would think that Filemaker could (would? should?) set the default type according to the nature of the calculation and also give the user an optional reminder dialog at the time of submission of the calculation.

Link to comment
Share on other sites

This topic is 6469 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.