I’m trying to make a stamp watch for my employees. I made it as two actions. One for “Punch in” in, and one for "Punch out. I have used the type: “add a new row to another table, using values from this row”
It works fine with “Punch in”,
but when I use “Punch out”, it deletes the value in “Start” column.
I want the values in the same row in different columns.
The only way I have been able to get it to keep the value is to insert an ID column, but then it ends up in two rows
and then I can not calculate the number of hours, the employee had that day.
Any good ideas?