Jump to content
Sign in to follow this  
Clem

Sort Value List in Reverse Order

Recommended Posts

I need to sort a value list in reverse order of one of the displayed (numeric) fields, but there appears to be no native funtion in FM (v5) to do this.

Obviously, I could create a calculated field with a *-1 version of the original field and use that, but that field would then have to be displayed (a bit ugly). And as the list is to be used to insert a value into a field, I will then have to re-calc to get the correct value in.

Does anyone know of a more elegant solution?

Thanks

Clem (still [fairly] new to Filemaker - so be gentle with me)

Share this post


Link to post
Share on other sites

Hi,

Where is this numeric value list coming from ?

A field, a pre-defined value list or a relationship ?

Share this post


Link to post
Share on other sites

Hi,

Not less ugly than your first solution, use the option "show also field", choose the calc you talked about, and use "sort by second value".

or

if it is just a matter of display on layout, use the calc as your value list, but turn the field to transparent (text and background).

you need ???

field A ----> value list of calc Field C = Field X *(-1)

field B-----> Field A * (-1)

So Field A is transparent and Field B is displayed behing Field A, but only the values of Field B would show, and next calculation would use Field B.

...

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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