8 Replies Latest reply on Jul 6, 2016 8:31 PM by nancyhorne@centurytel.net

    list function

    nancyhorne@centurytel.net

      Help please - I think this is easy... I have many activity records for each person. There is an activity portal on the people table layout that is sorted most recent first.

       

      I have an export activity field which turns the portal row field info -  date into text and adds the content.

      Creation Date Mo & " " & Creation Date Day & ", " & Creation Date Year & ¶ &

      Content &"-------"& ¶ & ¶

       

      I created a script that takes the activity line items per person and puts them into one field. Problem is  it is sorted from oldest to newest and

       

      February 13, 2002

      Content

      ___

       

      June 15, 2003

      Content

      ___

       

      November 19, 2015

      Content

      ___

       

       

      I want it sorted from newest to oldest - which the portal is.

      November 19, 2015

      Content

      ___

       

      June 15, 2003

      Content

      ___

       

      February 13, 2002

      Content

      ___

       

      A loop script would be OK but can't get it to work in the people table layout.

      Thanks in advance!