Updating Specific Record in a Relation using Set Columns

Ask for Help
1

I have a Master Table where duties are assigned to members spanning multiple days. For example, Person A is assigned duty on 30-Aug and 31-Aug. I also have another table that records the Check In and Check Out times for users. This table would have two rows for each user: one for 30-Aug with Check In and Check Out times, and another for 31-Aug.

Here’s the issue:

•	When a user checks in and checks out on 30-Aug, a record is created with both Check In and Check Out times updated for that date.
•	The next day, when the user checks in on 31-Aug, a new row is created with only the Check In time, leaving the Check Out time empty.
•	When I try to update the Check Out time at the end of the day using the Set Columns action on a Relation, it mistakenly updates the Check Out time for the 30-Aug entry instead of the 31-Aug entry.

Is there a way to specifically update the correct row (31-Aug) in the relation using Set Rows or another method?

2
  • Use a Query instead of a relation, then you can use a filter to specifically target the row that has an empty check out time for that user.
  • Then take a Single Value->First->Whole row via the Query, and you will be able to Set Column Values via the Single Value
1 Like