AnsweredAssumed Answered

Set Field thats not blank

Question asked by kentanderson on Aug 3, 2016
Latest reply on Sep 20, 2016 by philmodjunk

I am trying to set a field with a value from one of 7 fields.  My database has 7 fields that can have data entered.  lets say some one enters date in to three of them i need to set a field with the value of the third field.  But if they enter data into 5 of them i need to set field with value from the fifth field.

The purpose of this is to carry the last data entered forward to the next record.  Please see example.  and Please treat me as the novice i am. Thanks fmp.tiff

Outcomes