AnsweredAssumed Answered

Sorting Rows in FileMaker 15

Question asked by Lawrencex on Nov 27, 2016
Latest reply on Nov 28, 2016 by Lawrencex

Hello Filemaker Pros,

 

Would appreciate some tips for the following:

 

I have Fields "A" "B" "C" "D."   Each of those fields contains values, eg:

Field A=420,  B=220  C=101   D=315.  The values are always at random,

and changes for each record.

 

I have to sort these values in Fields: AA, BB, CC, DD in the order of

smallest to biggest, for the example above, as : AA=101, BB=220,

C=315  D=420.

 

I am trying to get a function or a script to organise sorting these

4 fields to produce the said result, but seem to be a difficult task

to achieve.

 

This is somewhat similar to MS Excel functions, Large() and Small ().

 

Thank you in advance for your hints/tips.

 

Lawrencex

Outcomes