Discussions

Expand all | Collapse all

How can I use Automations to update a field in the same table as the trigger?

  • 1.  How can I use Automations to update a field in the same table as the trigger?

    Posted 09-10-2018 17:19
    I would like to use automations to copy the value in one particular formula field into another history (log edits) field when a key approval is given.  Both the trigger and the action would take place in the same table, and in fact, in the same record.  

    Is this possible?  I have played with the automations interface and so far it is not working for me.


  • 2.  RE: How can I use Automations to update a field in the same table as the trigger?

    Posted 09-10-2018 17:25
    Yes it is quite possible. Even QB Actions, and Webhooks can do that. In the Action, choose the "other" table (where is says advanced...) then select the same app and the same table and in the conditions, select where Record ID# = Trigger:Table:Record ID#.


  • 3.  RE: How can I use Automations to update a field in the same table as the trigger?

    Posted 09-10-2018 19:10
    Thank you Surya!  It works!


  • 4.  RE: How can I use Automations to update a field in the same table as the trigger?

    Posted 09-11-2018 15:18
    Glad to help.