AnsweredAssumed Answered

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

Question asked by tomperr on Jun 21, 2016
Latest reply on Jun 24, 2016 by Mike_Mitchell

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?

Outcomes