0

If the value is not different from the previous one

I have a digital field containing information and a 'Date+Time' field to record the time of change. I have a question: Is it possible to set it up so that if the new value is the same as the old value, the time of change does not update?

4 replies

null
    • Fred
    • 3 mths ago
    • Reported - view

    Sure, please post your current code so we can see what is going on.

      • iliper LTD
      • iliper_LTD
      • 3 mths ago
      • Reported - view

       Hi

      I don't have the code; it's an idea that I want to implement. Now everything works like this: in the field where there is information, in the trigger after the update 

      'Date + Time' := now()

      But I think the formula should look something like this

      if oldData != newdata then

      'Date + Time' := now()

      The point is that I need to record the time when the information was changed

    • Fred
    • 3 mths ago
    • Reported - view
     said:
    The point is that I need to record the time when the information was changed

     I don't remember if you in the cloud, but if you are then you can use the _md command to access the modification date/time that Ninox records for the record. I checked with a Number field, if I change it to the exact same data then the modification date/time does not change and only changes when the data is different.

    I checked with a Trigger after update and in a Number field if I enter the same data then the Trigger is not triggered.

    Are you manually entering the same data or is the data being updated by a script?

      • iliper LTD
      • iliper_LTD
      • 3 mths ago
      • Reported - view

       

      I am currently working at APP; we enter the changes manually. Yes, when I enter the same number, then nothing changes.

      Thank you

Login to reply

Content aside

  • Status Answered
  • 3 mths agoLast active
  • 4Replies
  • 25Views
  • 2 Following