# No duplicate row

**URL:** https://community.glideapps.com/t/no-duplicate-row/42765
**Category:** Ask for Help
**Created:** [June 6, 2022, 12:20pm UTC](https://community.glideapps.com/t/no-duplicate-row/42765 "2022-06-06T12:20:05Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Parabolik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/parabolik/32/46026_2.png) [@Parabolik](https://community.glideapps.com/u/Parabolik)
#### Post date: [June 6, 2022, 12:20pm UTC](https://community.glideapps.com/t/no-duplicate-row/42765/1 "2022-06-06T12:20:05Z")

</div>

Hello to all

I have made a list of prospects and I want to invite some prospects to access my application

I have a table A (Annuaire) and a table B (acces)  
Table A and table B contain people

I display the list of people in table A  
I select a person to display his record with details (name, email, tel)  
On this record I click on a button that should copy the line from table A (name, email, tel) to table B and send an email and SMS to this person to notify him.

It works but I have two problems  
1/ In the same scenario I can’t send an email and then an sms - it sends the first one but it doesn’t follow on the second one (it seems that the scenario is stopped with this type of action) - so I made two buttons SMS and EMAIL but it’s not the way I wanted it to work

2/ If my prospect is already in table B (same email address) I don’t execute anything to avoid notifying the person several times and especially to avoid creating a duplicate in table B

Thank you for helping me to get around these two problems.  
Ludo  
 ![Capture2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0cc37a18e03b3496b6740016378ed9fd5ab7dc61.jpeg)  
 ![Capture1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3d64d95892786d681c0e25089358f0216220eb35.jpeg)

---

<div class="post-metadata">

### Author: ![Parabolik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/parabolik/32/46026_2.png) [@Parabolik](https://community.glideapps.com/u/Parabolik)
#### Post date: [June 6, 2022, 12:56pm UTC](https://community.glideapps.com/t/no-duplicate-row/42765/2 "2022-06-06T12:56:44Z")

</div>

for the duplicate problem finally I found easily

in table A I added a relationship column (email with table B)

if this value is not empty (so it means that this email already exists in table B) I simply hide the button !
