Filter ref

[Cannone_Cannone]

Hi everyone
I have a “MAINTENANCE” table with a column named “N.S” that refers to a “GSE” table.
In the table “GSE” .- (column “N.S” numbers), (column “STATE” inoperative).
In the “MAINTENANCE” table, how can I display only the numbers in the “N.S” column that are inoperative
In the “GSE” table?
thank you

[MultiTech]

It might be helpful to create a slice of “Inoperative” records from the GSE table.

I would make a slice to hold the Inoperative records, then use the slice to restrict the options for your reference by using a Valid If formula like this:

Inoperative_GSE_Slice[Tables_Key]

You can read more about slices here:

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

[Cannone_Cannone]

Hello
thanks but I have already created an inoperative slice.
in the maintenace form screen when I have to assign in the N.S column all the operative ones also appear

[Steve · Accepted solution]

For the Valid If expression for the N.S column of the MAINTENANCE table, try:

SORT(
  SELECT(
    GSE[N.S],
    AND(
      ISNOTBLANK([STATE]),
      ([STATE] = "inoperative")
    ),
    TRUE
  )
)

[Cannone_Cannone]

Perfect!!!
thanks a lot!!!