oneillrj@pbapi.com

How to sort a portal based on a text field with numeric values.

Discussion created by oneillrj@pbapi.com on May 17, 2018
Latest reply on May 18, 2018 by edwardlscott

I looked using the search tool but found no answer.

 

FileMaker Pro 16 Windows platform

 

I have been asked to sort a portal using one field which contains numbers. But, one of those records could contain a text value. Here is an example of the data I need sorted:

 

6

12

18

24

30

36

TIP

 

When I set the data type of this field to numeric I can't use 'TIP'.

 

When I set the data type of this field to text I get the following:

 

12

18

24

30

36

6

TIP

 

Any thoughts?

Is there a setting I have not yet located?

Outcomes