Community Videos, Tips, & Techniques, Articles.

We needed a solution to pass many parameters to a function, and to quickly retrieve them throughout the script. Our parameters also has spaces in them, so we used the "~" as a delimiter. We have a custom function called: getScriptParameter( parameter ; number) The code for the custom funciton is: If ( number=1;Left (Get(ScriptParameter); Position (Get(ScriptParameter) ; "~"; 0 ; 1 ) -1) ; If ( number=(PatternCount ( parameter ; "~")+1) ; Right ( Get(ScriptParameter) ; Length(Get(ScriptParameter))-Position ( Get(ScriptParameter) ; "~" ; 0 ; PatternCount ( Get(ScriptParameter) ; "~" ) ) ) ; Middle ( Get(ScriptParameter); Position (Get(ScriptParameter) ; "~"; …

open up Address Book and start editing someone's card. Select the Birthdate field and type "today" then hit Return. Next try "tomorrow", "next week", "last month", "next Tuesday". This code will replicate this functionality in FMP. Create a date field that does a GetAsDate(TextField) Create a field called "TextField" auto enter this calc, then uncheck the auto update. Let([ field = textfield; v_left = LeftWords(field;1); v_right = RightWords(field;1); words = WordCount ( field ); today = GetAsDate(Get(CurrentDate)); tomorrow = today+1; yesterday = today -1; thisday= DayOfWeek(today); NextDayNum= Case( v_r…

Trigger File Example (FileMaker Pro 7) Do you have databases that are set to open with limited access? Do you get tired of constantly holding down the Shift key (PC) or Option key (Mac) key and entering your username and password each time you want to access it with your admin level privileges? Why not create a trigger file to save you the hassle? This file demonstrates how to open a file or set of files that are designed to open with limited access. As a developer I am sure you are aware of how annoying it can get to remember to hold down the SHIFT (PC) or OPTION (Mac) key when opening a database to then enter your Admin level access details. …

This file shows how to make up for the inability of FileMaker to Set a Field by Name or to go to a specific Field on a Layout. Sorry - Mac only a all of these Scripts use AppleScript. In FileMaker 7, instead of the field SetField.fp5.zip

Attached please find the first version of an open-source electronic medical records database I am currently developing with a client. His was a single-doctor shop and he wanted something to help him track medical records as he grew, but could not afford several thousand dollars for a system he wouldn't understand. GPL Femur (GNU General Public License File Maker Electronic Medical Records) is my first pass at creating such a thing. It is built in FP5 to make it as backward-compatible with older equipment as possible and has four passwords with increasing access: (no password), user, admin, developer. I have a *lot* to learn and won't ask any specific questions, but I…

Here is a sample login system that I discussed here As presented, it isn't really a complete login system. It's just an example of using a one-way hash function to encrypt passwords. The included notes give a bit more information. login System.zip

In attempt to make it work on IWP have I been really easy on the scripting, hence the intensive use of repeaters (not my style, usually!!!) ...the template actually works as expected but the rendering of the gantt hogs a lot processor power. So any suggestions to simplifications would be recieved with pleasure! --sd simplify.zip

In some situations you may find that Importing records is much quicker than using the Replace function. In one of my solutions I needed to Replace 12 number fields with data from 12 calculation fields in the same table ("Customer" table). The process was incredibly slow so I tried a different method which was much quicker. I created a new table called "Temporary". This table has number fields with the same name as the relevant fields in the Customer table as well a field called CustomerID. I imported all the relevant records from Customers (the 12 calculations) as well as the CustomerID into the Temporary table. I then imported these back into the Customer table base…

I love the ability to use script parameters in FMP7 -- simplifies many things. However one thing I wanted to be able to do is to easily get specific parameters, either by number of by name. With Developer's custom functions it was straightforward to write a function that gets a parameter by name: Custom Function "ScriptParamByName(Name)": //ParamPair is a mapping of a parameter to a value in the format "name: Value" Evaluate(" Let([" & Substitute(Get(ScriptParameter);[":";"="]) & "]; "&name&" )" ) ------------------------------------------------- Calling a script with Parameters: Note - it is helpful to list the paramNames i…

Hi, Here's a quick setting I came up with which allow you to build custom Tabbed Interface according to the Account browsing. With this kind of settings, you'd probably reduce the amount of "checkings" and If scripts when opening a Layout. Actually, they would even not be offered any way to access data as the Tab doesn't show. Well, this one is just for the Main Navigation bar, but with some more settings, following this same logic, you can even have it work for Sub-Nav Tabs. I didn't tested it in a Multiuser situation, but as the Tab is built using a global Lookup (you may switch to a related field too if you prefer), it should be specific to each user a…

Here is a pair of custom functions that others may find useful. I've been aggrevated by the inability to remove the font/size information from a block of text in FP7. I need to do this with text that has been pasted in from a different application (and thus has an associated font/size), and would like to appear in different fonts/sizes on different layouts. In earlier versions, you could reset the text font/size by using Set Field ( TextField ; TextField ), but this no longer works. You have the option of resetting the font/size to one of your choosing, but if you want the text to appear in the font/size as defined in the current layout, you're out of luck. …

7 helped reducing the amount of workarounds, but John Mark Osborne's visibility trick probably survived the upgrade. Here's an adaptation of his technique to provide hided selection lists ClickAndGo.zip

I was asked to calculate some median values and was surprised that as of Filemaker 6 (version I use - not sure about 7) has no built in function to calculate the median value of a found set. Hopefully this file can be of use to someone who needs to do the same. Also, if something is incorrect in the script, I would appreciate some feedback! median.zip

Regarding this Post click See sample it's not pretty but it was easy. Revision 2 posted 11/27/04 , Takes care of creating friends on couner records FriendsofVolunteers.zip

This is a further enhancement of the Find, with a twist. It combines a regular "filter by category choice" with a later "find with category." It is for data which is categorized, and which does not lend itself to an alphabetical filter (such as people's names do); but which may lend itself to an optional Find, once the data has been narrowed down by a preliminary category choice. There's actually some documentation in the file. It is especially built for Instant Web Publishing. It has not been extensively tested, so let me know if something is kinky. FoodsIWP_wFind.zip

Here is a first set of 10 step by step dissection of what repeating fields may be used for with FileMaker 7. I have 3 x 10 others to post once I will have completed other "homework", but these should be enough as a start to keep you interested in this repeating fields survival.

This is the simplest file to try to solve a long and winded discussion Here TimeTest.zip

Here's a simple custom function that allows you to search for strings of wildcards (and only wildcards) in a block of text. It replaces all numbers with "#", and all major punctuation with "/". I wrote it in response to a question for a way to see if a block of text contains a social security number, which you can search for as "/###/##/####/". It may need to be tweaked for specific purposes, but I imagine some other people might find it handy. The basics of the function are also written in a calculation field, for those of you without Developer and can't read the custom function. Enjoy! -Terence PositionWildcards.zip

I was looking online for a solution to the following problem, didn't find an answer, created this myself, and thought others would be interested. I built it in FM7, but it could be done, with more work, in FM6 also. The FM7 feature used is recursive custom functions. Here's the scenerio: You have two entities that have a many-to-many relationship, such as Users and Groups. A user can belong to many groups and a group can have many users. To enable your users to edit these relationships, you are providing a selection portal that shows the groups a user belongs to and the groups available. How to make the groups list show only groups that have not already been added to…

Just wanted to share my database with the forum to get any feed back that the members of the group may have. The database has two logins. Admin and Test. Both logins do not have any passowords. Please fell free to pick it apart. I have inculded with this file the CalSnap (www.briandunning.com) and an AppleScript that I found on the Net and modified for my use. This is my first attempt at using filemaker pro in creating a database from the ground up. It is still a work in progress. As I find out more information about FMP I try and add them to the database. If you have any suggestions about the "operation" of the fileds please let me know. I guess in the end this…

Hi Forum, Even though I've just been using FMP a short time I've gotten a lot of priceless help here and so rather than just take, take, take, all the time I thought I would post a humble little solution I was able to come up with on my own. I'm sure that there are other, more elegant approaches to the problem and I would be curious to see them... I need to send dated forms to Latin America and so Iwas looking for a way to translate the date into Spanish. (While in the US we use a MM/DD/YYYY format, in Latin America they use DD/MM/YYYY, so I was going to need to manipulate the date info at some point.) So I added a date field (with white text) called "DAT…

About Files Index The Files Index is a simple database designed to organize the tip files available from the FileMaker community. Formally, I little beat modify original file: Calcs Index ( John Mark Osborne/ Database Pros - The Philosophy of FileMaker Pro DevCon 2004 presentation ... this gay is really one of the Best - http://www.PhilosophyOfFileMaker.com, add few fields, scripts, one custom function (for sort portal - based on another guru: Matt Petrowsky, ISO Productions, Inc. http://www.filemakermagazine.com and little beat modify layouts and that FilesIndex.fp7.tar

Two Tricks: 1) To get a cool looking Title on a layout, use MS Word, WordArt Feature 2) Make files that contain nothing but Script runners. For instance I have file caled "End of Month", and it has a giant button, I press that, and performs all scripts needed to do the end of month. I kept forgeting in which order they were supposed to be in, befoe I figured this one out. To keep this going. I'm looking for any good Shortcut Keys in Filemaker Any one have a fav? Mine... is pressing CTRL, and then using the scroll mouse, to adjust veiw.

About Files Index The Files Index is a simple database designed to organize the tip files available from the FileMaker community. Formally, I little beat modify original file: Calcs Index ( John Mark Osborne/ Database Pros - The Philosophy of FileMaker Pro DevCon 2004 presentation ... this gay is really one of the Best - http://www.PhilosophyOfFileMaker.com), add few fields, scripts, one custom function (for sort portal - based on another guru: Matt Petrowsky, ISO Productions, Inc. http://www.filemakermagazine.com) and little beat modify layouts and that

Hi, This is an update to a former article in this section. Publishing a workable demo for this technique happened to be more tedious and time consuming than I originally thought, so pardon me if it isn't very transparent and fully working. Though the files are fully unlocked for you to dissect. I'm succesfully daily implementing this technique in 2 solutions I've been developing before 7 was launched. Each steps in the SmartFind.fp5 file has a corresponding pdf file that dynamically opens up for some brief guidelines. Two stored finds are now included in this demo, but because of System settings, you'd have to Save the following files as clones …

This very basic example file shows how to use applescript and Mac OSX shell script commands to write data directly to the file name and folder name of your choice. In this example, all exports go to the desktop but you can designate a folder if you want; and the folder will be created if it does not exist. You can write text, XML, HTML, etc. See example records. Of course you can use standard filemaker techniques to manipulate the content of the exort file, use substitutions on a global field, perform applescripted XML maniupulation, append date to existing files, etc. Bruce Robertson ExportByShell.zip

G'day Strewth mate, now, I am not a huge fan of Freehand but, yesterday I found that I could create pretty cool buttons with freehand and by working with vectors and using EDIT>COPY SPECIAL... copy as PICT, I could simply paste my non-rectangular buttons into FM, with transparency - fair dinkum cobber! Now fair crack of the whip mates... I've tried using Photoshop, especially to add drop shadows and stuff like that, but I found myself always having to match BG colours in PS with BG colours in FM, because I couldn't just drop irregular shapes into FM as a 'copy' without an annoying white background. It was a right bugger mates! What I'd really like is so…

This is a technique I came across some time ago that I haven't seen elsewhere, so I thought I would share it. Often I need to know if a field is one of a number of options and perform something if it is. The straight forward way to do this is something like: ( Item = "H100" ) or ( Item = "H110" ) or ( Item = "B100" ) or ( Item = "B110" ) I have one calculation in a solution I'm currently working on that has something like 20 possibilities. I found that I could use the PatternCount function to return the same results as above in a more compact form: PatternCount( "H100 H110 B100 B110", Item ) Assuming that Item can have only one of the…

Hi, Does anyone has a small example-file which shows you how to split the data from the layouts,how you can put data in those sytems and how you can find data in it (=fast finding) Thanks, Bruno

For those of you who, like us, are designers and developers...I thought I would post a handy little chart of the filemaker pro Web palette with it's HTML equivalent beside it. Hope you find it useful. filemaker6palette.pdf

Hey With the last update, time naturally comes back for some design. And with FM7 new "Time" selection, it becomes quite real... More to come (even the "active/not active status") obviously. PS depending on your system, you could set the clock a little less. With ".25", it's just cleaner here. Metal.zip

Hi, Here's one way of implementing a Dynamic sort (including headers) in v7 with only one script and very few added fields. Enjoy. Edited- sampler updated

Requires FileMaker vs. 7 ... Full Access is Account Name and Password of: Admin Restricted attribute access is Account Name and Password of: Restricted How does one control Users wanting to apply different text attributes to field data? Let them waste time selecting colors and fonts, only to strip them by using Auto-Enter (Replace) on every field? Let them run free and threaten them if they change the attributes? Totally remove menu text attribute options (either via Privileges or plugin)? I think there are simpler ways... Turn it over to Management. Let them decide which fields can be stylized; what font sizes, colors etc. may be used on a field-by-f…

I've extended one of my custom function examples, and I think I may have stumbled onto something that could actually be useful. ( Custom Functions are a FM Developer 7 feature only, but you can see it work if you have FM7.) It extracts all italic words from a piece of text into a newline-seperated list, which could be used to drive a portal to show similar articles, or a glossary of terms. You can see it in action by downloading the Style-Manipulation example from my website: http://www.spf-15.com/fmExamples/

I have a system that needs to compare the before and after values of a bunch of fields. There is a calc field, cFieldValues, that strings together the important fields and separates each value by a delimiter character and carriage return. When the user clicks the button to enter the edit mode screen, the button script puts cFieldValues into a global gStartValues. When the user saves the record, the button script has an IF statement that compares the current cFieldValues to the global with a simple "=" operator. If there are changes to any field values, other stuff needs to happen. This seemed like a sure thing until I began to see records with more than 255 characte…

Hi, Posted here just as an answer to someone's post on another Forum. Might interrest someone though here too. How to validate that one entry has already been computed in a repeating field, by either a validation calc or a script that build a dynamic value list. HTH ForKjoe_ValidDupeRep.fp5.zip

This is similar to the original example. But with some drastic alterations so that it works with Instant Web Publishing. LawCasesIWP.zip

Looking for graphics for your solution, Why recreate the wheel? This little utility will allow you to look at the icons and graphic images found in every app on your machine. Where you can then export and reuse for your one solution. http://www.mikematas.com/Software/

This example file is similar to my earlier one, but much simpler. Instead of setting the chose value into a new record in a "join" table, this one just goes to the chosen record. self_Client.zip

Originally by Jack Karnes (special thanks) , modify by INO You have more then 1.200 locations all the around world with longitude & latitude positions ! When choose two locations, automatically calc distance in miles & kilometers ! For non-commercial use free ! For commercial use ask for fee ! Happy FileMakering INO DistanceFinder.zip

Here an older zip code file I've been using. Not sure where I got it, but it's been very usefull. I think some file syou might be able to buy will have all the fancy zip +4 and such, but this one gets me by.

I've always loved using perl's regular expressions for finding matching bits of text. Now, with FM7 and custom functions, I was able to re-create a (somewhat simplified) version of perl's regular expression matcher completely with custom functions. You can download the file (which includes an explanation of the supported syntax) from my website: http://www.spf-15.com/fmExamples/ (see "Perl-style Regular Expressions") To use it, you call the RegexMatch custom function like so: RegexMatch( "[email protected]"; "((w+)@w+.(w+))" ) The result is a property list that pulls out the grouped pieces, or empty to indicate no match was possible. In this case…

The attached file demonstrates simple integration of unix shell scripting with FileMaker. It takes a list of values, sorts them, finds the unique values, and counts the occurrences of each unique value, and presents the top 5 to you. By itself this is a minor trick but it has interesting implications for reporting and other applications. It requires a Mac running OSX. When you try it, try using PartNumber as the selected field for your query. Note that the file will also summarize values from a second file if you have any other database open. The applescript looks like this: choose from list (get name of every field) set whichfield to item 1 of …

[DOUBLE-POST] Someone had posted a question a while back (maybe a month or two?), asking what error 6 means when trying to access a file across a network. I can find no documentation for this error, and it seems to be an FM error rather than a Windows one, so i will pretend to be an error 6 authority. I think i have an answer, but i can't find the original post. So here goes (hope you're still on the forum, bud). I hope the pooh-bahs will forgive me for double-posting, but i'm not sure where this should go. I have a local file that looks for a database on the network called "Opener.usr". Last night, running that file, i got an Error 6. When i open the Ho…

Does anyone know of a cash register solution, either open source or commercial?

This sample demonstrates how to manage your referenced images without need of any plugins! The same concept applies to any file-type management! You can: - insert an image and automatically have it "referenced" in the DB - have as many "larger" images that do NOT need to be stored in the container field - images are viewed by your default image viewing software for this image tyle (depending on your file assosication with particula fiel type eg. "all JPGs are opened with IE") - insert ANY TYPE of file that need "other files" associated with the same record - it DOES NOT require any Relationships NOR multiple Container fields Let me know…

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