The order is a OnObjectEnter b OnObjectModify c OnObjectValidate d OnObjectSave

The order is a onobjectenter b onobjectmodify c

This preview shows page 9 - 12 out of 24 pages.

9. The order is: a. OnObjectEnterb. OnObjectModifyc. OnObjectValidated. OnObjectSavee. OnObjectExit 10. When a chart set up to chart the “Current Found Set” is placed on a top navigation part, you will see data from the first record of each outermost group of the sorted records.
10 4. Working with Calculations 10 – 15 %Identify proper expression syntax, logic, and order of operations.Describe the behavior and use of calculation functions.Describe the behavior and use of custom functions.Preparation resourcesFileMaker Pro Help topics and subtopicsWorking with formulas and functionsFunctions referenceAbout custom functions (FileMaker Pro Advanced)Questions1. In a calculation formula, what is the difference between using the operators “&”, “+”, and “and”?2. A developer built a recursive custom function called “CF_AddDots”:Case ( numOfDots > 0 ;CF_AddDots ( text & “.” ;numOfDots - 1) ;text )What will this function return: CF_AddDots(“FileMaker” ; 3)?3. For the following calculations, write down the result.a. Position ( “Fred Millstone” ; “e” ; 1 ; 2 )b. Round ( 56.32 ; 1 )c. FilterValues ( “Red¶Green¶Blue” ; “White¶Blue¶Red” )4. Given the field Assignees that contains a list of four values, what is the difference between the results for MiddleValues (Assignees ; 2 ; 1) and GetValue (Assignees ; 2)?5. What are some reasons for using a custom function?6. Given this JSON data \$\$json = {\”Person\”:[{\”Age\”:42, “First\”:\”John\”,\”Last\”:\”Smith\”}, {\”Age\”:39,\”First\”:\”Jane\”,\”Last\”:\”Jones\”}]}What is the result of each of these functions?a. JSONFormatElements ( \$\$json )b. JSONListValues ( \$\$json ; “Person” )c. JSONGetElement ( \$\$json ; “Person[1].Last” )
11 Answers 1. Here are the differences: a. “&” concatenates strings together. i. Example: Students::First & “ “ & Students::Last b. The “+” symbol is used to add values together i. Example: 4 + 5 c. The word “and” is used in logical functions i. Example: if ( Get(CurrentDate) > Date ( 6;1;2017) and Students::Gender = “Male”) 2. CF_AddDots( “FileMaker” ; 3 ) will return “FileMaker…” 3. The returned value of each calculation is: a. Position ( “Fred Millstone” ; “e” ; 1 ; 2 ): 14 b. Round ( 56.32 ; 1 ): 56.3 c. FilterValues ( “Red¶Green¶Blue” ; “White¶Blue¶Red” ): “Red¶Blue” 4. The MiddleValues() function includes a carriage return after each value. GetValue () does not include the return character a. MiddleValues (Assignees ; 2; 1 ) = <second value in list>¶ b. GetValue (Assignees ; 2) = <second value in list> 5. A custom function might be created as a place to store often-used logic, such as finding the age of a person based on her birthday or cleaning up a phone number format. Rather than repeating the logic over and over, it is set up once and called wherever needed. Another kind of custom function, recursive functions, can be created. These functions perform complex tasks, such as parsing individual letters of a word into separate lines, and returning the result. This allows a developer to perform the calculation and get the result in one step.

You've reached the end of your free preview.

Want to read all 24 pages?

• Spring '10
• STANLEYBRISTOL