Discussions

Expand all | Collapse all

update a field when selecting another field

  • 1.  update a field when selecting another field

     
    Posted 12-23-2016 20:36
    in my table "clients" I have a field (DME, Field ID 174) that is a dropdown box.


    When any change is made in that field I want to automatically update a date field (Sent Date, Field ID 202) to the current date and time.

    I can't figure out how to do that


  • 2.  RE: update a field when selecting another field

    Posted 12-23-2016 20:42
    If updates are exclusively being done on a form and not in Grid edit, then you can use a form Rule.



    When the record is saved

    and [DME] has changed

    Change [Sent Date] to the current date


  • 3.  RE: update a field when selecting another field

    Posted 02-06-2018 16:50
    Curious to know if you know the reason why this cannot be done using a formula? Or point me at the text. 


  • 4.  RE: update a field when selecting another field

    Posted 02-06-2018 17:41
    A formula can use the field [Date Modified] Bit would not know what field was modified.