Community Videos, Tips, & Techniques, Articles.

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!

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