2 Replies Latest reply on Jul 1, 2017 7:27 PM by gofmp15

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

    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...