From the course: FileMaker Pro 13 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating and applying dynamic value lists - FileMaker Pro Tutorial
From the course: FileMaker Pro 13 Essential Training
Creating and applying dynamic value lists
Understanding the use of value lists in your database allows you a really strong tool to be able to enforce data consistency and the convenience of data entry for your users. And there's a couple different kinds of value lists. First of which are static value lists, which contain a preset range of values that you the developer go in and enter. And there's another kind that's called a dynamic value list. And a dynamic value list is created on the fly, based on data that's already stored inside the field. And the way these values list work, is that they're automatically added to an inventory of values inside of a field that's called an index. I'm going to show you how we do that, here in this movie. So first of all, every field in your database has what's called an Index. And if you click inside of a field and do, for example, Cmd+I, or Ctrl+I, depending on what version you're on, Mac or Windows, then you can see this interesting little window called View Index. Doesn't have a lot of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
Using guides and arranging, aligning, grouping and locking layout objects10m
-
Applying Screen Stencils3m 25s
-
Placing and formatting graphics in layouts5m 34s
-
Applying gradients2m 19s
-
Formatting fields and applying field attributes6m 24s
-
Understanding states5m 9s
-
Setting field behaviors3m 23s
-
Using the Tab Control feature9m 6s
-
Using the Slide Control feature6m 42s
-
Using the popover feature7m 40s
-
Setting the tab order4m 29s
-
Learning how to hide layout objects conditionally6m 4s
-
-
-
Introducing scripts and script steps2m 48s
-
Assigning script steps to buttons4m 50s
-
Understanding the Scriptmaker dialog window7m 54s
-
Creating multiline scripts10m 23s
-
Adding find criteria to a script8m 19s
-
Using the New Window script step7m 36s
-
Understanding the If script step5m 42s
-
Using script parameters5m 7s
-
Reviewing the Send Mail script option5m 17s
-