Can we add a row to another table if the current table's data changes ?

I tried many ways, but can not figure it out, please help me

My english it not so good, so I will try to explain in order : 

 

1. I have a table name "PO DETAIL", I created an automation : if there's any kinds of data changes in PO DETAIL then send an email --> it works every time ( sending email ) when data changes

kvngo94_0-1650095088081.png

2. I created an action (Data : add new row) to a different table name  "PO"

    Everytime I click on the action button, it works ( it adds new row with any kinds of desired row data )

 

3. But then I tried to combine (1) and (2), it doesn't work when I have any kinds of data changes on PO DETAIL table, it doesn't create new row on PO table. 

   Please educate me if I did it wrong, thank you

   

kvngo94_1-1650095317357.png

 

 

 

0 2 73
2 REPLIES 2
Top Labels in this Space