Create grouped table with a list of files related to the groups

Help
1

What I’m trying to do

I don’t know code whatsoever, so appreciate the help here everyone! I’m trying to create a table that is grouped by Company. For each Company, I’d like to show the last 10 meetings that have a meeting type of Client Meeting. If there are no Client Meetings for a Company, I’d like to leave them out of the table. Any help would be much appreciated!

Things I have tried

I can get the list to almost pull how I want it to, but I keep getting stuck every time I try to add the grouping. Not sure why - so again, thanks for the help!

2

Please show what you’ve got so far, to help us understand where you’re at and how your data structure looks like.

Also remember that when you add GROUP BY to a dataview query ask the fields like myField are now grouped together as a list into rows.myField. The value of the expression you used to group by is stored in key.

3

Thanks for the quick reply… I actually shifted my approach a little - I’d like to have a table that calls out Current Clients, Prospects, and Past Clients. Right now I have them pulling in separate lists, but ideally I’d like just a table with three columns (and column headers) to save some scrolling. Any direction would be great

LIST 
FROM "Companies"
WHERE company-type = "Current Client"
SORT file.name ASC
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.