Lawrencex Posted July 30, 2014 Posted July 30, 2014 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 Posted July 30, 2014 Posted July 30, 2014 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 Posted July 30, 2014 Posted July 30, 2014 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.
Recommended Posts
This topic is 4041 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 accountSign in
Already have an account? Sign in here.
Sign In Now