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

Ask for Help
1

So, I have this table:

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

And I have this button:

image
image1170×614 93.8 KB

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!

2

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.

3

Ow yeah! Let me check that! Thanks!

4

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?

5

You’d need to create a conditional relation.

Something like this:

https://community.glideapps.com/t/experts-top-tips/39730/2?u=robert_petitto

1 Like
6

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