# Update instead of Insert on Duplicate

**URL:** https://community.glideapps.com/t/update-instead-of-insert-on-duplicate/10811
**Category:** Ask for Help
**Created:** [June 13, 2020, 6:09pm UTC](https://community.glideapps.com/t/update-instead-of-insert-on-duplicate/10811 "2020-06-13T18:09:14Z")
**Posts on this page:** 1
**Showing post:** 4

<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: [May 9, 2023, 1:05pm UTC](https://community.glideapps.com/t/update-instead-of-insert-on-duplicate/10811/4 "2023-05-09T13:05:25Z")

</div>

Create an if-then-else column in your User Profiles table:

- If name is empty, then null
- If phone is empty, then null
- etc…
- Else true

And then only allow them to leave that screen when that column is checked.

---

_[View the full topic](https://community.glideapps.com/t/update-instead-of-insert-on-duplicate/10811)._