Template
Ref List Filter
How to further filter a ref list ("reverse ref") column
Industry:
n/a
Function:
Human Resources
This app shows how to filter an existing list of refs. Typically this is used in apps that have two tables linked by a Ref column and its "reverse-ref" virtual column. This app shows how to further filter the reverse-ref using a SELECT() function.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
Look at the Column Structure of the Applicants table. It has three virtual columns: (a) All Feedback --- this is the standard "reverse ref" column and is a list of refs to all Feedback entries for this Applicant, (b) Number_For --- this shows you how to further filter All Feedback to just get those that were positive, (c) Number_Against -- this similarly shows how to filter All Feedback to show those that were negative.
Here is the expression pattern used:
COUNT(SELECT([All Feedback][Interviewer], [Recommend Hire?] = true))
Note that this is almost identical to a standard SELECT expression. However, a standard SELECT expression is of the form SELECT(TableName[ColumnName], {filter}). In this case, instead of TableName, we provide the value of the column [All Feedback] that is a list of refs.
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...