Community Videos, Tips, & Techniques, Articles.

This is an example of how to choose from a long list of clients (or anything) with a "popup" window and a "letter-filtered" portal. It was first made in answer to a post, hence the Law Cases and dates. But it is general method. There's no documentation (as yet), so look carefully at all the parts to do with the pop up window, incl. the test in the other scripts, which, combined with the Loop/pause lock, makes the window essential "modal" (you can't do anything else 'til you make a choice or cancel). LawCases2.zip

Hi, Just an answer to a thread in another Forum... May be it can be used elsewhere. v5 format file. Save as clone and use the reset button, because of my foreign System. WhoIsOnCall.zip

I'm trying to create cascading drop down menu that work in CDML. I've got them working in FM but can't get the second one to update on the web. I posted in Using FileMaker Online (http://www.fmforums.com/threads/showflat.php?Cat=0&Number=117041&an=0&page=0#117041) and they pointed me here. It sounds like I need to do this with Java. Can anyone help me get there? Here is the page. I want a room list to come up after a building is selected. http://helpdesk.chesaningschools.net/helpdesk.html I'll also attach the database. Thanks, Brad fm.zip

This is a tip I often use to select a client from my database. You could even perform multiple selection using a text field instead of a global, then select a script (I use it for e-mailing when I cannot select the clients through a scripted find) I find it very useful and this could be a good solution for others. From Bob Bowers/Chris Moyer Advanced FM

Hi, Just in case someone needed some kind of quick and friendly date inputs for finds process. This is extracted from a complete scripted "external Finds solution" I've been building. I'd try to convert it to 7 later. Sure Custom Functions could be useful here, as well as other neat new features. Edited version on july 17th UserFriendlyDateFinds.zip

This file demonstrates a new technique for generating a cross-tab report. There is a second table in the file called "CrossReport" whose sole purpose is to be a cross-tab summary of the data table. The script regenerates the CrossReport table when run, with the assistance of a multi-predicate join to decide what bucket of the report to total onto. FileMaker Version: Dev 7 Platform: Mac OS X Panther

In FM7 we can have multiple open windows. I use these "Pop Up" windows to display details from a list, find criteria entry and other such "temporary" views or functions. The flash of white when a new window is created is really distracting so... 2 global fields: gWindowName, gWindowPopUpName 1 get script: Get window: gwindowPopUpName If current window does not equal gWindowPopUpName, Make a new window Set window tile: gWindowPopUp This is a sub script at the beginning of each navigation script going to a window pop up. 1 hide script for pop ups: Set WindowTile: FileName&"PopU…

This sample shows how you can grey out the next / previous button when there is no next or previous record. This also shows the use of a custom function to help clean up your scripts & calculations enjoy Version: v7.x Platform: Mac OS X Panther PrevNext.fp7.zip

This is a basic example of creation and resetting of Accounts, with assigning Privilege Sets. It is in 2 files, but the technique would also be useful in a 1 file solution, if you have many accounts. There is an option to store the password in a field, but it's not really such a great idea, unless you encrypt (which you can do using a Custom Function; but that's another solution).

One of many tricks sure to come as the experience grows with v7. To create a modification log like we used to do with self triggered look ups and such woudl be such a pain in v7 because you can't simply duplicate a table with all the fields and relationships in it. So.. I discovered an easier way. However, my easier way doesn't go to the trouble of showing what the field contents were changed from/to. Instead, it just shows the users name, timestamp and the layout name they were in. This is enough for me right now and provides adequate satisfaction of HIPPA (medical) and other needs. First, create your basic fields that return the last user modificatio…

Before: I had a script asking the user to create a new record if there wasn't already one from a Secondary file(and relational to a Primary file). After: I deleted a layout and created a new one with the same name, checked all connections with the layout and updated them as required. The script then, kept asking the user to create a new record wether a record existed in the Secondary file(and relational to the Primary file) or wether it didn't! What I did: I made a small cleanup in windows. I deleted all temporary files sitting around in windows and restarted. The sript now is working fine without doing anything else! I see this helps in some situations…

I have downloadedthe v7 trial is there anyway to get the tutorial files from anywhere???

