Community Videos, Tips, & Techniques, Articles.

This calculation will create all combinations of type: A B C A B A C B C A B C ect useful for creating right keys for multikey relationships P.S. No need for scripts Dj MultiKey.fp5.zip

Here is an updated version of my file documentation utility. It addresses most of the OSX issues, and adds an improved user interface for processing, finding and printing. As always, please post your bug reports here, and I will try to fix them as time permits. SoftDoc102.zip

Does anyone have a sample database that implements security using a username & password? I am trying to find one to reference. John

I just wanted to thank all of those who've posted samples here. It's pretty rare that you find folks this willing to share their work. I know I've been able to pick up some very usefull techniques here as well as some nice graphics (thanks falkaholic). Ok, now I'd like to make a request. Any gurus out there willing to put up a very basic/very simple database that illustrates how to separate data from structure? Thanks again! Joe

I don't have my own file to post here, but I thought that people might want to know that Filemaker.com has an excellent starting point called the Filemaker Solution Framework. You can download it with the demo version of FM6. I have found it to be a very well-designed solution that will give anyone looking for business applications a head start. Ken

Dear All, Somebody have a self-join example to get subset of the parent ...in the same file? Or could you tell me the site so i could visit to learn? Thanks

I would like to be able to wrap text in a portal based on the length of the the data returned. Example: Directions 1 XXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXX YYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYY YYYYYYYYYYYYYYYYYYYY ZZZZZZZZZZZZZZZZZZZZ I don't want to display any additional blank lines at the end. Thanks, John

Suppose you have a field let's call it Product_Code and another field Product_Description in a typical user interface you would have the field defined as a popup list or menu on a layout you would show a value list of the codes and also a the description so it is more human readable. This is typical for using a layout but what about with a plug in. Since lookups are based upon the Product_Code and don't have users entering into the description field, defining the plug in to show only the codes, it's not very rememberable, here is a way to make it more useable. In the file where the list is looked up from create a field like this, use this field when you define y…

This sample file "TxtStyl.fp5" shows how to 'embed' styled text in your solutions. You can have bold, italic, etc. text embedded with other plain text. The key here... utilize 'Merge' fields within text. This file "TxtStyl.fp5" is 'unlocked'... open, change, and do as you please. It is a FMP 5.5 file compressed into a '.zip' format. Use 'ZipIt' or 'Stuff-It' to uncompress. Good Luck!!! Bob Kundinger [email protected] TxtStyl.fp5.zip

This is a very very simple Parent/Child setup, where you can add related child records from the parent record with a script/click. For example, Notes for a Client. The child records also date and time stamp themselves, so they sort automatically in the parent record's portal, newest always on top. This is nothing fancy, but I see a lot of parent/child questions, especially amongst newbies. I hope this small simple demo, which is entirely open, will help explain how this all works. I find it's always easier to learn if you have something to take apart. HTH Add Notes Setup.zip

Ok, I've created one db file (FMPro 5.0v3) and seven format files Compressed as a .sit it uses 1,961,791 bytes. Compressed as a .zip it uses 2,230,863 bytes. The size is caused in part by one picture per record. The size is too big to post as an attachment on this forum. No scripts in the browser solution. The db file is a greatly altered file which has the original use in a group of related db files. As a secondary use I have a copy which I use to experiment with web publishing conundrums. I have reduced this example to eight records, each of which contains a picture in a container field. Plus other fields. There are seven format files (.htm and .txt) written …

This is an example file how to make possible scripted sort on more then one field(s), in the order set by the user. Harryk multisort.zip

This sample file (MoveData.fp5) shows how to save changes in one field to a 'Archive-History-Audit' field. What does this mean... Lets say you have an 'address' field that has the data "101 Main Street". A user wants to change this data to "1000 North Broadway", but, wants to 'archive' the old address. This situation would typically require a 'notes' field where the user will copy and paste the 'old' address. This sample file will show how to accomplish this in a number of ways... Automatically! Some possible uses... - you could have this 'archive' any changes to field data - you could have this maintain a 'history' of changes to field data w…

Sample file showing a method for finding occurences of words within a specified distance of each other. Refer to the script documentation to see how it works. This is in reference to the following thread: http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB6&Number=40809&page=0&view=collapsed&sb=5&o=31&fpart=1

A few weeks ago I mentioned a Proposal builder I used to use back in '96-'98 to bid on projects quickly so that the clients/leads could get a good idea of what they're looking at -- without me spending too much time on the Bid itself. I think captkurt asked to see it, so I dragged it out the dusty archives, gave it a cursory polish, and now it's online. It's basically a set of 4 tables. Home, Clients, Proposals, and Templates. Click here to go get it. I had to put it on my site because it wouldn't upload to FM Forums. It's 165KB. It's totally stripped down, on purpose. It's completely open, so abuse, use, and plunder at will. I have no doubt any…

As suggested by our members, I have created this new forum for you to create a summary of your article. And perhaps any sample files that belong with your article. You may then create links to previously posted threads to aid in your article's or pull quotes from other threads.

FileMaker doesn't have an easy way to print out your relationships. Here is a solution that requires 3 extra fields and one script that will allow you to easily print out your relationships. relationship.fp5.zip

Shall we open this forum? Here's the solution I've sent to Dan as answer to his post Dj Complex relationship.zip

There is so much knowledge floating around this forum. Is it possible to have another forum topic that would contain either helpful hints and/or snippets of scripts uploaded by members that would contain their favorite techniques?