TableView Filtering

[Douglas Stransky]

Good Morning,

I have three forms.   

1)  Form1 with Data including a Smart Multirow field

2)  Form2 with Smart Multirow fields ((Date Completed, User and text field for notes)

3) Form3 for a report (including a report date)

I like to have a table view that filters by the date in the Smart multirow and some of the information from Form 1

What is the best way to do this?   

Thanks!

Doug

[Alex Medved _ConfiForms_]

Interesting question @Douglas Stransky !

I saw it yesterday and needed to sleep with it, to get a solution :)

Let me know if this would be too abstract, but assuming your smart multi row field is named smartField and the date field you want to filter on is named "DateCompleted"

And you want to take all the records that have a "DateCompleted" before the 31.12.2025

This is the expression I came up with :-) To put in a TableView (or any other view) over the Form1

smartField:[entry._func.queryAndSet(form2:@self;DateCompleted:<[date20251231];id).split(,).join( OR smartField:)]

picking up the matching records from the Form2 and then checking against the smart multi row field for a match