Check if table exist through expressions

[#1]

Hi all,

I would like to put a condition to display an object only if a certain table is created in my ERD.

what kind of expression should I use in the layout tab of the object properties?

thanks,

Boris

[#2 · Accepted solution]

Hi Boris,

You can use the system field $Table to accomplish that, in the layout conditional field add the below to check if a table labeled Production exists or not:

SubStringCount(';' & Concat(DISTINCT $Table, ';') & ';', ';Production;')=1

Hope this helps.

[#3]

I get an expression error under the $.

[#4]

You can enclose the system field between brackets: [$Table].

But it will still work anyways

[#5]

Boris,

Could you mark the answer as correct if it was the case.

This will also help others having same request.

Thanks.