Filemaker Pro 9 (108)

Question 1

1. This set entered on 7-26-14
2. 26.14.9
3. What are the REPEATING Functions?

Answer 1

They mostly work with REPEATING FIELDS, and since those are outdated, so are most of these functions.

Question 2

2. What are the FINANCIAL FUNCTIONS?

Answer 2

Present Value, Future Value, etc

Question 3

3. What are the TRIGONOMETRIC FUNCTIONS?

Answer 3

Sine, Cosine, Tangent, etc.

Question 4

4. What are the LOGICAL FUNCTIONS?

Answer 4

THIS IS A POWERFUL GROUPING. They can MAKE DECISIONS based on CALCULATED VALUES (i.e., if the due date is more than 6 months ago, double the balance due). Some can evaluate other calcs inside your calcs, some figure out if fields are empty or contain invalid data, or perform lookups inside calcs. SEE CH 11 for details on these.

Question 5

5. What are the GET FUNCTIONS?

Answer 5

They pull info about the computer, user, db, or FileMaker Pro itself. You can find the layout’s name, network address, current user’s name, etc. This is the LARGEST GROUP OF FUNCTIONS.

Question 6

6. What are the DESIGN FUNCTIONS?

Answer 6

They tell you about YOUR DATABASE’S STRUCTURE, such as a list of tables, layouts, or value lists. ValueLIstItems gives you a list of the values in a Value List.

Question 7

7. What are the CUSTOM FUNCTIONS?

Answer 7

See Ch 12.

Question 8

8. What are the EXTERNAL FUNCTIONS?

Answer 8

Applicable only on Plug-Ins (mini-programs) or FileMaker Server.