I have come up with a technique to lock down a workstation using a FMpro kiosk. (On windows) The first hurdle is to disable the use of windows keys like alt-tab, ctrl-alt-del, the windows key, etc. I found a visual C++ project file on the MSDN web site that does exactly this. (a low level system-wide keyboard hook dll) I have built the project on windows XP, and this works very well to keep a user in the kiosk. If anyone wants the executable let me know. The next task is allowing the kiosk to control access to apps without having the user access the taskbar, start menu, desktop etc. The best (cheap and easy) way that I found to accomplish this using the se…

Hello, I am running FMP ver 7. I started to create a program for my Martial Arts school, and I'm running into some problems. I have entered some "dummy data" in it, and was wondering about posting it on here to get help? Can I do this, or does it need to be done outside of this forum on a private level? After I receive some responses, I can ask my more direct and specific questions. Thank you. Donnie

Post deleted by JerryC

Hi all, Have been playing with Filemaker a little bit and want to get a database running that is more efficient for our computer retail / service business. Below is an image of our existing database, it has quotes, invoices, correspondance, purchase orders. But i am wanting to cut it down to a computer service database. (this is for tracking customer jobs whilst they are being repaired.) Is there any templates that anyone knows of that i can manipulate?? Websites, Templates would be most helpful. Cheers Chris

A nifty way of really making sure a runtime demo is useless after X days or X uses. Run a script that changes the users account or - deletes the user account. After your solution has time-bombed. This will surly render the demo useless. Version: v7.x Platform: Mac OS X Panther

Here is a FMP7 file which does a mass export of images without the use of a plug-in. This file only works with Windows, but can be adapted to Mac with a little knowledge of directory structure and command line parameters. Also, it has a "Custom Function" which can only be viewed or modified with developer edition. However, this will not keep you from using the technique in your own solution as the function is only used to display an elapsed time in the export closing dialog. Extract the file anywhere you like but maintain the directory structure I have setup so everything works okay. You can of course change all of this in your own solutions. Hope some…

Trying to create a Home Inspection databaseand am new to FM. Is there anything close to this out there? Is FM the program for this? What I need it to do is: Have drop down list where I can choose from my list. Have check boxs. Add photos. Have all data tranformed into a forms template for printing.

I Found this Article yesterday and I think its useful For every developer... The Origin of FileMaker Pro (by Glenn Koenig, based on a telephone interview with Spec Bowers in December 2001, last updated on 2 April 2004) The history of Filemaker starts back in the early 1980s with four people who originally worked at Wang Laboratories, headquartered in Lowell Massachusetts: Spec Bowers, Alan Albert, Dan Chadwick, Jega Arulpragasam. Wang Labs had a political culture back then, if you were on the inside track (essentially, if you were Chinese), you would get support for getting things done. The four of them wanted to develop some new products but …

Edited 2004-05-21: Please note that the file that was attached here was an early version which would not document scipts when run under OSX. I've deleted the attachment to prevent the old version from circulating. For the latest version, please go to this link: New Thread and Latest Version And please post your comments to that thread so that this one can sink to the bottom of the pile and die a graceful death

Remove borders and use the line tool to draw borders

I applied a little graphic design trick to my horribly fuzzy fields and it seems to have solved the problem until Filemaker comes up with a real fix. Select all of your text fields at on time (this is for speed, not a necessary step) then duplicate them. With the duplicated fields still selected, position them on top of the original fields and then nudge them, one pixel at a time. My fields came into focus with the duplicated field just one pixel to the left of the original. By the way, I did this with the original fields having a color fill and the duplicates having a transparent fill. Take care, Leslie Davidson PS I posted this in another sect…

Here is a basic calendar that I put together. I replaced the attachment. Version: v7.x Platform: Mac OS X Panther cal.zip

Hi, A developer usually tries to offer the user the Maximum functions. This sometimes leads to a lot of Mouse wheels scrolls, as it is difficult to concentrate these functions in only one area of the Layout. The tabbed interface certainly offered a lot of answers to these concerns by providing a very dynamic way to jump from records to records. But when it comes to "Functions".... This tip, using J.M. Osborne Visibility and an Aqua-Like Interface, tries to offfer another answer. Included also is a "Save Found Set" and "Save Flag Set" method, particularly helpful when the user would be often moving from records to records in order to "flag, mark or lock" th…

Lets say (sorry for my bad english) "set RGB "80 10 30" ...and this script fill your RGB field with this colour! You think you can't do this in FM PRO... no no

