Hey everyone! So I am super knew to Weweb and supabase and I am trying to create a time clock for my employees. I have a sign in page set up and a clock in button that insterts a new row into a table in supabase. but the problem that I came across now is updated that row to give a clock out time. When you click the clock in button it gives a time stamp and changes a column called status to clocked in and then redirects to the clock out page. when you click the clock out button I need it to update a field in that row that was just made called (clocked out at) with the current time stamp and then change the status column to clocked out. The major problem I am having is helping it understand which row to actually change because it has to be the latest row that this employee has created and not any other users rows. Let me know if you guys can help thanks!!!
Hello, you could add the timestamp/date, e.g date created and fetch the latest last item. Otherwise I’d probably just to two records if it had to be done “quick and easy” and simply change the action column to clocked in/clocked out.