# Prevent duplicate dates **URL:** \ **Category:** Ask for Help\ **Created:** [October 24, 2025, 10:46am UTC](https://community.glideapps.com/t/prevent-duplicate-dates/85064 "2025-10-24T10:46:57Z")\ **Posts on this page:** 7\ **Page:** 2
**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 27, 2025, 11:57pm UTC](https://community.glideapps.com/t/prevent-duplicate-dates/85064/23 "2025-10-27T23:57:02Z")
Sounds like you just need to store a person ID in the Scores table, alongside the Sweep ID. Then in the Sweeps table, make a multi relation to return all people in a Sweep, and have a joined list column to return a comma-delimited string of person IDs. In your choice component, point to the list of all people, filter by rowID is not included in screen \> comma-delimited string above. ---
**Author:** ![jejones](https://avatars.discourse-cdn.com/v4/letter/j/e274bd/32.png) [@jejones](https://community.glideapps.com/u/jejones)\ **Post date:** [October 28, 2025, 12:40pm UTC](https://community.glideapps.com/t/prevent-duplicate-dates/85064/24 "2025-10-28T12:40:06Z")
I don’t have specific ROW ID columns. I assume this method won’t work unless these are created? ---
**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 28, 2025, 12:43pm UTC](https://community.glideapps.com/t/prevent-duplicate-dates/85064/25 "2025-10-28T12:43:07Z")
It’s always best to use RowIDs for this sort of thing, as they are guaranteed to be unique. ---
**Author:** ![jejones](https://avatars.discourse-cdn.com/v4/letter/j/e274bd/32.png) [@jejones](https://community.glideapps.com/u/jejones)\ **Post date:** [October 28, 2025, 1:43pm UTC](https://community.glideapps.com/t/prevent-duplicate-dates/85064/26 "2025-10-28T13:43:48Z")
The fields I was referencing have unique data but they’re not appearing when I try to add a filter to the choice component. That’s why I asked. I thought perhaps a row ID had different characteristics that allowed it to be seen across multiple components. ---
**Author:** ![jejones](https://avatars.discourse-cdn.com/v4/letter/j/e274bd/32.png) [@jejones](https://community.glideapps.com/u/jejones)\ **Post date:** [October 28, 2025, 6:10pm UTC](https://community.glideapps.com/t/prevent-duplicate-dates/85064/27 "2025-10-28T18:10:41Z")
It took a while but your suggestion worked. Thank you. ---
**Author:** ![jejones](https://avatars.discourse-cdn.com/v4/letter/j/e274bd/32.png) [@jejones](https://community.glideapps.com/u/jejones)\ **Post date:** [October 28, 2025, 6:37pm UTC](https://community.glideapps.com/t/prevent-duplicate-dates/85064/28 "2025-10-28T18:37:22Z")
It’s okay. I figured it out. Looking at the table below, I am trying to create a column that will tell me which scores have been used on which date. I created a relation field where date is mapped to Scores-Placing but that’s not giving me anything. How can I create a column that will show me every placing used on the same date? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c5deab39da0f7e647c4d292c932ccb7b2f529161.png) ---
**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, 2025, 11:43pm UTC](https://community.glideapps.com/t/prevent-duplicate-dates/85064/29 "2025-10-30T23:43:58Z")
Is the table above supposed to store “scores” as well? I’m not sure what you mean by “created a relation field where date is mapped to Scores-Placing but that’s not giving me anything” (aren’t those different types of data?) [Previous page](https://community.glideapps.com/t/prevent-duplicate-dates/85064.md?page=1)