"Type" is "Ref" how to filter data when opening wi...

11166 · 05-17-2020 09:35 PM

Ask the teacher
As attachment
When I open a window in the “NAME” field and select data entry
, Can hope that the data displayed in the window can be filtered first according to the input data in the [AREA] field above!
What should I do?
Are there examples?
Thank you

hru

I am no teacher, so I can only share you below link:

https://www.appsheet.com/samples/How-to-create-a-dropdown-menu-with-values-that-depend-on-earlier-ch...

Steve

Try as the Valid If for the NAME column:

IFS(
  ISNOTBLANK([AREA]),
    FILTER(
      "Table with Names",
      ([_THISROW].[AREA] = [Area of Name])
    )
)

Replace Table with Names with the name of the table referenced by the NAME column, and Area of Name with the name of the column in that same table that identifies the area. Note that the above assumes that the Area of Name column is assumed to be of the same column type as the AREA column. If not, you will have to adjust the comparison accordingly.

"Type" is "Ref" how to filter data when opening window