# Duplicate records **URL:** \ **Category:** Ask for Help\ **Created:** [May 6, 2024, 9:51pm UTC](https://community.glideapps.com/t/duplicate-records/73130 "2024-05-06T21:51:47Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Janis\_Balodis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/janis_balodis/32/81993_2.png) [@Janis\_Balodis](https://community.glideapps.com/u/Janis_Balodis)\ **Post date:** [May 6, 2024, 9:51pm UTC](https://community.glideapps.com/t/duplicate-records/73130/1 "2024-05-06T21:51:47Z")
Hi, From time to time, when a user creates a new order record, the Glide app assigns the same order number, therefore creating duplicate order number records. This mostly happens when a user is using the app offline. As I understand, in such an offline scenario, it is not possible to avoid duplicate number assignments to orders, so I would like at least to mark them. What formula can be used to display any kind of symbol or notification in the row next to the duplicated records? Then I can think of visually displaying such duplicate record notifications in the order window. Thank you in advance for your assistance. Janis ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 6, 2024, 10:26pm UTC](https://community.glideapps.com/t/duplicate-records/73130/2 "2024-05-06T22:26:29Z")
Create a relation linking the order number to itself. Then create a rollup column to count the number of matches. Then create an IF column to check if the rollup is greater than 1. If it is then return an emoji or text that you can merge with other text using a template column. ---
**Author:** ![Janis\_Balodis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/janis_balodis/32/81993_2.png) [@Janis\_Balodis](https://community.glideapps.com/u/Janis_Balodis)\ **Post date:** [May 6, 2024, 10:29pm UTC](https://community.glideapps.com/t/duplicate-records/73130/3 "2024-05-06T22:29:06Z")
Thanks, Jeff, let me try ---
**Author:** ![Janis\_Balodis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/janis_balodis/32/81993_2.png) [@Janis\_Balodis](https://community.glideapps.com/u/Janis_Balodis)\ **Post date:** [May 6, 2024, 10:40pm UTC](https://community.glideapps.com/t/duplicate-records/73130/4 "2024-05-06T22:40:04Z")
Well, something is not right. The Rollup column returns a quantity of the ordered products within that order, not the count of the order numbers. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 6, 2024, 10:42pm UTC](https://community.glideapps.com/t/duplicate-records/73130/5 "2024-05-06T22:42:18Z")
It should be doing a Count from the relation. How did you configure the Relation? How did you configure the Rollup column? ---
**Author:** ![Janis\_Balodis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/janis_balodis/32/81993_2.png) [@Janis\_Balodis](https://community.glideapps.com/u/Janis_Balodis)\ **Post date:** [May 6, 2024, 10:51pm UTC](https://community.glideapps.com/t/duplicate-records/73130/6 "2024-05-06T22:51:04Z")
Here are screenshots of how I configured both columns ![Marivo_Oil_Piegāde_·_Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/368b9edc6b2a8792803e4763d974e81261d4e698.png) ![Marivo_Oil_Piegāde_·_Glide-2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/ed736358cf2bf978d24318e45b3b3e8eafae4007.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 6, 2024, 10:54pm UTC](https://community.glideapps.com/t/duplicate-records/73130/7 "2024-05-06T22:54:15Z")
This isn’t the ‘Rel to Orders’ column you created. ![Screenshot_20240506-175312](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/395ca9815cf90217478f6623a5ca18834ba729bb.jpeg) ---
**Author:** ![Janis\_Balodis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/janis_balodis/32/81993_2.png) [@Janis\_Balodis](https://community.glideapps.com/u/Janis_Balodis)\ **Post date:** [May 6, 2024, 10:56pm UTC](https://community.glideapps.com/t/duplicate-records/73130/8 "2024-05-06T22:56:21Z")
Ups, sorry, you are right! Now it worked. Thanks, Jeff, it is resolved now my issue. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 13, 2024, 10:56pm UTC](https://community.glideapps.com/t/duplicate-records/73130/9 "2024-05-13T22:56:48Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.