1 Reply Latest reply on May 10, 2012 1:17 PM by philmodjunk

    Conditional timestamp auto-enter

    cemesas

      Title

      Conditional timestamp auto-enter

      Post

      I would like a timestamp field to behave in the following way: if a certain radio button set ("Yes" or "No" options) is set to the "Yes" option, it should display the value of another given timestamp (lookup or copy). If the answer is "No", it should remain blank, available to edit.

      Can someone help me?

        • 1. Re: Conditional timestamp auto-enter
          philmodjunk

          Where would that "another given timestamp" be located? Would it be a field in a related table?, the current timestamp from your system clock? A different field in the same record?

          All are possible if you set up the field as an auto-entered calculation on the timestamp field:

          IF ( RadioButtonField = "Yes" ; OtherTimeStampField )

          or

          IF ( RadioButtonField = "Yes" ; Get ( CurrentTimeStamp ) )