Coming Soon Round Robin Tournament that will support upto 12 teams per record.. Schedule is pre-built into the many calcultions. Stats Screens keeps Win - Loss records. See the Picture for Preview. Will post file soon..... v6, v7 Still looking for that big FileMaker Project.

Enclosed is a sample file showing a technique of how to pass multiple values to a script using the pass script parameter function in FM7. This sample passes 3 values via the script parameter to set the RGB code to color text. I have not played around enough with it to determine if there is a length limit on the parameter itself. FileMaker Version: Dev 7 Platform: Mac OS X Panther FileMaker Version: Dev 7 Platform: Mac OS X Panther

I wanted a calc to let a user know they had 5 business days to return a book to the library. This is my work around. Hope it helps someone, Dean

hi. We decided to provide our employes (web) access to a forum to discuss company-related topics. There are many free solutions based on php-mysql and other platforms. Does it exists anything made with FileMaker? Thank you, Paolo.

I want do a couple of things with credit card numbers. How can I have the numbers appear in this form xxxx xxxx xxxx xxxx instead of xxxxxxxxxxxxxxxx so it is easier to read? I also want the person to be able to enter the number without having to tab if the above solution requires 4 separate fields. I have created a verification of the current field I am using by having them enter the number twice and setting the second field to = the first. Is this the best/simplest solution for making sure they have entered the number from the credit card correctly? Thank you in advance for your help FileMaker Version: 6 Platform: Mac OS X Panther

just passing along the info:

Hi All Been extending my mathematics over the last day, and thought those of you working at a similar level of development (ie. very basic) might like this little operation to get your windows to pop-up in the middle of a user's screen. When using the MOVE/RESIZE WINDOW script step, add the following calculations in the dialogue box; - select 'specify' for both 'distance from left' and 'from top' In the calculation, enter: (Get ( ScreenWidth )-Get ( WindowWidth )) / 2 (for the 'from left' option) and (Get ( ScreenHeight )-Get ( WindowHeight )) / 2 (for the 'from top' option) In addition, I created two custom functions to r…

(sorry. for FM7 only) if you can convert it to 6 please do. here is a database of about 1000 buttons. guest has full rights. dont thank me thank the person who made it. FileMaker Version: 7 Platform: Windows XP

Hi I

Hi, As many of you, I was pretty lost when I first tried myself with FM Text functions. This is a very quick Tutorial, reviewing with some examples, the main functionality and technique used for parsing and stripping text. I'd try to update it soon with a quick tool full of globals for some experimentation on these concepts. The "tutorial" terminology may be a bit pompuous. Consider it as an introduction. Building it even helped me review some of the main concepts. Thanks for any comment. FileMaker Version: 6 Platform: Mac OS 9 ParsingTutorial.fp5.zip

I would like to ask about something with FM Shopping_Cart example. I have tested this example and noticed, that if you have already registered with username and password, FM lets you in the detail data of customer (document.idform.submit; button Continue on customerid.htm page), either if you type in only password (without username) and vice versa. I would really appreciate, if SOMEONE could suggest me the right CDML tag to repair the example in such a way that without username and password you couldn't get to detail customer data (customerinfo.txt);. FileMaker Version: 6 Platform: Mac OS X Jaguar

I'd like to not have to invent the wheel if there is a solution out there. Does anyone know of a mailing database in which I can import a mailing list, i.e from an excel file or tab or comma separated, name the imported source and mark each record, cull the dupes, and THEN keep track of the found sets that are then mailed out? I've been working on it , but would like to compare my solution with others if there is one..... Thanks. FileMaker Version: 7 Platform: Mac OS X Jaguar

I had a thought that may help or become a standard practice that I plan to employ If I use a plug in (example FTPit) or any other plugin that requires several fields I choose to create a table solely for this plugin. All the fields are globals. And all the necessary scripts refer to these globals. I think in practice it will ease the management of 3rd party plugins. That's my 2

I found a way to enter First and Surname into two fields and have FMP check them for both being unique in real time. The solution involves the Status(CurrentFieldName) command. This can be used to perform a calculatopn ONLY if you are currently in a specified field. Your file has the following fields: First Surname Address You will also need to create the following calculation: FullName (Calculation, Text result) = Name & Surname Next create a self-join relationship based on FullName. This is a relationship in which the master file and related file are the same database file. To create a self-join: 1. In the current file, choo…

