Adding data to fields when users create new records is a great way to make data entry easier. In this video, learn how to set auto-enter options.
- Developers will often design a database so that … some fields are automatically populated with default data … when a user creates a new record in the database. … which is where we can set these up, is only available … you'll notice that the Options button is grayed out. … All I have to do is hit Create in order for that Options … to be available to us. … that you're presented with is something called Auto-Enter. … FileMaker allows developers to choose from various different … options to automatically populate contents or … when a record is created. … And you'll find that some of the default fields … that were created for us are great examples of these. … in FileMaker Pro, you'll understand how important … a PrimaryKey Field is. … If we click on the Options on our PrimaryKey Field … a new record is created. … That's one methodology for insuring that every record … in our database has a unique value in it, … and that's the role of a PrimaryKey Field. … it will automatically increment a new value in this field. …
Author
Released
5/22/2019- What is a database?
- Getting to know the FileMaker interface
- Using starter apps
- Creating tables
- Defining fields
- Using container fields
- Creating, editing, and deleting records
- Importing and exporting data
- Building layouts
- Applying themes to layouts
- Searching for data
- Sorting data
- Creating reports
- Performing calculations with functions
- Creating scripts
- Using new features in FileMaker 18
Skill Level Beginner
Duration
Views
Related Courses
-
Learning Relational Databases
with Adam Wilbert2h 43m Beginner -
FileMaker: Relational Database Design
with Cris Ippolite2h 39m Intermediate -
Learning FileMaker Go 16
with Cris Ippolite1h 16m Beginner
-
Introduction
-
Touring the Create window5m 35s
-
1. Getting Started
-
What is a database?3m 3s
-
How FileMaker works6m 9s
-
Essential preferences4m 30s
-
-
2. FileMaker App Creation Essentials
-
Add-on tables5m 32s
-
3. Creating Tables
-
4. Working with Fields
-
Defining fields5m 27s
-
Adding fields to layouts3m 51s
-
Field options: Validation4m 29s
-
5. Working with Container Fields
-
6. Working with Records
-
7. Importing/Exporting
-
Exporting data4m 9s
-
Importing data8m 53s
-
-
8. Creating Layouts
-
Introducing layouts3m 59s
-
-
9. Working with Layouts
-
Understanding layout parts5m 16s
-
The Inspector pane1m 27s
-
-
10. Formatting Layout Objects
-
Grouping layout objects1m 38s
-
Understanding themes4m 49s
-
Applying screen stencils5m 39s
-
Popovers in your layouts4m 46s
-
Setting the tab order4m 19s
-
-
11. Finding Data
-
New requests in Find mode3m 23s
-
Search operators3m 46s
-
12. Sorting Data
-
Sorting with single criteria3m 52s
-
Sorting using buttons4m 3s
-
-
13. Value Lists
-
14. Printing
-
15. Reports
-
16. Calculation Essentials
-
Number functions3m 55s
-
Date and time functions4m 37s
-
Analytic text functions2m 59s
-
17. Script Essentials
-
Touring the Script Workspace2m 35s
-
18. New Features in FileMaker 18
-
Recursion in calculations8m 29s
-
Conclusion
-
Next steps59s
-
- 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: Field options: Auto-enter