- If you've got existing records…in your solution,…it's actually pretty easy to delete them if you need to.…Maybe a little bit too easy.…I'm gonna show you how to delete records…out of your solution,…and then talk to you about some ways…that you might wanna protect your database…against accidental deletions.…First, just like creating and duplicating records,…you can delete a record…by either going under the Records menu…or I can use one of the buttons in the Status toolbar.…You'll see that when I choose one of these options…I get a message from FileMaker saying,…are you sure you wanna permanently delete…this entire record?…If I hit Cancel,…no deletion will occur,…which is a nice little fail-safe.…
However, if I intend to delete the record,…all I have to do is hit delete,…and now that record is gone.…And it's gone permanently, as well.…There's no undos as you can see here.…You should also be aware that under the Records menu,…there's an option for Delete Records…but there's also an option for Delete All Records,…which is particularly dangerous,…
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: Deleting records and backing up files