Usage: Click on any row of the gameView portal and click the "Goto Game" button. Now you can select the script "Slide Show" to see that game played, at one move every two seconds. I include data for several of the Kasparov vs Deep Blue games as an example. To play your own game, choose the "New Game" script. Click on a piece to move, then click again on the destination square. The board will move the piece and fill in the chess notation for you. The board enforces who's turn it is, and that the pieces are being moved in a (mostly) legal fashion. When you finish playing - your new game is now available to watch as a slide show also! Demonstration of …

Why not ? FileMaker Version: 6 Platform: Mac OS 9 2WaysLookup.fp5.zip

Previously in a script where I had to "save" the record, I performed a GoToField without any field specified. Now with Commit record script step, which is best? FileMaker Version: Dev 7 Platform: Mac OS X Panther

I have a table where the data comes in flat... the data columns has all the data to create 3 additional upper level hierarchical structures. In the past I would just export a sub summarized set this data several times then import the data into the corresponding upper levels. I am trying to figure a way to import the data sub summarized. So that I can avoid the "temp" files that I would have to generate. This represents my tables. Data is imported raw into LevelD LevelA -< LevelB -< LevelC -< LevelD I have tried Looping scripts but it takes way too long the fastest way is importing the records. and the fastest way to get the set…

Very simple script demonstrating how to pass a parameter withing a button in a portal to simplify selection of a record. FileMaker Version: Dev 7 Platform: Mac OS X Panther

If you have a repeating field that you place on a layout as a merge field it is not directly evident that you can display other repetitions - not just the first one. As you cannot access the field format on a merged field. you need to type which repetition you wish to display. <<field[3]>> This will display the 3rd repetition of the field FileMaker Version: Dev 7 Platform: Mac OS X Panther

Hi, I had this "project" burried in my hardrive, and spent some time today on this. Anyone willing to try to break it ? Just attach your own related value list to it, change it to list or whatever you want. It is based on repeating fields iterations, with no script involved, and would allow, as the settings are to make up to 150 selections from a value list of how many choices you want. I've tried with a value list up to a thousand choices (even if it doesn't make any sense for this checkboxes presentation), and it appears to be working so far. If you need more, just change the repeating fields and calcs settings, and increase the iterations up to wha…

Hi all, Quite a bit this "Old version" area didn't get some new files... Here's one that could bring back to some antique solutions with repeating fields. A bit of nostalgy I guess, even if worthless. May be an example of what to avoid too But this was some funny job. I'd almost thought it was impossible. Well, my last try with 6 before I jump to 7. Version: v6.x Platform: Mac OS 9 1080324225-RepeatAndCondit_l.zip

This is a demo file to explore and test the FMP 7 security, and try out its new window handling features. The file is a simple address book. Its main aim is to demonstrate user accounts and user groups. It has only been tested on MacOS X 10.2.8 feedback from PC users is appreciated especially regarding the multiple windows stuff. The brief was for users from the same group to be able to read and modify records created by users from the same group, but to be only able to read records from other groups. There are four "user" accounts. Login a couple of times as different users, create records, see how access is limited depending on the user's group. The names and …

Simple example of a horizontal portal. Designed to demonstrate the self joining relationship for horizontal scrolling. Version: Developer v7 Platform: Mac OS X Panther

I am trying to create a schedule database for printing presses that is day to day/shift to shift specific, based on a start and end time (or run time). I know that I might have to do some work to get it all linked properly, I am just trying to find a plug-in that might help. Any suggestions? Thank you Version: Developer v6 Platform: Mac OS X Panther

Can I get some recommendations as per what plugins are out there for menu creation (or control) I would like to create a custom business solution. creative and functional menu system is what i'm looking for. thank you in advance. Version: v5.x Platform: Windows XP

Hi, As this was asked on another list, and a few times either here... If what you're after is just the quickest way to clear repeating fields, I'd suggest you also have a look to http://www.datatude.net/ for a neat way of clearing repetitions by Ilyse Kazar. Both methods don't use awful loops. ClearOrInsertRepeat.fp5.zip

Is it possible to sum up a particular value for all records? I'm using the an Expense Report from the canned template but would like to customize the list view to show a grand total of all expenses for all records. TIA Deo

