# Marking videos as checked

**URL:** <https://community.glideapps.com/t/marking-videos-as-checked/67375>\
**Category:** Ask for Help\
**Created:** [October 30, 2023, 5:57am UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375 "2023-10-30T05:57:17Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\
**Post date:** [October 30, 2023, 5:57am UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375/1 "2023-10-30T05:57:17Z")

</div>

Hi All,  
here I have app which contains videos, where multiple users will give scores for the same video, , and I want to show something on these video cards, which tells the user that a particular video is checked by them, and again each video will be checked by multiple users, I want to show that which videos they have checked or unchecked, depending on the user logged in

 ![Screenshot from 2023-10-30 11-21-51](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/219a2a1ce7d34e22b720d654c6deb98436757550.png)

---

<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:** [October 30, 2023, 7:47am UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375/2 "2023-10-30T07:47:52Z")

</div>

Add a user specific boolean column to your Videos table. After a user watches a video, use an action to set it to true.

---

<div class="post-metadata">

**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\
**Post date:** [October 30, 2023, 8:22am UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375/3 "2023-10-30T08:22:57Z")

</div>

@Darren_Murphy Thank you for the response, here when a user clicks on video card a detail screen will open in that detail screen it has start rating button, and button opens a marking form after they submit that form, we can consider that user has checked the video, how can I implement it.

---

<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:** [October 30, 2023, 9:54am UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375/4 "2023-10-30T09:54:02Z")

</div>

Extend the action that you already have so that it does a Set Column Values on the Boolean column.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 30, 2023, 11:16pm UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375/5 "2023-10-30T23:16:28Z")

</div>

So the ultimate aim is to mark a video as checked after the user has submitted a rating? Does that rating get added as a row in a separate table?

---

<div class="post-metadata">

**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\
**Post date:** [October 31, 2023, 5:39am UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375/6 "2023-10-31T05:39:17Z")

</div>

@ThinhDinh  
Yes, the rating get added in separate table where as, videos are from separate table.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 31, 2023, 5:40pm UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375/7 "2023-10-31T17:40:21Z")

</div>

> [@star\_struck Rating Component: Display Average Star Rating](https://community.glideapps.com/t/rating-component-display-average-star-rating/58731):
>
> star_struck Star Ratings are back! The Rating component in Glide Pages allows a user to assign a numeric rating to an item by selecting stars. In this video I demonstrate how to set up your Glide tables and screens to allow users to fill out a rating/review form modify their rating afterwards see a count of total ratings per item see average star rating per item view a list of all reviews per item. [[Glide Ratings Component: Accept and Display Average Star Ratings] ](https://www.youtube.com/watch?v=CZkIcLXui10) Enjoy!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 31, 2023, 11:54pm UTC](https://community.glideapps.com/t/marking-videos-as-checked/67375/8 "2023-10-31T23:54:19Z")

</div>

Then, you can use a query on each video row, to check against the Ratings table.

Filter by video ID is this row’s video id, and the user ID/email being the same as the signed-in user’s ID/email (assuming you have recorded those in the Ratings table).

Only show the “check” button if the query is not empty (meaning a rating has not been submitted).
