Filemaker Pro 9 (102) Flashcards

1
Q

This set entered on 7-26-14. 7-26-14-3.

  1. The RESULT of a calc has a TYPE. What is a calc type?
A

The TYPE can be any of the standard FIELD TYPES, such as TEXT, NUMBER, DATE, TIMESTAMP, or CONTAINER. The type of the calc is chosen at the bottom of the SPECIFY CALCULATION window.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  1. When you REFERENCE a FIELD in a calculation, FM takes the data stored in the field and:
A

uses its value when it determines the calculation’s result.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  1. Say your calc is:
    First Name & “ “ & Last Name.
    When FileMaker EVALUATES the calc, it replaces:
A

the First Name and Last Name field name with the person’s first and last names FROM A GIVEN RECORD.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  1. When a VALUE is going to be the same on every record, you should use a:
A

CONSTANT, and you simply include it in your calculation. SALES TAX is one of the most common constants.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q
  1. When you use a calculation, you are asking FileMaker to do something with your fields, constants, and operators and come up with a result. This is called:
A

EVALUATING THE CALCULATION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q
  1. You can also use a constant to have FileMaker plunk some text in with your results. If you want a TEXT VALUE instead of a number, you:
A

put it in QUOTES:

Age & “ years old”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q
  1. Everything within the quote marks is:
A

a TEXT CONSTANT, aka a STRING, as in “string of characters”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
  1. Why are QUOTE MARKS important?
A

Suppose you have a field called First Name, and this calc: “this is my First Name”. The result of this calc is ALWAYS “This is my First Name”, as FileMaker makes no connection between the First Name field and the words “First Name”, BECAUSE THE TEXT IS IN QUOTE MARKS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q
  1. What if the calc you enter is: “This is” my First Name ?
A

FileMaker will show a message that says “The specified field could not be found.” When you try to click out of the Manage Database window, FM will highlight the words “my First Name” to tell you which part of the calculation is wrong.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
  1. How is the correct calc written?
A

“This is my “ & First Name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly