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
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?