Using Fmp 8.0, more familiar with 5.5. Using Win XP pro.

I want to print an audit checklist each time we make a product.

I'd start by creating a standard list of questions, that is, the list
would be the same for each product.

An example question/field would be "Has the product been painted?"
(The value in the field would also be "Has the product been painted?")
Then as I enter data for each product, each question will be marked,
"Yes, it pertains", or "No, it doesn't".


Then, when it's time to print the checklist for a particular product,
I want the checklist to print a question ONLY if it pertains to the
product. For ex, if a product is Not Supposed To be painted, I don't
want the question "Has this been painted?" printed on the
checklist.

And I only want to use ONE layout, printing the "yes, it pertains"
questions, and having any other fields in the layout shrink/contract if
they don't need printed.


Looking for the easiest way to set this up, not necessarily the most
efficient.

In article <1166024302.887040.325020 (AT) 80g2000cwy (DOT) googlegroups.com>,
steved (AT) dakins (DOT) net wrote:

There's two obvious ways, although not necessarily the most efficient.

1. A set of Calculation fields that use the If statement (or Case
if you prefer) and put them all on the Checklist layout set to
Slide upwards.
ie.

Q5_calc = If (Q5mark = "Yes, it pertains", Q5Text, "")


2. One long Calculation field (or a script) that appends all the
needed questions together in one print field.
ie.

Questions = If (Q1mark = "Yes, it pertains", Q1Text & Ret, "")
& If (Q2mark = "Yes, it pertains", Q2Text & Ret, "")
& If (Q3mark = "Yes, it pertains", Q3Text & Ret, "")
& If (Q4mark = "Yes, it pertains", Q4Text & Ret, "")
& If (Q5mark = "Yes, it pertains", Q5Text & Ret, "")
...





Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Thanks so much! This is very cool.

On a somewhat related note, I'm interested in hiring a consultant for
some FMP projects, and wondering what a reasonable rate is. I suppose
it depends on the consultant's background, as well as a variety of
other factors, but are there some general guidelines, or pay rates
according to whether they're "FMP certified" or not, with a large
company, vs a one-person shop with lower overhead, etc. (I'm in the
Indianapolis area.)

Any ideas as to what pay rate is fair? Thanks again.

Steve

It's very hard to say what a standard rate is. Some consultants scale their
fees depending on the client's ability to pay (for example, charging less
for non-profits). Some charge on a per-project basis, as opposed to hourly.
You could be charged less for "easy" work (such as adapting a pre-existing
solution) vs "hard" work (such as building a web-capable system). And yes,
experience/skill has a huge impact on their fees.

I would add that "FileMaker Certified" simply means that the consultant paid
for, and passed a 60-question, $150 test given by FileMaker. It's primarily
a marketing expense; certified developers who are also FSA Associate and
Partner members get listed at:

http://solutions.filemaker.com/fsa/s...fied=certified

It's not an assessment of their quality of work... You don't have to submit
referrals or samples of your solutions to become certified. And many
excellent FileMaker developers have opted not to take this test.

<steved (AT) dakins (DOT) net> wrote