Hi to the forum, I'm sorry if I have posed this question in the wrong list. I am a bit confused by the number of forums available. I want to update a FileMaker Pro database using C. i.e. I need to be able from a C program to say update a row of a table with what I want changed. I have looked for the last few hours for a C API into FileMaker Pro with no success. Does anyone know a URL to the C API for FileMaker Pro. If i can't find a C API into FileMaker Pro, I will stick with executing a PHP script from a C file which uses the FX.php class. Thx, Phillip Lucs

I have a db file that generates reciepts for my clients which is fine for printing and sending to the clients,but is there a way of outputting this file so I can email it to my clients in a way that they can read and print it even if they dont have a copy of filemaker??

Hi, well i

Hi, The need for Search procedures did evolve according to Database storage capabilities. If Relational design obviously offered efficient ways to store and access data, automizing searches and multi-criterias Finds is still complex to build. You probably already developed some dynamic search interfaces, specially when the Database is used as a Data Bank. As long as there is no need to keep the criterias, global fields would be your allies, and there is nothing you should be worried about. If you were requested a solution where a set of Multi-criterias Finds Procedures could be dynamically called by the user, you

I did not see anything llike this mentioned around here so i will post here and let you guys take a look. This idea was taken from the Task Manager solution that Filemaker released. Basically, the idea is to have a reports database that stores information for reports and this allows users to create and save their own reports to use at a later time. This potentially saves a great deal of time for the users if they have a number of reports that they will use often. The problem with the Task Manager, though, is that the reports were only for one database, using two different layouts. The project i am working on now (which will be an updated / revamped version of an invo…

2 repeating fields x1 and y1 If n_repeat = 2, fill field ' y ' with [y1-2] This is easy using GetRepetition(x,n_repeat) If x = "John", fill field ' y' with [y - position of "John" in x1] extractTwinRep.fp5.zip

Hi, I am new to this forum and would like to ask a question and attaching a *fp5 file with the question. But i cannot upload it because it is the wrong extension. How do i upload this file ? I made the file on a PC with filemaker pro. Best regards, Maarten

Here's a Pedigree Geneology database. I originally created for Pedigree and modified to accept People, See the About it will explain how to enter the names. v3 CURRENT Pedigree Or GenealogyV3 .zip

Hi, This was made in answer to a post on a french list. This enable you to dynamically fill a repeating container by a repeating field holding the related Ids of the images. Something I discovered while "building" this tip is that the Status(CurrentRepetitionNumber) acts rather strnagely. Check the c_ModTime calculation, which is a basic Trigger from which I parse the ID and Repetition Number. The calcs ends with either 11,22,33, or 44 where I'd expected it would have ended with 1,2,3,4. No problem, just extract the last number, and in case you deal with more than 9 reps, use the Lenght( ) to split and extract the desired repetition. Curious though…

Is it possible to have my db send location and destination (both uk postcodes) to the location and destination fields within the route 66 route planner software, and maybe even get the resulting mileage?: oh and the moon on a stick please,with chocolate sprinkles...(humour/calculation not script)

This is my first database,if anyone would be kind enough to give it a look over i would appreciate it,its fairly basic as i only got filemake 10 days ago.Im looking for some constructive criticism really as ive made it up as i go along and i know it can be improved,key thing though is? will it work or not, cheers

go to right brain and read more FlagsOfWorld.fp5.zip

Here it is.....just a start! Skin your Great Design! Any feedback is welcome...it should be the begining of the "gui" series. All the best! edit note: FMForums could not process the file attachement so get your copy at: http://mostarnet.com/tutorials/filemaker/gui.zip

Here Condition Pattern Notes.zip

Hi all, The first betta seemed to work, so here's the second one... 1. Customize any formula you hacked from the forum by changing fieldnames 2. Translate any formula from any language to any other language. Translatorbetta3.zip

With this idea you can go from one place to any layout . Idea is open for better corrections. Restriction: Max 66 layouts (example have 13), can be more if you need more ! Happy FileMakering INO HeadTab.zip

Hi all, I tried myself today with this. I don't think I would ever use it, but some of you that would like to be Mac fashioned may. Just some basic tabs, bars and borders, though if really someone is interrested, I could go further more on this when I've got some time. Metalizzatov2.fp5.zip

Hi, As there were a few requests these last days about Multi-level relationship and generation, here's attach one way of solving it. PW : master and user. I suggest you start with "user". For the first time, I'd lock the solution when 30 downloads would have been executed. Sorry, sometimes philanthropy doesn't pay the efforts... HTH MultiLevels.zip

I am trying to be able to show where a rock chip hit a windshield. Is it possable to show in a box or container where the rock struck? mabey draw on a square and show where it hit. I want to be able to show the clients info and what not then show where there last rock chip hit from the prior fix. thanks for your help. joe rockchip example.pdf

I have to meet with some people downtown about this program. I wanted you experts to look at it and give me any suggestions for improvement. Here is what it will be doing. 1. Program will be on the teacher's desktop. This replaces the paper form of the referral. 2. The teacher will be able to fill everything out and send an instant message to the administrator. 3. The administrator will do everything on-line and give a final printout to the student. 4. The teacher will be able to check and see what the consequence the student receives. Question: I know there is a plug-in I can use for instant messages. But could I not use the network messaging? I think…

Hi, As this one got deleted and I still need to check what could be with you what could be the Drawbacks of this approach, here it is back. ...with some arragements though, as it is "quite" totally automated from creation to storage. Thanks for any "constructive" feedback. getAuditv4.fp5.zip

Try it, how to scrol text in fp UP & DOWN ScrollText.fp5.zip

Hi FileMakers Need a help - Parsing See my attac. files [email protected]

Hi everyone, I've been struggling to create a contact management database that functions well. I am trying to create a multi-user solution with a main screen with 2 halves. On the left would be a vertical list (compatible with mouse scroll button?) of all contacts sorted by last name with a search box above the list where the user could type in the first few letters of the name they're looking for and the list would scroll to the first match. The right half would be all the contact info for the selected person. Does anyone have any contact management solutions they'd be willing to share or any other tips on creating something similar to what I describ…

This is an addition to the Metal Interface post. As I've been asked several times, I thought I could put this in another single solution. Waiting for some built-in feature provided by FMI (at least an optional thing...) Still Brushed Metal... Edited I removed the Password and updated the Purple and Ruby graphics. OSXScrowl.zip

I am wondering whether or not it is possible to tell my FMP database to give me some kind of an alert if a certain type of record is accessed. Specifics: I maintain a single-user database of alumni from the high school for which I work. Names, addresses, phone numbers, etc. At various times during a year, certain classes are planning reunions and during those times I am in close contact with the class rep organizing the function with address/phone/email updates for their classmates. But at the same time I am still maintaining and updating for the full database. Is there a way to tell my database to alert me when I access a record for a certain year of graduation? O…

Post deleted by searanger

Hi all, For those of you who rememeber Claris Home Page's FileMaker connection wizard, then this is basically my FileMaker version. For those of you who don't know what this is: CDML Creator will create simple HTML/CDML pages you need to put your database on the web. Before starting a new project, please make sure of the following: 1) The database you are going to create pages for is saved in the Web Folder of the FMP Folder 2) The database you are going to create pages for is open 3) The database you are going to create pages for has web companion turned on IMPORTANT NOTE: When CDML Creator creates the files for you, I am not sure where the…

