Hello, We have a questions about our ref. In ...

[Reynald_SAINT_M]

Hello, We have a questions about our ref. In our Database for the App we have a Ref Sheet (Model.DB on the pic) with all the product that we have in our factory and we want to hide the ref on our app for the product that we don’t made now. Has you can see we have a column “Actif” that said if the product is Active (if “Oui”) or not. It exist an app formula or a way to do that?

thanks a lot and have a nice day!

[Levent_KULACOGL]

@Reynald_SAINT_MAXENT

In your ref column, use below Valid_if expression:

=SELECT(TableName[ColumnName],AND(ISNOTBLANK([Status]), [Status]=“Active”))

[Reynald_SAINT_M]

In our ref column of the ref table or on all the table who use the ref?

[Levent_KULACOGL]

On your tables’ columns that are ref’d to your table. Basically, if your structure is;

[TableA] = {Col1, Col2, Col3} [TableB] = {Col1, Col2={TableA[Col2]}, Col3}

You shall construct the formula in TableB[Col2] which is a child table of TableA (ref table)

[Reynald_SAINT_M]

Thanks a lot! It Works.

[Levent_KULACOGL]

@Reynald_SAINT_MAXENT you’re welcome