- Adding sub-summary parts to a layout…can make the data on the layout be easier…for your users to read and interpret.…Much like the example file here,…where I've got a bunch of different invoices…that are broken down by the salesperson…who's responsible for the sale.…Rather than just looking at a list of…a bunch of invoices, with a column…that said the salesperson,…instead we can group by them,…and we can actually find some interesting information…out here too, where we're summarizing…the total sales for salesman, Boo.…Here's all their accounts.…
Brady, has a whole 'nother.…Brinkley, so on and so on and so on.…But FileMaker also has some features…that can make data visualization very appealing,…specifically this can be achieved through…something called the Charting Tool.…So, what we're gonna do is add a chart…that basically says the same information…but tells it in a visually appealing way.…And we'll add a chart to the layout,…in Layout Mode, but first I need…to make some space for it.…I'm gonna put the chart in the Header here,…
Author
Released
5/12/2015- Comparing flat vs. relational databases
- Creating databases from starter solutions
- Determining what tables you need
- Understanding relationship types
- Defining key fields and creating relationships between tables
- Creating and working with fields, including container fields
- Creating, duplicating, editing, and deleting records
- Importing and exporting data
- Working with layout themes
- Using layout parts and tools
- Formatting layout objects
- Finding and sorting data
- Creating value lists
- Printing and saving
- Building reports, including subsummary reports and quick charts
- Using the Calculation dialog
- Creating and triggering scripts in the Script workspace
- Working with script triggers
Skill Level Beginner
Duration
Views
Related Courses
-
Advanced FileMaker Pro 12
with Cris Ippolite7h 33m Advanced -
Learning FileMaker Go
with Cris Ippolite1h 15m Intermediate
-
Introduction
-
Welcome57s
-
Touring the Launch Center6m 44s
-
Using the exercise files1m 25s
-
-
1. Getting Started
-
What is a database?2m 35s
-
Exploring the interface5m 35s
-
-
2. Solution Creation Essentials
-
3. Creating Tables
-
4. Creating Relationships
-
Understanding key fields5m 27s
-
5. Working with Fields
-
Understanding field types7m 50s
-
Defining fields8m 23s
-
Adding fields to layouts5m 33s
-
6. Working with Container Fields
-
7. Working with Records
-
Editing and locking records3m 33s
-
8. Importing and Exporting
-
Importing data6m 25s
-
Exporting data4m 17s
-
-
9. Creating Layouts
-
Introducing layouts3m 18s
-
Working with layout themes5m 41s
-
-
10. Working with Layouts
-
Understanding layout parts6m 24s
-
Previewing the Inspector2m 23s
-
11. Formatting Layout Objects
-
Applying themes to layouts6m 35s
-
Applying screen stencils4m 2s
-
Applying gradients2m 43s
-
Understanding states7m 47s
-
Setting field behaviors4m 47s
-
Using the tab control feature12m 38s
-
Setting the tab order4m 9s
-
12. Finding Data
-
13. Sorting Data
-
Sorting with related fields2m 41s
-
Sorting using custom values2m 59s
-
Sorting using buttons4m 4s
-
14. Value Lists
-
15. Printing and Saving
-
Printing merge letters4m 52s
-
Saving as PDF or Excel1m 54s
-
16. Reports
-
Creating subsummary reports9m 35s
-
Adding charts to reports6m 54s
-
17. Calculation Essentials
-
Introducing calculations3m 26s
-
Using number functions6m 57s
-
Using text functions11m 50s
-
Using get functions5m 49s
-
Using logic functions12m 42s
-
-
18. Script Essentials
-
Touring the Script workspace5m 14s
-
Creating multiline scripts7m 56s
-
Using script parameters3m 48s
-
19. Script Triggers
-
Introducing script triggers1m 23s
-
Using object-based triggers9m 18s
-
Using layout-based triggers7m 26s
-
-
Conclusion
-
Goodbye1m 48s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Adding charts to reports