# Updating Specific Record in a Relation using Set Columns

**URL:** <https://community.glideapps.com/t/updating-specific-record-in-a-relation-using-set-columns/76051>\
**Category:** Ask for Help\
**Created:** [September 2, 2024, 4:42am UTC](https://community.glideapps.com/t/updating-specific-record-in-a-relation-using-set-columns/76051 "2024-09-02T04:42:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Huzefa\_khasamwala](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/huzefa_khasamwala/32/79149_2.png) [@Huzefa\_khasamwala](https://community.glideapps.com/u/Huzefa_khasamwala)\
**Post date:** [September 2, 2024, 4:42am UTC](https://community.glideapps.com/t/updating-specific-record-in-a-relation-using-set-columns/76051/1 "2024-09-02T04:42:56Z")

</div>

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:

```auto
•	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?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 2, 2024, 4:46am UTC](https://community.glideapps.com/t/updating-specific-record-in-a-relation-using-set-columns/76051/2 "2024-09-02T04:46:04Z")

</div>

- 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