Community Videos, Tips, & Techniques, Articles.

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!

Someone Asked, So here it is. A trick to change the background color of a field depending on it's contents. FieldColorChange.zip

(Edited: Later on the thread is another sampler, which brings some other features) Here's one method for displaying AND entering in a portal just the values you need, and their related value lists. Another use of Get Field () P.S. : The attachment has been edited to get rid of unused scripts, so that you can't be confused while exploring the settings. DynamicPortal.zip

I have modified a calendar database done in filemaker pro which was posted to the samples section sometime ago. I have modified it to serve as an easy to use calendar program. Everything is working fine except there is a problem with shading certain days. If have attached a .zip copy of the filemaker files. Go to JUNE 2003 and you will see what the problem is. It is supposed to shade unused days from the previous and next month however, on certain months it shades the entire first row. I want the entire first row to shift up if it is the case like JUNE 2003. Any help is greatly appreciated. I plan on creating a repeating events script, MYSQL integration, and I…

In one session Darren Terry demonstrated a solution for you to develop a date range system that doesn't require a plugin. Nor does it require a loop in a script actually it doesn't require any scripts at all. The beauty is also that it dosen't bust with the 64k text limit of FMP... In fact you can get a range from 01/01/0001 to 12/31/3000 Check it out for yourself Special recognition goes to: Mikhail Edoshin at Onega Software, who developed this technique. Mikhail credits Geoffrey Gerhard and Jason L. DeLooze on his website. Here is the instructions and file samples.

I thought someone had posted a sample that creates timeline (gantt) type barcharts but couldn't find it here. Anyway, here is another one. Timeline.fp5.zip

Has anyone purchased those "applications" such as Tasks or Recruiter or Meetings? I am very curious. Brad

Background In FileMaker Pro, calculations which include references to global fields or related fields (ie fields from other databases) cannot be indexed. Indexes, on the other hand , perform several important functions: 1. they facilitate searching and sorting on a field 2. they enable the creation of value lists based on field contents 3. indexed fields can be used as the target (foreign) key in a relationship Each of these considerations is significant. however the latter two sometimes present the database designer with a dilemma. Occasionally, the natural connections between data elements require that a relational dependency - or a global variable …

Recentely, there were some questions about how to dinamically renumber related records in portal and how to move them up and down. This files try to answer those questions. Hope you'll find them useful. Dj Renumbering Portal Records.zip

Hi there... In answer to This thread , this sampler shows how Relationships can be "nested" to narrow a "search" built on multiple criterias. This thread had somehow moved to Caf

Inventory databases are such a hassle. This might help you in designing your own inventory system Inv_Sample.ZIP

