This set entered on 8-3-14
8.3.14.2
- 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?
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.
- What function would you use to GO TO LAYOUT NAME BY CALCULATION?
If ( Person::Type = “Customer” , “Customer Detail” , “Employee Detail” )
- What does the term RETURN SEPARATED VALUES mean?
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.”
- There are TEXT VALUE FUNCTIONS, but how can TEXT have a VALUE?
To FileMaker, VALUES ARE WHAT FIELDS HOLD, so a Field’s TEXT is its value.
- TEXT VALUE functions let you use those line breaks to:
PARSE TEXT. You can think of those bits of text as lines or paragraphs.
- What would you use a Text Value Function for?
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.
- In the COLORS Field, what does the function LeftValues ( Colors : 2 ) do?
It returns “Red” and “Green”
- What other TEXT VALUE FUNCTIONS are there?
GetValue, RightValues, LeftValues
- LeftValues and RightValues are useful when you need to pull some items form a RETURN SEPARATED LIST, but they are also useful for:
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)
- What function do you use to keep people from selecting more than one item on a Radio Button list?
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)
- What if you want to limit a CHECKBOX SET to only TWO items?
LeftValues ( Premiums ; 2 )
