As a trainer I am commonly asked what does the Let function do?…The Let function is something that you'll run into if you're looking around in…databases that have been created by someone else, or even starter solutions or…in other training materials.…And the answer really is that it doesn't do anything. The Let function is a…unique function that actually doesn't add any additional programming features…to your calculations.…But rather creates an environment within the calculation, or the calculation…dialog window, where you can declare variables and those variables can be used…elsewhere within the calculation itself.…
Now what's the purpose of something like that?…Well, if we look at Let function, we can see that all the Let function is …is that inside the brackets you see there, you will declare these variables and…then you just run a calculation formula.…So whatever calculation formula you write in the second parameter…calculation, it'll run that.…But the nice thing about it is, if you look at this example here, I can say I'm…
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 Let logical function