Action/bot to update an Existing Row with values from the new Row in another Table

Hello everyone, thank you in advance for your help.
I am fairly new to AppSheet and am trying to figure out how to update an existing Row with values from a form that updates a different table.
I'll explain the structure.
Table "IN" - The table where the user creates a row when starting a job
Table "OUT" - The table where the user creates a row when they end a job
Table "ENTRY" - Table that will hopefully summarize in one row the IN and OUT of the specific job

All three tables have a column called [PairingID] that is used to match the rows from "IN" and "OUT"

I managed to create the 3 Tables, the 2 Views that allow users to perform the start and the end of the job. I was also able to create the Action and the Bot that allows the values in "IN" to be transferred into "Entry" but I am struggling to create the Action and the Bot that transfers the values in "OUT" into the correct row in "Entry" (looking for the [PairingID] to identify the correct row to paste the values.

Hopefully, this is clear enough.
Thank you!

0 5 99
5 REPLIES 5
Top Labels in this Space