1 2 Previous Next 18 Replies Latest reply on Jun 24, 2016 7:12 AM by Mike_Mitchell

    Create calculation based on other record criteria in the same table?

    tomperr

      Is it possible to create a calculation in a field with the result based on meeting criteria from another record within the same table?

      For example, records will fall within a portal:

      Fields:      Names           cActual Date

                          Bench          1/1/16

                          Chair           1/15/16

                          Stool            1/16/16

       

      The calculation would be in cActual Date.     

      This would essentially say:

      for Bench record:     if Name = "Bench" ; result 1/1/16

      for Chair record        if Name = "Chair" ; result cActual Date of Bench+14 = 1/15/16

      for Stool record        if Name = "Stool" ; result cActual Date of Bench +15 = 1/16/16

       

      Criteria within the table is dependent on field contents of another record within the same portal.

       

      Is this possible?  If not, is there a work around?

        1 2 Previous Next