While conditional functions are among the most useful functions available to…FileMaker Pro developers, another set of logical functions perform specific…tests and return a Boolean result.…These functions include IsEmpty and IsValid.…Boolean results simply mean you will either get a true or a false answer to your…question, so to speak.…With conditional functions you can determine what your test or question will be,…and also what your response will be if true. That's the case in the If function,…as well as the Case function.…
With Boolean, in the case of "IsEmpty" or "IsValid" you're simply a going to get…a true or a false answer to your "question."…So for example, IsEmpty tests whether or not the data passed to it is empty.…If you pass it a blank string, it returns of a 1, or a true statement, otherwise…it returns a 0 or a false statement.…Most often this function is used to determine whether not specific fields…have been left empty.…So IsEmpty is commonly used as a test within a conditional function.…
Author
Released
3/19/2013- Managing access to your database
- Parsing text with calculation functions
- Using calculations in field validation and auto enter options
- Creating nested subsummary and crosstab reports
- Creating user-driven and multi-criteria relationships
- Working with intermediate script techniques
- Extending Web Viewer using HTML5 and data URLs
- Sharing databases on a network using FileMaker Server
- Publishing your databases to the web using the Instant Web Publishing or PHP
Skill Level Advanced
Duration
Views
Related Courses
-
FileMaker Pro 12 Essential Training
with Cris Ippolite10h 28m Beginner -
Learning FileMaker Go
with Cris Ippolite1h 15m Intermediate
-
Introduction
-
Welcome46s
-
-
1. Managing Access to Your Database
-
Creating accounts6m 25s
-
Customizing privilege sets9m 30s
-
Applying extended privileges4m 45s
-
-
2. Calculations: Extending Text Functions
-
Parsing lists of values9m 55s
-
3. Calculations: Logical Functions
-
4. Other Uses of the Calculation Dialog
-
5. Calculations: Working with Aggregate Functions
-
6. Advanced Reporting Options
-
Reviewing subsummary reports6m 10s
-
Creating a crosstab report14m 32s
-
-
7. Extending FileMaker Relationships
-
8. Scripting for Developers
-
The Set Field script step5m 28s
-
Working with script variables10m 31s
-
Setting script parameters3m 12s
-
9. Extending Web Viewer
-
Using HTML5 in the Web Viewer10m 27s
-
10. Sharing Your Databases on the Network
-
Best practices5m 37s
-
Configuring FileMaker Server13m 52s
-
Scheduling backups7m 23s
-
11. Web Publishing: PHP and Instant Web Publishing
-
Preparing your files for IWP6m 24s
-
Touring the IWP interface6m 51s
-
Design considerations in IWP8m 48s
-
Scripting in IWP8m 37s
-
Setting up your file for PHP6m 25s
-
Conclusion
-
Goodbye54s
-
- 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: Using the IsEmpty logical function