pc Sorting Data Fields in a Row

[Lawrencex]

Hello FileMaker Pro experts,

 

Would appreciate your help for the following:

 

How do I sort data in a row of Fields?

For example: Fields A=300,   B=100,   C=600,   D=200,   E=400,   F=500

 

I have to obtain the following results for the above data in Fields: P,Q,R,S,T,U

sorted in ascending order as:

P=100,   Q=200,   R=300,   S=400,   T=500,   U=600.

 

How do I formulate the calculations in Fields: P,Q,R,S,T,U to obtain the results

in ascending order?

 

Many thanks in advance.

 

Lawrencex

[Lee Smith]

Hi Lawrencex and welcome to the FM Forums,

 

It is hard for us to totally understand your needs when you use generic terms, please use actual field names, scripts, table names, etc. when describing your needs.

 

One of the great things about our Forum, is that you can attach a copy of your file, or a mockup. That way we can use your naming convention in our replies.

 

The benefits of doing this are that you will get a response that you can implement easier and quicker. To attach a file, just follow the steps provided here. ATTACH A FILE.

 

Lee

[comment]

Short answer: fields cannot be sorted.

 

While you could devise some sort of a mechanism to produce the expected result using a script or a custom function, the simple and correct remedy is to use a related table to hold the values - with each value being an individual record.