2 Replies Latest reply on Apr 21, 2016 1:15 PM by fred@kca-inc.com

    Sorting on calculated fields using global fields


      I have created calculated "Sort_Ascending" and "Sort_Descending" fields to sort a portal by clicking column headings.  A bunch of Case statements depending on the value in the global "Sort_Field" field.  If the "Ascending_Descending" field is 0, the "Sort_Ascending" field calculates blank and visa-versa for 1.  This is a multi-user, WebDirect environment.  I use these global fields in the same table to determine which field to sort on and ascending or descending.


      The question is: since global fields are unique to the user, will the calculation (and sort) based on the values in the global fields be unique to the user so each user can sort the portal independently?


      I'd sure appreciate any thoughts here.