difficulty with field validation

[germanoalves]

Helo!

I'm having a hard time using unique content validation (isuniquevalue).

I have a field of type databasejoin that lists data from one table to be used in another form "A".

I need to check if a record already exists registered in the table of the form "A", and if so, the databasejoin no longer displays this item.

I tried it with the following code:

if ('{Full Element Name}' == 1)
{
return false;
}



But I was not successful. =(

How could I set up this condition?


Thank you all!

 

[juuser]

To hide databasejoin element options already existing in database, you need to add "Data - where" clause in databasejoin element settings, something like:

WHERE {thistable}.id NOT IN (SELECT id FROM your_dbjoinelement_table)

 

[germanoalves]

Perfect! Worked perfectly! Thanks !