I am working on an invoice database (child for a Contracts DB)for my employer who wants to see totals by month/year and by year (based on the contract). Since I am not allowed to send the current file I am working on, I was able to find something close on "Afilemakeraffliction" website. In the video that goes with this file it states that it is possible to show each month individually instead of multiple duplicate month and total amounts. I was wondering if anyone could help with this in showing me how to make each month entry only appear once showing total amounts. The file uses the aggregated function which I think is great, and since I am still new at this, I just can'…

Hi everyone, Duplicating a record can be dangerous as FM will also duplicate any Auto-Enter IDs which are based upon a calculation. And FM duplicates fields the User may not want to be duplicated , as it duplicates them all. Writing a 'Duplicate' script can be tedious and must be modified whenever new fields are added / removed to/from the database and the script must be hard-coded with all fields to duplicate via Set Field [ ]. If one has vs. >= 5.5, GetField[] could be used but even then, the options in this file can be beneficial. You can allow a User to select the fields to duplicate (via a checkbox) and the script adjusts accordingly . The checkbox w…

Hi all, As suggested by Lee, here's attached a started template for a "ForumResourcesHistory". At the moment, it allows you to : - cut and paste some calcs you found here - customise these calcs by substituting the fieldnames with yours - store the link to the thread and some comments. - store some User Profiles I'll surely upgrade it with some ways to keep track of the scripts and some theory posted here. Feel free to use it for your own needs. Important : I started that file as a simple "Translator" as I had some difficulties retrieving or posting some calcs here, due to the different System Settings. This Translator is still here, desig…

