Filter out certain columns within Ref_Row function


A view to display relevant / other entries per client has been automatically generated. I am attempting to easily view if the client has had their “Daily-Check” per the nurse on-site. This works as is for now, but you have to scroll sideways on each client to view their daily checks.

Is there a way to only display certain columns in a Ref_Row function?


Yes, you can select only the desired columns. In UX → Views option. You will have an inline view ( meaning summary view) that displays records related to the LIST column with REF_ROWS() expression.

The view will be typically named as “The Table Name_Inline”

Please select the desired columns in that view’s column order.

The example below shows an inline view for the table “Order Details”, equivalent to “Kids Med Pass …” table in your case.