# How do I detect a data is not existed in a child row?

**URL:** <https://community.glideapps.com/t/how-do-i-detect-a-data-is-not-existed-in-a-child-row/43101>\
**Category:** Ask for Help\
**Created:** [June 15, 2022, 2:29pm UTC](https://community.glideapps.com/t/how-do-i-detect-a-data-is-not-existed-in-a-child-row/43101 "2022-06-15T14:29:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [June 15, 2022, 2:29pm UTC](https://community.glideapps.com/t/how-do-i-detect-a-data-is-not-existed-in-a-child-row/43101/1 "2022-06-15T14:29:37Z")

</div>

So, I have this table:

- Syirkah
- User
- Syirkah User obviously consisting of rowid syirkah + rowid user

And I have this button:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/88d874f178eaf36f06c1f9553c7fb6207d4d8a84.jpeg)

This button should only be visible if current User is not there in Syirkah User table… I kinda stuck since like ever in this step.

Any suggestion?

In this screen I am in detail of Syirkah: so rowid syirkah is available in screen

Thank you in advance!

---

<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:** [June 15, 2022, 2:55pm UTC](https://community.glideapps.com/t/how-do-i-detect-a-data-is-not-existed-in-a-child-row/43101/2 "2022-06-15T14:55:42Z")

</div>

Create a relation from the User table to the Syirkah User table. Add a visibility condition so that the button only shows up when User Profile \> Relation is not empty.

---

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [June 15, 2022, 8:26pm UTC](https://community.glideapps.com/t/how-do-i-detect-a-data-is-not-existed-in-a-child-row/43101/3 "2022-06-15T20:26:22Z")

</div>

Ow yeah! Let me check that! Thanks!

---

<div class="post-metadata">

**Author:** ![remoteworker.id](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/remoteworker.id/32/36396_2.png) [@remoteworker.id](https://community.glideapps.com/u/remoteworker.id)\
**Post date:** [June 16, 2022, 12:07am UTC](https://community.glideapps.com/t/how-do-i-detect-a-data-is-not-existed-in-a-child-row/43101/4 "2022-06-16T00:07:24Z")

</div>

Okay, that works! Thank you so much!

But what if I want to also check whether THIS user support THIS syirkah?  
So, it requires two column? From user profile I only able to create relation using only one column … right? Or … is it?

---

<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:** [June 16, 2022, 12:13am UTC](https://community.glideapps.com/t/how-do-i-detect-a-data-is-not-existed-in-a-child-row/43101/5 "2022-06-16T00:13:00Z")

</div>

You’d need to create a conditional relation.

Something like this:

[https://community.glideapps.com/t/experts-top-tips/39730/2?u=robert\_petitto](https://community.glideapps.com/t/experts-top-tips/39730/2)

---

<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:** [June 16, 2022, 12:18am UTC](https://community.glideapps.com/t/how-do-i-detect-a-data-is-not-existed-in-a-child-row/43101/6 "2022-06-16T00:18:03Z")

</div>

Copying the video here since that thread is only visible for Certified Experts.