Problem: I have a hand held device that scans those graphic color barcodes on all packaging. There is a track device that I can use that will slide the device automatically. This track device functions by taking ascii code through a serial port. I need to get this thing to work in FileMaker on a Mac. So no terminal programs, etc... What...
I have an ODBC DSN setup to hit a Filemaker database from my ASP.Net application. I'm trying to form a valid query where the column name has spaces in it. In T-SQL, you would enclose it in []. But I fail to get it to work in this case. Here's a valid query: select * from ua_inventory where location like '%a%' But this is not: sele...
I am compiling a plugin for FileMaker using Xcode. I get no errors or warnings, and my 'target' is my FM/Extensions folder. Everything works well on my computer. It installs and then when I open FileMaker/Preferences/Plugin it is listed like it should be. Problem: I copied the project to another computer and I get the same results exce...
I have an ASP.Net application that needs to display an image that is stored in a Filemaker Container field. My query statement looks like: select GetAs(Image, 'JPG') from UA_Item_Pictures where "Stock Number"=33989 and ImageOrder=1 According to the documentation: The possible file types (case sensitive) you can retrieve from a contain...
Does anyone know of any open-source FileMaker plugins? The only one I currently know of is Keystone (http://code.google.com/p/keystonefilemakerplugin/) Just wondered if there were any others? I've created a few of my own FileMaker Plugins for Windows, but am struggling on OS X so was hoping to be able to see some working examples to...
Is anyone familiar with installing plugins in FileMaker? I created a package in PackageMaker using a new plugin. Everything seems to install correctly, I can see the new plugin in the extensions folder, but when I open FileMaker and look at the list of plugin it does not appear. Anyone know what I'm missing? I've been focusing on per...
I'm using SSIS and trying to import data from Filelmaker into SQL Server. In the Solution Explorer, I right click on "SSIS Packages" and select SQL Server Import and Export Wizard". During the process, I use my DSN as the source, SQL Server as the destination, use a valid query to pull data from Filemaker, and set the mappings. Each t...
I want to add a second Address field into this custom function (ie. Apt. #101). If you wanted, you could explain how the Case(not IsEmpty works and I would be willing to attempt to add the second address field in myself... Let( [ x1 = Name; x2 = x1 & Case(not IsEmpty(Address); Case(not IsEmpty(x1); "¶") & Address); x3 = Case...
I want to run a script when a field is changed and with script triggers I think it's possible. Bu I don't know how to.. Can anybody please help? ...
In filemaker I have a portal and I want to click one of the items and switch layout and view the clicked item. How do I that? ...
I'm trying to copy some field values to a duplicate database. One record at a time. This is used for history and so I can delete some records in the original database to keep it fast. I don't want to manually save the values in a variable because there are hundreds of fields. So I want to go to the first field, save the field name and v...
Seems like a simple question, and it probably is, but for some reason I just can't get it to work for me today! I want to write a simple calculation to return a value based on a heirarchy of fields. If the first field is empty, I want it to return the second, and if the second is empty, the third. I have tried the following but it only ...
I'm currently writing an applescript to be run within FileMaker. I need to tell filemaker what the name of its application is (FileMaker Pro or FileMaker Pro Advanced or whatever) so that I can within ANOTHER applescript within filemaker I can say "tell application filemaker" I currently have a script that figures out the name of the ap...
Hey! So I'm transferring an old filemaker database to MySQL and some repeating fields are causing me some problems. I've read that the ODBC standard support those fields, only when their types is "Text" and that each repetition is concatenated with a certain delimiter (see page 47 (PDF)). However, I just can't reproduce this. All I get...
How do you define modular scripting in the FileMaker context? I am not providing my definition yet on purpose. I want to know what you think. Thanks! ...
I have published a layout in XSLT format with Filemaker. When a user access this page, he will be prompted for his login details. I want to display his login details after he logged in successfully. How do I accomplish this? ...
Hi, I'm trying to create a Table of Contents for a small publication using Filemaker 10, since that's what the data has been stored in previously. I'm able to generate page numbers, add heading to the TOC and pretty much everything else I've needed to do - one thing withstanding. Our designer wants to fill each TOC line with "." to ma...
The only way I can see to get a total record count necessary for setting up some sort of pagination mechanism would be something like: $fileMakerObj = new FileMaker( /* credentials redacted */ ); $fc = $FileMakerObj->newFindCommand('someLayout'); //Get max Record count for someLayout $fc->setRange(0,0); $result1 = $fc->execute...
Hi I'm new to filemaker - liking it, but taking a while to get used to it I'm creating a solution where customers checkin with their ID card. The first time they do this, I need to link their card to their user record. I have a user table, and want to click a button on the layout for this table to set the ID of a card. The ID of the...
Background: Filemaker Pro 10+ have gained functionality to send emails using SendMail via SMTP. There are expensive (relative to total FileMaker licensing cost) plugins that can do SMTP on FMP earlier than 10, but that investment is not an option. I have set up a network that I'm managing (I'm not mainly a developer) to use Thunderbird...