Act NOW if you want to save money on your FMPug Membership Currently 39 slots left for $25 hurry buy b4 the price goes up! http://www.fmpug.com

Hello All: This is a puzzle caused by the way FMP internally formats dates. If you're at all conversant with the issue, you know that FMP's default format for all dates is based on the date f ...

Hello everyone, I have a calculation field called "Total Payment" that I want to do two things: 1) Sum all the values of a certain field 2) Take that result and, if the result is less than ...

Has anyone successfully installed FileMaker (any version) within Ceedo (www.ceedo.com)? Ceedo is an app virtualization framework that allows you to make many applications portable. It's kind of ...

I need to determine the types of pic files a user is importing into our app. We only allow "Insert Picture(Reference)" into our DB because we don't want to jam up the DB. The reason being is th ...

A client, given a birthdate, wants to know the age of contacts in Year, Months, and Days. I built a function that I thought covered all the bases, but in testing it I kept getting results I ...

OK here is the challenge, should you choose to accept it. Putt a text block on a layout, with text in it (say, "Crocodile Dundee"). Define a tooltip onto the text block: I want the text to ...

Here's a new puzzler.... Build a Rot13() custom function. It should take a string and rotate each letter 13 places in the alphabet. Wiki Rot13 for more details. The function should only ...

Here's the challenge... Write a script that populate a field (TABLE::Result) with the numbers from 1 to 100 with these conditions: -for multiples of 3 print “Fizz” instead of the number ...

Hi guys I have a field which for example look like this: 1.22 45.1 43.45 I need to extract what's in front of the "." to one calc field and whts behind to another calc field for sorting ...

Hi Everyone I am in need of a script that I just can't figure out. I have a field1 with this jim steve mac sue In field2 I need the output to be jim jim steve jim mac jim sue ...

So I have this script........ Code:   Set Variable [ $filename; Value:GetValue ( Get ( ScriptParameter ); 1 ) ]  Set  ...

I am trying to figure out how to XOR two bytes together in FileMaker. Example: I start with the binary values 49 and 50 which would be represented in binary as 00110001 and 00110010. I w ...

Hi guys! Hope this is the right forum. My table called CASES holds all the cases we've done for clients this month. Here are two of the fields it has: DATE_IN (date) UNITS (calculation, ...

Is it possible to restrict the result of a standard (not auto-enter) calculation field to unique values only?

I've been trying to post this question for a while, but I can't figure out how to explain it...so I'll just give it a try...I hope it makes sense. I'm in advertising. I build pages for ads &am ...

I have a large file (currently 90k records) the gets added to each week (~9k records ) On import I am checking to see if the email address is the first occurrence in the database. Currently t ...

Hope this is the right forum... In FileMaker 6 through 9... if one has existing Sorts that are based on relationships, it makes the existing Sort names in the left side sort box too long to read ...

This has to be easy. database is in list format. I have an auto enter field set up. I need it to auto enter the numerical position of a record based on sorting criteria. It would list numbers 1 ...

I'm working on taking data from an external mySQL data source and formatting it into a format I can use and display in FileMaker. The main table has two fields "items" and "ref_number". The field ...

Im trying to create a single script that could send me a mail with a lot of info based on the layout the user is currently on. For the moment i have like 18 scripts and if i have to make a ch ...

Hi everyone, I'm a little lost on even how to begin doing this. here is what I need to do: - Need to add to a table (using a script) a 'block' of serial numbers. - Serial numbers follow a ...

I recently looked at SeedCodes new calender and it got me to thinking. Variables can be powerful and it reminded me of a project I did written in Lua using lua tables. I guess my questions are, i ...

Hi, I use to go in "Button Setup" select the "Open URL" option, specify the URL using a calculation where I put a field name. In that field name there was a "file path" store. Something like t ...

I am very new to Filemaker and am attempting to create a lending library. I work for a small television production and am trying to manage the props that go out to the various set/bays. My prob ...

Hi there! I have a filemaker solution where a Cases table is related to a Persons table through a portal, to generate a dynamic value list for persons of the same case. From the Cases table al ...

I would like a replace calculation to divide a found set of records into user determined batches. Here is my calc Int ( Get ( RecordNumber ) / $div ) +1 This works great except the first gr ...

I have this task, I need to be able to write records to a history file everytime a user clicks on a specific button. Basically these records are for verification/evidence incase one party comes ...

Hi all, this might be a bit of a stretch but I'm looking for a way to access a filemaker database file and performs queries or even make modifications like perhaps changing a database referenc ...

I am looking for a way to automate taking Chinese simplified text in one field, converting it to Chinese traditional text, and copying it into a new field. I have a rather large FMP 8 database th ...

Hi I am a relative newbie with file maker... We quite a few price lists here based on simple calculations .... Example... cost x markup .... I am trying to get a round function that looks at onl ...

Hi everybody I am tmaking af database solution for a Faroese customer. The faroese has special characters such as "á". I would like to make a simple calculation, which returns a number based o ...

Hi all, can someone help towards the following: I have a simple table with a description field (text) relatively small in length, that I want to use in order to produce automatically a list ...

I am trying to fill web form fields in my IE browser, using the fields from filemaker. Is there a way to populate this data into the ACTUAL fields IN the browser. Once I review them on the scre ...