We run an auto auction and use fm 5.5 for the inventory and are moving to use for actual auction. What is the best way to protect the original inventory but have the sale information up date into db including sale, buyer info. we have database for customer and inventory that work indenpendently but i am concerned about have a db for the sale and having the ablility to pull the car inventory from the original db and then update the sale info back into the original db. I am willing to study info just dont know where to start. We are already running the customer to inventory just to print paperwork for dmv but wish to add the ability to register bidder (from customer …

This is in response to another thread about how to export a tab delimited file where each record line must end with a carriage return and a linefeed. ExportCRLF.fp5.zip

I originally posted a set of sample files that shows how to do typical date calculations that skip weekends and holidays here: http://fmforums.com/forum/showtopic.php?tid/54679 Here is an updated set that includes a holiday maker file that allows you to define holidays that repeat annually, and also lets you define different calendars. For example you may have one calendar for your office staff who work Monday to Friday, and another calendar for your site crew who work Monday to Saturday, or a US calendar which has US holidays for US employees and a Canadian calendar with Canadian holidays for Canadian employees etc. I set this up a long time ago and never pos…

This presents one solution to a checkbox (on a web page) which causes a radio button in a peer-to-peer layout of the db to change according to a valuelist. Certain language of the valuelist (used on edit.htm) was taken directly from a question which was posited by daviator in this thread Drag and drop check.fp5 on FMPro to open. You can drag and drop the format files onto SimpleText (Mac) and make them readable. I do not know if that will work with NotePad (windows). If not, view source. This sample is in FMPro 5.0v3. Set your Web Security db for all users and allow browse and edit. Should run fine on localhost. Select the name of a title (two words, e.g. T…

Not much to this very simple demonstration. To fully appreciate the time formatting you need to create a record before noon and a record after noon. Oops, almost forgot to mention, this is in FMPro 5.0v.3. Unstuff the folder and place the files loose in Web. I should also mention that for publishing over the www your db files should not be in the folder Web. For the demo's which I post the db files are placed there for your convenience only. And create a record in Web Security for the db file for all users, Browse and Create. timedate.zip

Sorry folks I didn't realize that I have disabled "Define Fields" access So now it is really Open Source, Dj Calendar.2.zip

Exploring the -LOP Tag's values More pedantry. Developed in FMPro 5.0v.3, latest WC updaters. Tested on IE 5.1 and NN 7.0. Unstuff. Place the files from this folder loose in your folder WEB. Create a new record in Web Security.fp5 for all users with the permission Browse. Make sure web companion is enabled. I use the URL http://localhost/default.htm. If you are using something other than port 80, you may need to edit the format files and the URL accordingly. For NEWBIES. In addition to the -LOP values, this demonstration uses the "field contents match" restriction in a find, and the text which is displayed on two pages (of four) is controlled with [FMP…

Sometimes it EnterInCalcs.fp5.zip

This is an example file for radiohead on FileMaker Cafe who is looking for a way to create customer IDs using a combination of the customer's last name followed by a sequential number starting at 100, and incrementing by 1 for each new customer with the same last name. You can read radiohead's post here. Essentially this solution uses a custom dialog for First and Last name entry, validates the entries, then sets the ID field from a relationship-based aggregate calculation. It's probably not the most elegant solution, but it works pretty well. It does require that users cannot access the "New Record" menu command so they can't bypass the "New Record" script. This wil…

This is a demo for robert58 on FileMaker Cafe who needs a solution for automatically synchronizing the contents of a pop-up menu field with 6 checkbox fields on another layout. You can read robert's question here. Popup_Actions_fp5.zip

Thought I would send an updated file using Rays calc.

I was chalenged to do this one. See http://forum.filemakerworld.com/viewtopic.php?t=4318&highlight= Attached find a file I modified Logic done originally by JMO Added to this are fields to make the time work less Sat. + Sun. Also New OSX Background. Work Time.zip

http://mostarnet.com/tutorials/filemaker/FMembeded.zip let me know what you think! All the best!

Simple example showing how to replicate almost all the items in the status area when doing a scripted find. FindSample.fp5.zip

Designed in FMPro 5.0.v3 More pedantry. This demonstrates the submission of a username and password through a CDML hyperlink using FileMaker Access Privileges in conjunction with Web Companion. This approach, combined with a bit of JavaScript and frames presents a fair amount of site security. For NEWBIES, this demonstration also uses a JavaScript form submission, the FMP-LinkRecordID tag, and the code to use images in lieu of form buttons, among other things. After you decompress the folder you will want to open the file jsopen.fp5, probably by dragging and dropping on your FMPro 5.+ application. You will be asked for a password. Enter banana. You the…

Here's a Sample I created to get the records that were created withing the last 24 Hours. Just press the refresh button. Posted 8/19/2003 after this date add your own records to makeit work. V2 Removed Startup script Get Last 24.zip

If you need to print from Filemaker onto pre-printed forms it can be tricky getting the fields to line up exactly with the blanks on the form. When you later switch to another printer the fields may no longer be aligned, even if you have selected fixed margins in your layout setup. This sample file shows how the end user can shift a report vertically and horizontally to compensate for printer differences without having to get into layout mode. PrintAdjust.fp5.ZIP

Hi all, Being an eye-candy-junky I made the attached demo that automatically shows different buttons (graphics) and text when changing from browse- to findmode. I did not test the sample in Windows and I'm curious if the 'Aqua' buttons will retain their transparancy when used on that platform. Regards, Ernst. GraphicsAndText.fp5.zip

Hello, I was just on another forum where Chopper had posted a list of Filemaker Error codes. Mentioned he had it in Filemaker. I decided to put the list in filemaker. I'm posting it here because now that I'm learing scripts this will be very handy. Hope its useful to others. This list is also available in the Filemaker help section. Michael

Hi. This sounds like an excellent FMP project and is one of the VERY few to be listed in SourceForge: http://sourceforge.net/projects/phile-o-goo/ Only problem is... there are no files. And nobody seems to be home at the admin addresses. And nobody replied to my post on the message board. Anyone know anything about this project? Is it just a red herring?

This procedure avoid problems when changing IP address of server hosting FM files 1)MacOs X Open NetInfo Manager (applications-->utilities) Select "machines" Click on new and edit name of new folder to for ex. FmServer double click on property name to edit it to "ip_address" (without quotes) set the ip_address value to IP number of the host you are using. Click on new (or select from menu "Directory" New property" Set the property to "name" and it value to FmServer. Now edit the FileMaker Hosts file (located in preferences-->Filemaker preferences) and add line FmServer (if you don't need any other host you could delete them). 2)MacOS…

Question from another forum "Does anyone have any example of a button from one database that will go to the same record in another database with the same ID. But I need it to first search all the records in the second database so that if there are multiple records with that ID it will show them.. if not then create a new record and set the ID field to what the ID field is in the first database. I have tried 100 different ways and can't get it to work correctly. Thanks," See attached screen shots ScreenShot for Find or Add Script.zip

This demonstration was prompted by the thread "Linking to the next record" in the CDML Forum. Remove all the files from the folder and place them in your empty Web folder. Set Web Security for the database file such that all users have browse abilities. Run it on localhost (or whatever suits your style). If anyone can improve upon the solution I would welcome your efforts. There is room for improvement. NEWBIES, there are some notes throughout this demonstration just for YOU. link_next.zip

I just developed this idea to use for an invoicing system at our satellite offices. Quite often my users want to add charges or make changes to charges that cause the sort order of their invoices to go out of whack. The predefined sort orders don't help them, because they may need to reorder charges based on random criteria or how a particular client requests to see their invoices. So it's not as easy as giving them the option of selecting different sort fields. I read on this forum that permanently resorting a file or select group of records involves exporting and re-importing the data. I didn't like the idea of involving an extra file or dealing with serial number …

Since I am continually explaining this concept, I thought that I might post a FAQ on how to create a unique*, non-sequential**, non-random*** automatically entered record ID for you to use as the Primary key in your files for a relational database system. I give all of my files a PrimaryID_key, which is an auto-entered calculation into a text**** field. The calculation is the concatenation of the Filemaker internal RecordID, plus the current Date and the current Time. Right( "000000" & Status(CurrentRecordID), 6 ) & "-" & Right( "000000" & Status(CurrentTime), 6 ) & "-" & Right( "000000" & Status(CurrentDate), 6 ) This ge…

[ NOTE: updated attachment is a few posts down ] Given FMForums has given me so much help, I thought I'd try to give back by contributing the starter template that I've built based on all the great advice given here. The About text in the database is copied below. Since I'd hate for someone to start with this and suffer from my mistakes, I'd greatly appreciate it if you smart guys could look the template over and tell me what you'd do different, or what things I've done wrong, or what things will be maintenance headaches, etc. I still have a few more days of work to do on it, incorporating a user login system, before I start replicating it to th…

Is there a plug in(s) and a script available that would let me replace line breaks, i.e., paragraphs to tabs in an external text file? Thank you DanielM

Here is my Aqua template I've played with for the past few months. Based on Joe Obegi's template that can be found at layoutmode.com. Feel free to add to it and post back (version control might be troublesome). There is plenty of fun stuff to add. -Different Aqua colours (this one is only graphite) -Field locking -Aqua-isk drawer graphics (my ones weren't good enough to include with this) -Super-smart tabs. ... anything else. AquaTemplate16.fp5.zip

Hey all, I've seen lots of people come up with different ways to output text files from FMP. The problem being the paragraph returns . Here is an xsl translator that can do this super simple. The instructions are commented in the file (view with note pad etc.) Charles TextOutput.zip

Edited :This file has been corrected.... Finds with relationships exclusively... This demo is an adaptation of a file I've made, which allows to find records which checkbox are checked according to Multiple Criterias. - Any ----> values A OR B OR C - Multiples ----> At least values A and B and C - Exact ----> ONLY values A and B and C The Exact Match is limited to a 10 checkbox checked matches at the moment. This file uses a repeating Value List and the user has a 19 checkbox value list that he can change according to its needs. You would just delete the previously entered records. The 10 checkbox limits is due to FM indexing li…

Hi I'm looking for a sample/tutorials to ASP + FM. I'm a newbies in FM Thanks

What about having scripts running dependantly of the number of mouse clicks... See attached a very little demo. I use it for either flag "one single record" of my found set or "all records". MouseClicks.fp5.zip

Hi, I am new to this forum, and I am not sure if this is the appropriate place to post this, but has anyone heard/see of a template used for ticket brokers, as in businesses that buy tickets to concerts/sports/theatre/etc, and sell them to consumers? Thanks for any help! -WSR

Hi all, I have seen quite a few posts on the board asking about date calculations so... This won't be a lot of use for those of you who are quite experienced, but for any newbies who need an example of date calculations then I hope this helps. Credit goes to Ugo for the calculation to work out the amount of months! Please feel free to update or add to this if you know of any other date examples which may be useful to newbies but please do not remove anyone elses work on the example without checking with them first. BTW is also contains the example of hiding fields in a portal which I found on this forum - sorry can't remember who I got this off th…

This is actually a re-post of an old message from the old days before we could attach sample files A few people have posted questions to FMforums about how to use multiple buttons to trigger a single script and then have that script take different actions according to which button was clicked. Currently, there is no Status(CurrentButtonName) function to determine which button triggered the script, but here is another possibility. You can use the following concept to create a dynamic vertical tool bar on your layouts. It's based on the idea of putting buttons in a portal. It's simple. Create a related file with a key field, a button name field and/or a button ic…

Inspired by Kevin's question, I am offering a CDML/Filemaker solution created in FMPro 5.0v3. This is just one method of tracking the number of web hits on a record. Take everything out of your Web folder. Take everything out of the attached folder and drop them in your Web folder. There are two db files: kevin.fp5 and track.fp5. In your Web Security.fp5 file create a record for kevin.fp5: all users, Browse. Create a record for track.fp5: all users, Browse, Edit. For newbies in particular: 1. You will find action tags (-find, -findall and -edit) used in links and forms. 2. You will see the display of data from certain fields and from single and multiple…

At Ugo's request I'm posting a link to this sample file: http://www.fmforums.com/threads/showthreaded.php?Cat=&Number=64213&page=&view=&sb=5&o=&vc=1 While you can use this to generate a multi-key on the fly, it wasn't really intended for that. For a multi-key, I recommend using the similar but simpler method in this thread: http://www.fmforums.com/threads/showflat.php?Cat=&Number=64912&page=2&view=collapsed&sb=5&o=186&fpart=1

Some People think that transparent graphics in FileMaker cannot be done. Here is a little tutorial to prove them wrong ... transparent_graphics.zip

(updated with new attachment 2 posts down) Hi, Control entry or duplicates on Names. This method allows to match errors when processing some Name entries. Associated with a Clairvoyance tool, there's little errors that wouldn't be catched IMO : Match : - characters inversions - characters substitution(s) - character addition(s) - character ommission(s) Thanks to Ernst for his help on this one. Originated from this post. Spell Checker, does this exist ? Anyone willing to look at the calcs and simplify them to be even more dynamic is really welcome. Thanks. SpellCheckerv3.fp5.zip

This is an adjustment of a first demo I've made some time ago. CheckDupes.fp5.zip

Hi, Here is one template (posted in response to Wendy T. for a "Layout Pop-Up contol". I'll progressively update it with other tools, when they are working. I just hope it may help someone else. I feel like in order to build good and efficient db, you first need to create a good and efficient db to manage the dbs ! Is there any other tools available BTW ? Developper.fp5.zip

Don't we all LOVE repeating fields, but hate that we can't set them easily ? Well, as this sample shows, it can be done! Sample could be expanded to set more then one field and more then 10 repetitions. Regards, Ernst. SetRepeatingField.fp5.zip

OK, it's a form of eye-candy but a lot of end users are well known to the way search engines on the web displays their find results. This sample file shows how to mimic that look & feel with filemaker. And it shows another good use of those dreaded repeating fields! Comments and questions are of course welcome. Ernst. WebstylePortal2.fp5.zip

Hi all I have searched for this demo but can not see it. I have a field comment, I want to setfield the date is red and the text is black. Can it be done??? Any suggestions will be appreciated. Thanks Anh Tran

At BradStanford.com you will find a selection of FileMaker tricks, demos, and an open-source soultion called AlloCater. AlloCater is a fully-function scheduling soultion for the food service industry. Other examples include my famous pop-down calendar, US Map made of filemaker objects, and more! Please come visit and be sure to download the free music before you leave! -Brad Stanford http://www.bradstanford.com

This may be useful in some cases. Thanks to Dj for his help. NotUsedVLv2.zip

Hi all, I would like to know if you guys have an example as sending email as a form or a letter to a person??? Since I know that email only text field or attached a file ... what I want to do is sending a form of cuurent record only. If you guys have, i love to see it. Thanks Anh Tran

I'm looking to redesign a very large multi-tab database and one of the things I would like to do is find a really cool interface. Does anyone have a file they can share with a very smooth/cool looking user interface (preferably with tabs)? Thanks.

The example custom login system that I posted in the samples forum seems to have caused some misunderstanding. It stores passwords and user IDs in an encrypted form. I never assumed that it would be difficult to get the encrypted passwords out of the file. That is the very reason that it was encrypted in the first place. By encrypting it, it becomes useless to the hacker. You might think that by getting this data, and knowing the algorithm that was used to generate it, that it is a trivial matter to create an inverse function to decrypt it. Not so! That is the whole point behind one way functions. They have no inverse. I didn

Edit -> Latest version is MultipleSelect v2, somewhere down this thread. This is a simplified example of how to implement multiple selection of records in Filemaker's List view and perform an operation on such selections. One of the advantage of this method is that it's completely 'network happy' as far as the selecting goes. When performing an operation on the selected records in a shared database there is of course a chance that a record is being modified by another user, in which case an error is reported. Error handling could be more elaborate then in this example. One slight disadvantage is that the maximum selection is limited. In th…

This file is a cut down version of a system used for allowing riders and spectators at a race (the Australian 24 Hour Mountain Bike Race in this case) to use computers around the race site to get direct access to their results. With over 3000 riders and spectators and over 6,400 laps - printing results was a never-ending task, so we went this way, using computers and data projectors. This sample presents 2 techniques. Hilighted Histogram. This allows riders to see how their own lap times compare with the rest of the field. They can see an on-screen histogram of lap times, in which their lap time is hilighted and their name appears in the header. Keybo…

(Edited::Little bug in this one. Try the newest version several posts down in the thread) Hi, Here are some portals to play with. Fixed, filtered and sorted, waiting for a new version of "Horizontal scrowl". Please tell of any problem you could discovered about this demo... Enjoy. PS: The Fixed Portal technique is an adaptation (using the Get Field function) of Giuseppe Pupita's fixed Portals that can be found at www.buliga.it. osx.zip

The following stysheet allows to insert FileMaker data into mysql. It creates the apropriate data structure from FileMaker METADATA and the INSERT statements. It does not, however, create the database itself, nor does it support container fields. Of course, you have to be careful to avoid special characters in your field names (no spaces, ".", ";", ",", "@" etc. allowed). USAGE: on the mysql pc, execute mysql databasename [-u<user[@host]>] [-p<password>] < output.sql If you want to keep your existing table, comment out the "DROP TABLE" and CREATE TABLE statements. This XSLT converts dates in M/d/yyyy (US) and d.M.yyyy (European) forma…

hello, enclosed you will find a similar solution to my EAN-13 and Code 39 examples. Included is an example product database that uses the solution to generate vector images of the barcode and pastes it into a container field. The barcodes & checksum calcs have been verified with a barcode reader. This is not the fastest solution, may not work with all readers (should though, but no warranty ...), so if you using barcodes a lot, get a font or plugin. However, as a free solution without the hassle of installing fonts or plugins, it's ideal for bound Filemaker apps. Enjoy UPCbarcode.zip

Not exactly an XSL file, here is a perl script that retrieves a tab delimited file from a web server running perl. this can be useful to get text files into FileMaker that are generated by a cgi guestbook or download counter, to access webserver statistics. you can also use it to update data in a bound solution without having to send & manually import the files without having to run FileMaker Web Companion on the server side. The script takes the first row of data as field names. Simply throw it in a perl-enabled, password protected cgi-bin directory, add a data file ("data.txt") and access via FileMaker XML import, http://yourserver.com/perl_directory/fmpxml.cgi…