dbruggmann

Filemaker Inc about FMP7: "Databases can store up to 8 terabytes of information

For a tabbed interface you may want to start with this free example:

Do you need a PDF of one invoice (1 record in your table)? Or do you need many PDFs of many invoices in your file? Or do you need one PDF document, which contains many invoices? Anyway, with Mac OS X you can save a PDF document in every application by simply choosing the option

Hello Scott I changed your file slightly according your wish and attach it here. Have a look at the Value lists Dialog and the Relationship Graph, then you can probably figure out my changes. Timesheets_v2.fp7.zip

Regarding the ID and Name field: 1) select the name field, choose

Hi Dave! Again, there's no wizardry: I just copied/pasted the

Sorry, but I had to split my reply into two posts. Here's the rest: >> For example, I want to know how to make a field use certain formatting based on the contents of a field. I know it can be done, but I am still trying to figure it out. Lets say a member is a bronze member, I could have the Membership status field have a background of bronze, and so on. << Generally you need a new calculattion field and some global fields. The calculation would look something like: Case( MembershipStatus = "Bronze"; g_bronze; MembershipStatus = "Silver"; g_silver; MembershipStatus = "Gold"; g_gold; g_white) Into the g_fields you insert a rectangle with the respective colour, which is displayed by the calc field depending on the content ot the original field. You only have to make the calc field an exact copy of the original, place it behind and make the original transparent. >> Another simple thing I haven't even been able to figure out, is how to copy formatting from one filed to another. Let's say that you created a layout using one a FM's templates, then you add a field later and it looks different. I should be able to copy the formatting, or save a color they used in the template, but I haven't figured out how. << That's easy: Click on a field with the correct formatting, choose the Format Transfer Tool beneath the menu row (the one that looks like a yellow paint brush) and click on the new field.

Hello faaslave >> I think maybe I should just stick to having the user manually put in the discount rate to keep it simple. << That might be simple, but it's not very foolproof. Will they remember, which rate is for which client at what status? And chances are, that there will be more than one time, someone writes

You need a second table occurence for Portals.fp7.zip

In layout mode double click the part label of the appropriate subsummary and the Part Definiton dialog appears: At the bottom check

The simplest thing would be to have two portals: One for all projects, which are reviewed the first time at the meeting (Relationship

Hi faaslave Attached a copy of your file, to which I applied the things I wrote about in the previous post. What I did is really just one of several ways to choose from, it depends only on your needs. Keep asking! One last remark: You have linked Clients to Invoices via the Clients Name as key field. This works, as long as there are not two clients with the same name. In my copy I changed the relationship to use the ClientID as keyfield. Hair9-21.1Copy.fp7.zip

No laugh, only some remarks: 1.) In your scripts you use

You may have a look at the

Try this: 1. Export your old number field as tab-delimited 2. Open the .tab file with a word processor 3. Copy the content 4. Paste it in a Filemaker file in a text field named

I remember two sample files for high lighting found text:

Hi Cable Attached you find a sample file, that fits for your needs, I think. You will surely have to adopt a little more for the exceptions of the real world data. But it should give you a good start. AdressBreaker.fp7.zip

>>My question is, is there a way I can avoid showing the ID at all ? and make it so that the user just sees the information that makes sense to them (i.e. Algebra 3) Yes, just place only the fields onto the portal row, that you want your users to see. Filemaker will do the correct relating

Critical are file, field, and relationship names. You should only use "A"-"Z", "_" or "|" to always be on the safe side. - File names:

Use the portal trick: Define a portal with just one row, make it opaque (no border, no fill) and base it on a relationship, that you can toggle (ie. between a global

Start your input from the beginning: SetField (InputField"; InputField & value & "

Maybe you could use a couple of them to build a layout with a lot of fields from external files which have to be in the exact identical position and you don't want to switch all the time using "Object Size"? But I'm not sure, if this is useful

If you work with FM7, there might be a chance. In FM7 you can change the "Field Behaviour" of your last field on the record to NOT go to the first field when you hit Tab (deselect the option). But then you're quite stuck: You can't trigger a script (to got to the next record) by field exiting in FM

You have to enter "15:35"; if you enter "1535", Filemaker assumes that are 1535 hours.

I'm not sure, what you mean by "alphanumeric". Actually, if you check the validation option "Strict Data type: Numeric only" for the field, the user can't enter anything else but numbers (and a minus sign); make it strict, so he/she can't override the rule. But maybe, you want to allow the user to entry anything, but want to store only the entered numbers. If your input field is of type number, you could use a calculation field c_onlyNumbers = "TextField" and format its result as number too. This will allow the user to enter anything, but the calculation field will only contain the numbers and ignore any characters (except a dash as a minus).