Web Safe FileMaker Fonts
Arial Courier Georgia Helvetica Lucid Grande Times Trebuchet Verdana Hiragoni Osaka
Have you ever wanted to output quotes from a FileMaker calculation?
Have you ever wanted to output quotes from a FileMaker calculation? Here’s the simple way to do it: Ex. Johnathan “Doe” Shipley In the FileMaker calculation your would write the following: “Johnathan \”Doe\” Shipley” Your output will then have quotes.
Exporting RTF text from a FileMaker field
On one of the projects I was working on, I came across a problem were I had data to export that needed to be exported with the RTF formatting maintained. I was trying to create an index with some bolding etc. applied. After looking for plugin etc. to do this I came across a simple solution. If you’re using FileMaker on a mac you can use applescript to do this. (it may also be possible on Windows – I don’t know) Basically, what I did is create a loop to go through my records. Then essentially I copied the contents from the field and pasted them in my application. …
Hosted FileMaker File Make Pre Upload Tips
Before you upload your FileMaker database to be hosted check the following: Open File > Mange > Security Click Privilege Sets and the privilege set you want to edit. Edit “Access via FileMaker Network” to be checked. This will allow you remote access for FileMaker and FileMaker Go. If you want IWP, check the “Access via Instant Web Publishing”. Now your file is ready for us to host!
Using 360Works Plugins with FileMaker Server and IWP / XML
I have found recently that in order to 360Works plugins with FileMaker Server IWP (Instant Web Publishing) and XML they have to reinstalled in the proper folder on the FileMaker Server. Mac OS X: /Library/FileMaker Server/Web Publishing/publishing-engine/wpc/Plugins On Windows the path is: C:\Program Files\FileMaker\FileMaker Server\Web Publishing\publishing-engine\wpc\Plugins You may have to create the “Plugins” folder. Once installed, restart the server and you should be good to go.
Unicode Information
Numeric ASCII Win2 Mac2 Copy FileMaker related Dec Hex char Meaning1 Ctrl- Ctrl- Calc3 Exp. Imp. Comment 0 0 NUL Null @ 0 0 DO NOT USE literally in calculations! 1 1 SOH A “?” 1 1 2 2 STX B B 2 2 3 3 ETX End of text C C “?” 3 3 4 4 EOT D “?” 4 4 5 5 ENQ E E “?” 5 5 6 6 ACK F “?” 6 6 7 7 BEL Bell G “?” 7 7 Does not ring any bell today. 8 8 BS Backspace H H 8 8 Deletes character 9 9 HT Horizontal tab I Tab 9 9…
XML parsing error: whitespace expected
In one of the XML imports I had created for FileMaker I was continually receiving the following error: I couldn’t figure out what it meant? What was a XML parsing error: whitespace expected? I had rewritten my xsl stylesheet sever times with no success. Finally, on a hunch i removed all spaces from my xsl stylesheet name. Wola! no more error. (ex. ICD10CMChapterInfo.xsl vs. ICD10 CM Chapter Info.xsl)
Remove Duplicates from List() function
Let ( [ TheValue = LeftValues ( Text ; 1 ) ; TheCount = ValueCount ( Text ) ; NewText = Replace ( Substitute ( “¶” & Text & “¶” ; [ “¶” ; “¶|” ] ; [ “|” & TheValue ; “” ] ; [ “|” ; “” ] ) ; 1 ; 1 ; “” ) ] ; Case ( TheCount > 0 ; TheValue & RemoveDuplicates ( Replace ( NewText ; Length ( NewText ) ; 1 ; “” ) ) ) ) For more information: http://www.briandunning.com/cf/492
Creating QR Codes with FileMaker
I came across a good article on FileMaker and QR codes. “Using Google’s Chart API for QR Codes, Custom Functions and theScriptMaster plug-in by 360Works, I created the FileMaker Pro QR Code Creator. There are 2 options for displaying and creating the QR Code: Create QR Codes in Web Viewer Store a QR Code as a PNG file in a container field” Here’s the link. http://fmprodb.com/197/creating-qr-codes-with-filemaker.html
Sending Email via FileMaker and Gmail
Have you ever wanted to send email from FileMaker using Gmail. The example I use below was done to process email from a FileMaker script. After choosing the “Send Email” option you need to select “SMTP Server” from the the Send via: drop down. You then will have this window pop up. In the “Outgoing SMTP Server:” window type “smtp.gmail.com”. In the “Port:” window type “465”. In the “Connection encryption:” drop down choose “SSL”. In the “Authentication:” drop down choose “Plain Password”. In the “User Name:” field put your Gmail user name. (note: not your email – the example below is because I use a customized Gmail hosted email)…