Just a quick demo on how you can grab any HTML with a perl cgi, using regex to extract the relevant info, then import into FileMaker using XSLT. It's amazing what you can do with FileMaker http XML.... enjoy. babelfish.zip

It was asked of me today, Can you show a Pop up Notes fields with different messages depending on the fields content and contents of other fields. So Here's a conditional pattern Notes popup field Sample (New metal look Thanks to Ugo) Condition Pattern Notes.zip

Place format file loose in the folder WEB. The db can be opened anywhere. Create a new record in Web Security for ifor.fp5, All Users, Browse. Entering http://localhost/default.htm in the url address of your browser should work. This demonstration is develolped in FMPro 5.0.v3. If anyone tries this in FMPro 6.x, please post your success or failure. Thank you. The real testing is on records 1-5, while records 6-10 are all the same as record 2. Enter two words e.g. event five (event plus number). This solution is in response to this thread. fmpif.zip

When I create a FMP database, I can bring in a QuickTime video. Is there a way to stream the video and at the same time record an audio file? In other words, a silent movie plays and while watching this movie create a audio file discibing the movie.

This question came up a few days ago, and having too much time on my hands for my own good, I came up with this sample. It allows the user to select import fields and define the import order without accessing the import order dialog box. CustomImport.zip

FM6 has a provision to generate thumbnails when you import images, but if you are using an older version, or you already have a large number of images in your database that don't have thumbnails, this technique will generate them without the need for any plug-ins. It doesn't use Applescript either, so it's cross platform. Note, I have also included a mass import script that does use Applescript for use on older FM versions on Macs, but it's not required for creating the thumbnails. Thumbs.fp5.zip

Developed in FMPro 5.0.v3 Not quite stellar, here is a little something for your entertainment. This demonstration explores what happens when data strings are used with the various operator values in a CDML -find action. There is a bit of opportunity here, maybe. You also get a few of my wonderfully pedantic observations. Oh wow. There is one db file. Set your web security for all users / browse, and set sharing/single user/wc (if necessary). Take all the files out of the folder and put them loose in your folder Web. Open the db file and run the demonstration. Be sure to generate an error from every form as well as the successful transactions. For tho…

These files are part of Intranet holiday and resource booking that I've been working on. NOTE: the databases rely heavily on the generous work of other members of this forum, notably the awsome 'smart ranges' calculations and lots of advice about FMP-inlines and includes, so it's really a collation of other folk's work, but I thought I post these to try to share something in return. Basically, these are a set of ways to show calendars and a web-based wallchart for bookings. As they're still a work in progress, there are some rough edges and less than elegant code. If you have a better way to do this, I'd sure like to know! Read the 'links.htm' file to get starte…

Ages ago, someone asked if anyone had the formula for calculating times of sunrise and sunset for any given date and location. I finally put this together. Sunrise.zip

Does anyone have a template for a time clock? I have to try to reinvent the wheel..

Here is an example on how to set a field background by value. You could use it to convert any Hex RGB value to a field background. Sorry, limited demo only, I will offer this in later as shareware (with some additional features). Give it a try ... ----- I had to include a litte AppleScript to ensure compatability with FileMaker versions < 6 on MacOs 9. Please re-download. See a "standard" solution here: http://www.fmforums.com/threads/showflat.php?Cat=&Number=85362&page=0&view=collapsed&sb=5&o=&fpart=1 Make HTML Color.zip

PyFileMaker is a set of Python modules that makes it easy to access and modify data stored in a FileMaker Pro database. http://freshmeat.net/releases/137777/ I have nothing to do with this project, just posting it because it seems interesting.

I know it is not a big of a deal but I was asked for the help with this issue so I though I share my little notes.... All the best! FM_ODBC.zip

I'd like to have a FMP6 db for icon pictures and just needed something simple that holds a title or name field and box for each graphic with just basic find and sort capabilities (sort by name, in other words). Was hoping someone already had something similar enough and that doesn't mind sharing. I'm a little on the desperate side yet if I get side-tracked on making one up, since I'm still such a newbie and still very slow, that would time away from my current project. I'd like to avoid that, if possible. Thought there might be something already out there. Thanks a million, appreciate any help!