6 Replies Latest reply on Feb 17, 2012 1:15 PM by MacMak

    Field Specific Time Stamp

    MacMak

      Title

      Field Specific Time Stamp

      Post

      Hello.

         I have a field called 'record_status' which is a drop down list of Needs Review, Incomplete and Complete. I have another field called 'record_status_mod' which is supposed to have a Time Stamp of when the 'record_status' was listed as Complete - not Incomplete or Needs Review only Complete.

      Any help with this would be greatly apreciated.

      Thanks!

      MM

        • 1. Re: Field Specific Time Stamp
          philmodjunk

          Define record_Status_mod as a field of type Time Stamp and give it this auto-entered calculation:

          If ( record_status = "Complete" ; Get ( CurrentTimeStamp ) ; self )

          You can then experiment with clearing the "Do not replace existing value" check box to see which option works better. With the check box cleared, selecting "complete" in the record_status field will update the time stamp data. Leaving it selected results in the time stamp being entered the first time complete is selected and it then remains unchanged as long as the field is not cleared.

          • 2. Re: Field Specific Time Stamp
            MacMak

            Hello Phil.

                Thanks for your reply. I entered the information but for some reason it still does not enter the timestamp. I also changede the field to a time stamp.

            Would you happen to know more?

             

            Thanks

            • 3. Re: Field Specific Time Stamp
              philmodjunk

              I tested this on a test file to make sure it worked before it posted.

              Do you only select single values from the drop down or multiple values? I assumed single values here. If you have other data in the field so that the exact contents are not "complete" it won't work as written.

              Is the drop down's field of type text? (check in manage | database | fields) If not, change it to text.

              • 4. Re: Field Specific Time Stamp
                MacMak

                Yes single values and drop down field is text yes

                • 5. Re: Field Specific Time Stamp
                  philmodjunk

                  Create a brand new record and select "complete" from your value list. Do you see a date and time appear in the time stamp field? (You do have two different fields, one text with the value list and one of type timestamp with the auto-entered calculation, right?)

                  • 6. Re: Field Specific Time Stamp
                    MacMak

                    You know I apologize for some reason I did not notice the correct word was completed - not complete so there was a d missing on the end. Everything is working fine now thank you very much! Sorry for the extra time it took.