Hi there,
I’m having a row called “Song name” with fields like " Song name 1", “Song name 2” and so on. Every time I want to add new fields in that row I want to check if those entries already exist. And if those already exists to display a notification like “This was already shared by someone else”.
Is there any function that allows me to do this?
Not exactly clear on what you want to do, but you can probably use component visibility:
@Darren_Murphy
I want to check in tables if certain rows fields are matching.
For example, let’s say I have a row called “Song name”, which contains these fields “Song name 1” and “Song name 2” and so on…
When I add to add a new song put the same song name as any of the above, to not allow me to do this.
Does this make any sense?
Ah, I see. So you want to check for duplicates.
To do that, you need to use a Custom Form.
@Darren_Murphy
I think it might be something along those lines, but you kind of lost me there. 
Well, with a Glide native form there is no way to check for duplicates, because data isn’t added to the table until the form is submitted, and by that time it is too late.
A custom form is different. A custom form is built on a standard details screen, and the user inputs are collected in User Specific Columns, and then when the user submits the form these values are taken and used to add a new row.
And because you have the values in the table before the form is submitted, you can use them to check for duplicates. The way to do that is to create a relation from the User Specific Column to the corresponding column in the target table, and if that relation is not empty, then you have a duplicate. And so at that point, you can warn the user and stop them from submitting the form.
Thanks, @Darren_Murphy, this is much clearer.
Now I need to hrie a Glide expert to help me with this one as I’m not super familiar with how everything works in Glide so far.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.