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,
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
This is somewhat similar to MS Excel functions, Large() and Small ().
Thank you in advance for your hints/tips.