Discussions

Expand all | Collapse all

Automation to modify current record based on a checkbox

  • 1.  Automation to modify current record based on a checkbox

    Posted 04-23-2019 03:18
    I am working on an automation that triggers based on a "create invoice" checkbox being checked by a user. When this field is checked, the automation creates a record in the "Invoices" table with the value of its key field being passed from a field in the child "Charges" table. I need to be able to pass the value of this same field into the reference field "Related Invoice" on the same table that the automation is being triggered from however I am unable to do so as Quick Base will not allow me to save the automation.

    I understand this may be because an automation cannot modify the same record that it is being triggered from however is there a work around to get this to be successful?


  • 2.  RE: Automation to modify current record based on a checkbox

    Posted 04-23-2019 03:27
    Niraj,

    Not sure why it would not allow you to save the automation. But to your question about having an automation modify the same record that triggered it, yes you can. Just include an action that modifies the same table where the primary key of the target table is the primary key of the triggering table (source)


  • 3.  RE: Automation to modify current record based on a checkbox

    Posted 04-23-2019 17:25
    Thanks Surya.

    I thought the same but the automation UI will not allow me to save as the button is greyed out and when I hover over it, I get not available sign.  See attached picture.

    I am not sure I follow what you mean by "Just include an action that modifies the same table where the primary key of the target table is the primary key of the triggering table (source)". My automation action to input the related invoice (parent table) is based on a value that is already calculated in the same table the action is being triggered from.


  • 4.  RE: Automation to modify current record based on a checkbox

    Posted 04-23-2019 17:50
    Niraj, As discussed, since the filtering criteria is missing in action 2, it is not letting you save the automation.