gofmp15

Sort a Text Field... Make it a $$Variable

Discussion created by gofmp15 on Jul 1, 2017
Latest reply on Jul 1, 2017 by gofmp15

Finally, after 30 years I can sort the contents of a field using a FileMaker function.

 

Create a Calculated Value field and uncheck do not replace.

 

SortValues ( UniqueValues ( Self ) )

 

After you enter text in the field it will be sorted. The sort is up to you to define this just uses defaults.

 

Enter:

Bird

Apple

Horse

Chicken

Dog

Horse

Bird

Frog

 

 

Commit record and it becomes:

Apple

Bird

Chicken

Dog

Frog

Horse

 

Now I can use fields: Description and Text and VariableName and do stuff with that. For instance, Insert the text into the Variable creating an instant list variable. Insert the variable name into a text object on a layout...

Outcomes