Having a little trouble understanding grouping and criteria when using Views.
I can’t find any examples either of how to use groupings and criteria when using views, and I’m really unclear as to what can be acheived with join table views.I have 2 tables
table 1 shows users
table 2 lists their appointmentstable 2 contains the userid from table 1 for each record.I’d like to get a joined view of table 1 & 2 with the records grouped by user, so there’s one row for each user, and the appointment column would be an array of the appointment dates/times
cab that be done? if so how?
Can anyone point me in the right direction of a tutorial for views?
You may create a summary report, see the tutorial on Summary Report in the help file. (v2020)
ok, i guess i have to get around to upgrading from 2019 to 2020.
I got a report working in 2019 which does mostly what I need, but I can’d add filters to it. 2020 supports that I think