Tick checkbox based on a matching value in another table

[Tamas_Mahner]

Hello (again),

I am looking for a simple solution for a formula which check a checkbox in Table A when in Table B there is a matching value.

In both tables there is a column with unique numbers and in case they match I would like that in Table A the checkbox is checked, if not the cehckbox should stay unchecked.

I reached half success, I managed to create a formula which checks the checkbox in case there is the same unique number in Table B. But when there is none, I only have an error message I
don’t understand why.

The formula in Table A Checkbox column is this:
If(Filter([Table B].[Unique code],CurrentValue.ToText()=thisRow.[Unique code].ToText()),true,“false”)
But when there is no match this is the result:

I don’t understand why does it say that it isn’t a value but a table.
Here is the doc itself with editing permission:

Can someone point in the right direction to me?

Thanks a lot!
Tamas

[Christiaan_Huizer]

hi @Tamas_Mahner ,

see below

A more general advice is to improve your data architecture, the freedom Coda offers leads many users in the wrong directions.

Anyway, my contribution is asking for a ‘is not blank’

cheers, christiaan

[Tamas_Mahner]

As always!

Thank you very much, it is a big support for us!

Actually I was trying to use Contains but then I did not figure out the .isnotblank part. To be honest I still don’t understand how does it work. I understand the first part, but I don’t understand how does it make it work if you add .isnotblank parameter??

Also I am not sure I understand what do you mean exactly by improving the data architecture. Can you give me a simple example?

Thanks a lot!

[Christiaan_Huizer]

hi @Tamas_Mahner

the IsNotBlank() function outputs true or false, so if the filter has no outcome, is blank, then false and if not blank (there is a match) it is true. This pattern is often applied in the disable part of a relation.

about the data architecture, I’d like to advice relations instead of select items and second the display column (holding the object, meaning all the references to other columns and to itself) is best a unique value.

anyway I have to keep it short, questions like this are also interesting for many others who other ways might end up with an If statement

cheers, christiaan