TRA05 - Intermediate - Calculations - Cristoffer Ippolite

Document created by communitymanager on Jul 20, 2018Last modified by RosemaryTietge on Aug 8, 2018
Version 3Show Document
  • View in full screen mode

Cristoffer Ippolite (iSolutions)

Session Description

This session will tour the most used calculation functions and help attendees grasp how to use calculations not only as fields, but as a way to make scripts, layouts and various other aspects of your custom app more dynamic.


  • Please review the content below BEFORE you attend. If the skill level does not fit or if these topics are not of interest to you, PLEASE use your training day pass to attend a session that fits you better. I took a significant amount of extra time to make sure to set these expectations before you get to the room to make sure no one ends up not getting the wrong content.
  • Please make sure to fill out an evaluation form below!


Bonus Offers:



        • Below you see this icon ()...clicking the icon (using your existing account or your trial from above) allows you to see a video on the topic being covered.
        • Clicking on a file name (##_01) will download the sample file used for this section
        • All exercise files have also been distributed to attendees on USB on the day of the session. Same files you see listed here.



1. Calculation Dialog


          • Calculation vs Boolean 01_01
          • Storage option
          • “Evaluate when all empty"
          • Data Viewer
          • Specify context
          • Different Places where you find the Calculation Dialog


2. Number Functions

1:25pm- 1:35pm

3. Date and Time Functions

1:35pm- 1:45pm

          • Extracting data from DATE fields 03_01
          • Constructing Dates from other fields/values


4. Text Functions

1:45pm- 2:30pm

          • Auto-Enter 04_01
          • Field Filtering
          • Parsing data
          • Calculated Replace
          • Calculations in Validation

2:30pm-2:45pm BREAK



5. Container Functions

2:45pm- 2:55pm

6. Aggregate Functions

2:55pm- 3:10pm

          • Aggregating related values 06_01
          • Sum( )
          • Count( )

7. Logic Functions

3:10pm- 3:30pm

          • IF( )  07_01
          • CASE( )
          • LET ( )

8. Get Functions

3:30pm- 3:40pm

          • Get(RecordNumber)  08_01
          • Get(ActiveRecordNumber)
          • Get(TotalFoundCount)
          • Get(SortState)

9. Mobile Functions

3:40pm- 3:55pm

          • GetSensor  09_01
          • Location
          • Region Monitoring 09_02
          • Get(Device)
          • Get(SystemPlatform)
          • Get(NetworkType)

10. Custom Functions

3:55pm- 4:00pm



11. Other Uses of Calculation Dialog (Optional- time permitting)

4:00pm- 4:25pm

          • Calculations to Hide Objects  11_01  
          • Calculations in Conditional Formatting 11_02  
          • Calculations in Tool Tips

12. Closing

4:25pm- 4:30pm





            More Calculations Training Resources:

Download FileMaker Training Series : Calculations

Custom App Academy: Calculations