Filemaker Pro 9 (107)

Question 1

1. This set entered on 7-27-14
2. 26.14.8
3. What are the TEXT FUNCTIONS for?

Answer 1

They let you compare text, convert them into other types (like numbers), split them, count the number of letters, words, or lines, change case, or replace parts of them with new text values.

Question 2

2. What are the TEXT FORMATTING Functions?

Answer 2

they let you adjust the font, size, style, and color of all or part of a text value.

Question 3

3. What are the NUMBER Functions?

Answer 3

They do EVERYTHING with numbers.

Question 4

4. What are the DATE Functions?

Answer 4

They let you create date values without worrying about the computer’s date settings, pick date values apart (i.e., get just a Month from a date), convert Day and Month numbers into proper names, and work with weeks and fiscal years.

Question 5

5. What are the TIME Functions?

Answer 5

They create time values form hours, minutes, and seconds. Useful when trying to find out how long something took.

Question 6

6. What are the TIMESTAMP Functions?

Answer 6

There is ONLY ONE Timestamp function: it lets you build a timestamp value from a separate date and time.

Question 7

7. What are the AGGREGATE Functions?

Answer 7

They calculate STATISTICS such as Average, Variance, and Standard Deviation, but can also count things, sum things, and find Minimums and Maximums. By definition, AGGREGATE FUNCTIONS gather up multiple values and find results based on the group as a whole.

Question 8

8. What is an example of an AGGREGATE Function?

Answer 8

Sum ( Line Items::Extended Price ). This function would AGGREGATE the field’s value from EVERY RELATED RECORD, the Invoice total, in this case.

Question 9

9. What are the SUMMARY Functions?

Answer 9

There’s only ONE Summary Function: GetSummary. Its purpose is to let you use the value of a Summary Field in your calcs. This Function is outdated, though, and not really necessary.