This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi Steve,You helped me with this topic a while ago.Now how can I do the
same with another table? That it be possible to do the two validations
at the same column.That is, it is not allowed to enter a code that
exists in another tableThanks.
Hi @Steve I have a similar case. How can I concatenate information from
related tables into a virtual column? For example here I want to
concatenate two dates from the REGISTRATION table. Thanks! USER ID NAME
PHONE VIRTUAL_COLUMN (CONCATENATED DATES)...
Steve, Thanks a lot! it’s working perfectly. I just added a parenthesis.
I share the result: OR( ("NO CODE" = [CODE]), ISBLANK( FILTER( "USER",
AND( ([CODE] = [_THISROW].[CODE]), ([_ROWNUMBER] <>
[_THISROW].[_ROWNUMBER]) ) ) ) )