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!
User | Count |
---|---|
15 | |
11 | |
10 | |
8 | |
3 |