In just about every product, there are tips, tricks and "QUIRKS" -- the stuff that isn't in the manual and one only discovers it through trial and error or because someone clued you in on the secret handshake.

For example in one DOS RDBMS application, you were never to define a field starting in row 1, column 1 -- It would do srewey things to the application (not in manual).

Another: In the same table, if you set two fields to unique, you didn't end up with two unique fields but a concatenation of the two defined the uniqueness (not in manual).

If you could offer to me, an FMP newbie, FMP's quirks or hidden traps that one ought to stay away from, I'd be much appreciative. Or if you have a list, please send. Or if there's a list or book or whatever that you could point me to, I'd appreciate it very much.

Much easier if one knows ahead of time what one could step into versus discovering that you've already stepped in it.

Thank you.

One of the best sources for tips and tricks is reading the theads in this forum...visit it daily and scan the posts for all the tidbits from the moderators and experts.

Two sites you ought to vist are www.clickworld.com and www.databasepro.com

FMPro has a feature "repeating field". Avoid its use in probably 99.9+% of the temptations.

Be very careful in your layouts of how you arrange portals in portal rows and subsummary fields in the sub-summary fields by category (trailing). Over-reaching the bounds will cause printing problems at the very least.

ScriptMaker is single-threaded.

There are a lot of tools with which to work and often they provide options. A good solution is mostly good design.

And for books, etc., Scriptology is very useful. Also (IMO) FileMaker Pro 4 Companion, by Maria Langer is very useful. I spent about a week reading the latter several years ago. It was worth it in terms of time saving, ideas and understanding, but the plot line is rather thin.

quote:

---

Originally posted by danjacoby:

Gee, Oak, I think we should let him in, and everyone else (call me "Prometheus"...). Here are the first two:

If you create a database with three text fields and one number field, then in the second record, enter "%56hl" into the second text field (it's case sensitive, so be careful), you can then use this database to program your coffee maker to start at 7:30 a.m.

If you then add three more records, then delete record number four, then delete the contents of the field in record number two, you can go a week without showering or brushing your teeth.

OK, those are the first two tricks; I'll pass others on as I feel you're ready for them.

---

So I am not the only one using this

Anatoli

Try Special Edition Usiong FileMaker Pro 5 by Rich Coulpmbre available on Amazon.com

It is a critical resource for anyone aspiring to do enterprise level FileMaker Pro work.

Old Advance Man

Kind of like the Dilbert cartoon. "Teach me to be an engineer. I don't care if it takes all afternoon."

FM is pretty well behaved for a program that is so complex. Most "bugs" reported in this forum are user misconceptions about how some feature works. This is not to say that there are not some "undocumented features". I'll give you a couple:

1) Portals don't always refresh after some changes. You'll need to script say Enter Preview Mode then Enter Browse Mode.

2) In multipage documents, test breaking across page boundaries can be split in half.

There is, of course, much more. A lot of it falls into the class of knowing how to use the tool. The biggest "traps" in any database program are not understanding database theory and improperly structuring a solution. A bad design for a house is a lot harder to fix than a door painted the wrong color.

For tips and tricks, take a look at Scriptology by Matt Petrowsky and John Mark Osborne.

-bd

Gee, Oak, I think we should let him in, and everyone else (call me "Prometheus"...). Here are the first two:

If you create a database with three text fields and one number field, then in the second record, enter "%56hl" into the second text field (it's case sensitive, so be careful), you can then use this database to program your coffee maker to start at 7:30 a.m.

If you then add three more records, then delete record number four, then delete the contents of the field in record number two, you can go a week without showering or brushing your teeth.

OK, those are the first two tricks; I'll pass others on as I feel you're ready for them.

Firstly, read Scriptology. Then read it again and again and again. Copy all of the sample files to your computer and go through them one after the other. Do not leave a chapter or demo file until you fully understand it. If you have a serious problem getting something to work, create a new file and work just on this one problem. Keep these files.

Secondly: Visit this forum as much as you can. Look at every question and answer. Ask yourself, can I do that, if not try and find a way. For example Barry, your alphanumeric serials: I’d never thought about it before, as I’d never needed it. Your question interested me so I tried to find a way to do it. It was nice to be able to help you, but really I was helping myself. LOL

Thirdly, and this might sound dumb, but I use the following method. I buy big notebooks every month and perform the tasks I want to do on paper. I ask myself, how would a person deal with this problem. If, for example, I find myself creating different piles of information on my desk, or using more than one notebook for one solution, I know its time to start thinking about related files.

Fourthly, I try out calculations in Excel a lot.

Fifthly, Play Counter Strike! LOL! It won’t improve your FMP skills, but it’s fun.

One last tip: If I have very long calculations using several variables (Fieldnames) I tend to use a text program –(MS-Word) as the search and replace function is great!

Rigsby

Rigsby observed, "Secondly: Visit this forum as much as you can."

This is very good advice. And as your first FMPro project construct a db file in which you can store some of the things you find here (I do). The titles to the threads are often no indication of what the issue truly is. In your db file you can set a title line which relates to specific clues, e.g., portal, exact find, relation, global, etc. Copy and paste stuff into a text field. Even though you may not need it today, when you need it tomorrow, you will be able to find it (a useful answer) quickly.

Example: In the Define Fields forum today is a useful answer by Russell Baker to "Calculation to change field color". You could store this with the words "field color", "Text color", "Calculation" and "overlay". You may not need this answer right away, but if you have it in a quickly searchable db file, it is there when you need it.

You have to check out this site, I'm almost sure that's what you're looking for:

http://www.a2soft.com/feature-bug.htm

Dan, I tried your coffee maker trick, but at 7:30, instead of making coffee, the coffee maker caught fire and nearly burnt the house down. What did I do wrong? Is this one of those Windows vs. Mac issues?

Bob,

I had the same thing under Windows98, Microsoft have a patch for this - not sure about the Mac! I haven't figured out how to switch that on yet! LOL

quote:

---

Originally posted by BobWeaver:

Dan, I tried your coffee maker trick, but at 7:30, instead of making coffee, the coffee maker caught fire and nearly burnt the house down. What did I do wrong? Is this one of those Windows vs. Mac issues?

---

Heh heh heh.

"...not sure about the Mac! I haven't figured out how to switch that on yet!

...

"Where there

It's so good to see that everyone has such a wonderful sense of humor and still willing to help. It'll take me a while, but I'll get up to speed on FMP. Just ordered Scriptology ($79 BUCKS from Amazon -- YEOW!!!)

This is like buying a Microsoft NT Book. An unlike our friends at MS, I sure hope it's better written and really has useful stuff in it

Thank you.

You won't regret it barry!

:-)

All the best,

Rigsby