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

(Reynald SAINT MAXENT -ESSENSOLE-) #1

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 KULAÇOĞLU) #2

@Reynald_SAINT_MAXENT

In your ref column, use below Valid_if expression:

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

(Reynald SAINT MAXENT -ESSENSOLE-) #3

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

(Levent KULAÇOĞLU) #4

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 MAXENT -ESSENSOLE-) #5

Thanks a lot! It Works.

(Levent KULAÇOĞLU) #6

@Reynald_SAINT_MAXENT you’re welcome