Filemaker Pro 9 (121)

Question 1

This set entered on 8-3-14
8.3.14.2

1. You have a Customer Layout and an Employees layout. You want to insert a button that will take you to one or the other, without having to insert two buttons. What do you use?

Answer 1

When you insert a button and choose ‘Go to Layout,” you’ll have the option to use “LAYOUT NAME BY CALCULATION or LAYOUT NUMBER BY CALCULATION.

Question 2

2. What function would you use to GO TO LAYOUT NAME BY CALCULATION?

Answer 2

If ( Person::Type = “Customer” , “Customer Detail” , “Employee Detail” )

Question 3

3. What does the term RETURN SEPARATED VALUES mean?

Answer 3

If a field holds more than one chunk of text, each on its own line, FileMaker considers each a SEPARATE VALUE, hence “RETURN SEPARATED VALUES.”

Question 4

4. There are TEXT VALUE FUNCTIONS, but how can TEXT have a VALUE?

Answer 4

To FileMaker, VALUES ARE WHAT FIELDS HOLD, so a Field’s TEXT is its value.

Question 5

5. TEXT VALUE functions let you use those line breaks to:

Answer 5

PARSE TEXT. You can think of those bits of text as lines or paragraphs.

Question 6

6. What would you use a Text Value Function for?

Answer 6

Say you have a field called COLORS with lists like this: Red, Green, Blue, Orange, Yellow. It contains five VALUES, and you can work with them just like characters and words.

Question 7

7. In the COLORS Field, what does the function LeftValues ( Colors : 2 ) do?

Answer 7

It returns “Red” and “Green”

Question 8

8. What other TEXT VALUE FUNCTIONS are there?

Answer 8

GetValue, RightValues, LeftValues

Question 9

9. LeftValues and RightValues are useful when you need to pull some items form a RETURN SEPARATED LIST, but they are also useful for:

Answer 9

When you want to protect your db from people who know that you can add multiple items to a RADIO BUTTON list (by Shift-Clicking)

Question 10

10. What function do you use to keep people from selecting more than one item on a Radio Button list?

Answer 10

RightValues ( Premiums ; 1 ). This function will not allow anyone to select more than one item in the “Premiums” field (the Premium list, in this case, is a list of freebies that allows your customers to choose one free gift)

Question 11

11. What if you want to limit a CHECKBOX SET to only TWO items?

Answer 11

LeftValues ( Premiums ; 2 )