2 Replies Latest reply on Feb 15, 2011 12:06 PM by remoran_1

    List Function

    remoran_1

      Title

      List Function

      Post

      I am using the list function on a portal. The function works perfectly for one record as it gives me hard returan, which I need, and places duplicat information in different fields (FromExamdateasText, ToExamDateasText) but I don't know know how to do it for multiple records. The portal contains 6 rows and works perfectly as does the database. Any help on this would be terrific.

      TIA

      remoran

        • 1. Re: List Function
          philmodjunk

          Say you have these tables:

          parent::ParentID = Child::ParentID

          On a layout based on Parent, you have a portal to Child with these values listed in different portal rows in a field named Fruit: Apple, Orange, Kiwi.

          Then a calculation field defined in Parent as List ( Child::Fruit ) will return the list:

          Apple
          Orange
          Kiwi

          A script step executed from the same record in the Parent layout that uses this expression will also return this list.

          • 2. Re: List Function
            remoran_1

            Hi Phil

            It works. Awesome. Thank you so much.