Create report from notes by date

Notes on the new SeedCode Complete template for FileMaker 13
Posts: 72
Joined: Mon Feb 04, 2013 11:54 am
PostPosted: Fri Nov 10, 2017 5:30 pm
Which file can I query to generate a report of contact notes? Also, what syntax should be used to generate the report by date and active contacts only?

SeedCode Staff
SeedCode Staff
Posts: 2760
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Nov 10, 2017 5:46 pm
Hi Ken,

Notes are in the "Notes" table in the file "SeedCodeModel". As for the report, I'd just make a new subsummary report layout in the SeedCodeComplete file, maybe basing it on one of the existing reports like "Sales By Item Print". Base this layout on the "ContactNotes" table occurrence and summarize by contact or date. Then you can script a find for active contacts and use the GoToRelatedRecord script step with the found set option to get all the notes records for the found set of (active) contacts. Sort by contact, then date, and you're off and running.

Hope that helps.

Notes.png (549.82 KiB) Viewed 7605 times
John Sindelar
Posts: 72
Joined: Mon Feb 04, 2013 11:54 am
PostPosted: Mon Nov 20, 2017 5:48 pm
Thanks for the info John. I was able to retrieve client notes and sort properly. Using the Sales by Item and Sales by Item Print worked extremely well. You guys have done an excellent job documenting and keeping things well defined and symmetrical. I easily added the new client notes procedure to the reports layout by following the layout design.

Many thanks.
SeedCode Staff
SeedCode Staff
Posts: 352
Joined: Tue Nov 08, 2016 1:54 pm
PostPosted: Tue Nov 21, 2017 9:09 am
Hi Ken,

That's great to hear that you were able to get your client notes on the reports layout!



Return to SeedCode Complete 13

Who is online

Users browsing this forum: No registered users and 1 guest

Follow us: