Our Blog, Filemaker only, Xojo only, Archive (older), Follow us on Twitter, Xing, LinkedIn or Facebook.


Sign up for MBS Newsletters


You can sign up for MBS Newsletters on our website.

We keep you informed about new plugin versions, local events, conferences and special offers. Emails are sent out in average once a month, so it shouldn't fill your mailbox.

If you provide an address, we can make sure we include you for local events in your area. Like when we attend meetings, we usually email people 100 km or miles around to let them know we are coming.

Looking for a trial license key?
You can get one here: Trial License Request Form.

MBS FileMaker Plugin, version 8.0pr9


New in this prerelease of version 8.0 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Circle crop images in FileMaker with MBS Plugin


Once again a client asked for some help with image editing in FileMaker. An imported picture should be scaled to a given size and than be cropped to a round image. Of course there are no round images, just images with alpha channels to give the illusion the image may be round.

We created the following example script to first read in the image from a container field. We create a temporary image with transparent background of the source size and composite the existing image into that. Next we scale it to the requested size. 

Next we create a new image where we draw the cirlce for the mask and we apply this mask to the scaled down image. Next we compose this image into our final image to apply the mask and write it to a container as PNG image file: 

# Read in source image

Set Variable [ $SourceImage ; Value: MBS( "GMImage.NewFromContainer"; Clip Image::Input ) ] 

Set Variable [ $sourceWidth ; Value: MBS( "GMImage.GetWidth"; $SourceImage) ] 

Set Variable [ $sourceHeight ; Value: MBS( "GMImage.GetHeight"; $SourceImage) ] 

# Scale to dest size

Set Variable [ $sourceSize ; Value: If($sourceWidth > $sourceHeight; $sourceHeight; $sourceWidth) ] 

Set Variable [ $destWidth ; Value: GetAsNumber ( Clip Image::Width ) ] 

Set Variable [ $destHeight ; Value: GetAsNumber ( Clip Image::Height ) ] 

Set Variable [ $destSize ; Value: If($destWidth > $destHeight; $destHeight; $destWidth) ] 

Set Variable [ $tempImage ; Value: MBS( "GMImage.New"; $sourceSize & "x" & $sourceSize; "transparent" ) ] 

Set Variable [ $r ; Value: MBS( "GMImage.CompositeXY"; $tempImage; $sourceImage; -($sourceWidth-$sourceSize)/2; -($sourceHeight-$sourceSize)/2; 1) ] 

Set Variable [ $r ; Value: MBS( "GMImage.Scale"; $tempImage; $destSize & "x" & $destSize ) ] 

# Build mask

Set Variable [ $clipImage ; Value: MBS( "GMImage.New"; $destSize & "x" & $destSize; "transparent" ) ] 

Set Variable [ $r ; Value: MBS( "GMImage.SetFillColor"; $clipImage; "black" ) ] 

Set Variable [ $radius ; Value: $destSize/2 ] 

Set Variable [ $r ; Value: MBS( "GMImage.DrawCircle"; $clipImage; $radius; $radius; 0; $radius ) ] 

# Apply mask

Set Variable [ $r ; Value: MBS( "GMImage.CopyChannel"; $tempImage; "Opacity"; $clipImage; "Opacity") ] 

# Create destination image

Set Variable [ $destImage ; Value: MBS( "GMImage.New"; $destWidth & "x" & $destHeight; "transparent") ] 

Set Variable [ $r ; Value: MBS( "GMImage.CompositeXY"; $destImage; $tempImage; ($destWidth-$destSize)/2; ($destHeight-$destSize)/2; 1) ] 

Set Field [ Clip Image::Output ; MBS( "GMImage.WriteToPNGContainer"; $destImage) ] 

# Memory cleanup

Set Variable [ $r ; Value: MBS( "GMImage.Destroy"; $SourceImage) ] 

Set Variable [ $r ; Value: MBS( "GMImage.Destroy"; $tempImage) ] 

Set Variable [ $r ; Value: MBS( "GMImage.Destroy"; $destImage) ] 

Set Variable [ $r ; Value: MBS( "GMImage.Destroy"; $clipImage) ] 

 
As you see this is a multi step approach and looks complicated, but sometimes you need to prepare an extra image for the mask (or alpha channel) you like and compose things together as needed.

You can extend this and draw some text on top, some border around or watermark it with a logo. 

PS: Looks like MBS FileMaker Plugin has more GraphicsMagick functions than FileMaker has built-in functions for calculations.


Prices for FileMaker Developer Conference 2018


As stated in the FileMaker community, registration will open in February. The training on Monday 6th will cost $399. Keynote will start later that evening, probably at 6pm and is followed with the welcome reception.
Prices for the conference are $1299 Early Early Bird - through March 15, $1399 Early Bird - through May 31 and $1499 USD Standard.



August 6-9, 2018 | Gaylord Texan Resort | Grapevine, Texas

This is a fantastic conference hotel with 1500 rooms, 10 restaurants, several pools indoor and outdoor. And as may know this was my guess for the conference hotel.

Registration starts end of February 2018. Rooms can be reserved on the hotel website ($189 +tax per night). As you can cancel rooms and they may run out of them, you better reserve now a room and block the week in your calendar! See you there at the MBS booth.

FileMaker und Xojo Stammtisch in Passau


On my next visit to Passau, I'd love to make another FileMaker & Xojo developer meeting:

Wer hat Interesse an einem FileMaker Entwicklertreffen im März 2018 in der Nähe von Passau?

Einfach in gemütlicher Runde treffen in einem netten Restaurant und beim Abendessen was über FileMaker und/oder Xojo schnacken. Vielleicht habt ihr ja auch Fragen und Probleme, wo ich helfen kann?

Zeit wäre ca. 18 bis 22 Uhr, so dass man auch später kommen oder früher gehen kann.

Bei Interesse bitte in die Liste eintragen.

Falls sonst noch Bedarf an Schulung, vor Ort Entwicklung oder FileMaker/Xojo Hilfe besteht, bitte wegen Terminfindung bald melden.

Farm Time, The Mini Movie


FileMaker Inc. started a new ad campaign #FarmTime to promote the FileMaker brand:

MBS FileMaker Plugin, version 8.0pr8


New in this prerelease of version 8.0 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

FileMaker Stammtisch in Hamburg


On my next visit to Hamburg, I'd love to make another FileMaker developer meeting:

Wer hat Interesse an einem FileMaker Entwicklertreffen am 27. oder 28. Juni 2018 in Hamburg?

Einfach in gemütlicher Runde treffen in einem netten Restaurant und beim Abendessen was über FileMaker schnacken. Vielleicht habt ihr ja auch Fragen und Probleme, wo ich helfen kann?

Zeit wäre ca. 18 bis 22 Uhr, so dass man auch später kommen oder früher gehen kann.

Bei Interesse bitte in die Liste eintragen.

Falls sonst noch Bedarf an Schulung, vor Ort Entwicklung oder FileMaker/Xojo Hilfe besteht, bitte wegen Terminfindung bald melden.

MBS FileMaker Plugin, version 8.0pr7


New in this prerelease of version 8.0 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

FileMaker Developer Meeting for Denver


Due to the Xojo Developer Conference, we will come to Denver, Colorado in April 2018.
So let's organize a FileMaker developer meeting!
Anyone interested?

Currently we'd like to know if there is interest for a dinner meeting or more?

Please fill the survey.
Dates is around 20th to 28th April 2018 on one of the evenings.

For a dinner, we would just meet in a restaurant and chat. If we get a bigger group, maybe get a separate room and with a screen and projector, so you an show something if you like.

If you are interested in some private consulting or training, let me know and we can arrange an appointment.

Disclosure Triangle in Button Setup dialog


The normal button setup panel in FileMaker 16 looks like the left picture here:



With MBS Plugin we optionally change the colors to be more black/white and make the panel resizable. This looks like this for version 7.5 in the right panel.

The disclosure triangle for the panel is difficult to see, so for the upcoming version 8.0, we color it light gray:



We highlighted the triangle in the right screenshot. Enjoy!

The dialog is localized and may look different depending on your language. But as we know the plugin function work independent of the texts, so it should work fine in any language.

FileMaker Developer Meeting for Stockholm


Due to the CURL conference, we will come to Stockholm in April.
So let's organize a FileMaker developer meeting! Anyone interested?

Currently we'd like to know if there is interest for a dinner meeting or more?

Please fill the survey.
Dates is around 12th to 16th April 2018 on one of the evenings.

For a dinner, we would just meet in a restaurant and chat. If we get a bigger group, maybe get a separate room and with a screen and projector, so you an show something if you like.

If you are interested in some private consulting or training, let me know and we can arrange an appointment.

MBS Booth for FileMaker Developer Conference 2018


Today we signed up for a booth for the upcoming FileMaker DevCon 2018. Please come by and say hello.



August 6-9, 2018 | Gaylord Texan Resort | Grapevine, Texas

This is a fantastic conference hotel with 1500 rooms, 10 restaurants, several pools indoor and outdoor. And as may know this was my guess for the conference hotels. As FileMaker DevCon grew to 1600 attendees, you need big facilities. FileMaker loves to use the Apple rates in Marriott hotels and as you may know there are not many huge hotels available for such a great event.

Registration starts end of February 2018. Rooms can be reserved on the hotel website. As you can cancel rooms and they may run out of them, you better reserve now a room and block the week in your calendar! See you there.

MBS FileMaker Plugin, version 8.0pr6


New in this prerelease of version 8.0 of the MBS FileMaker Plugin:
  • Fixed bug search for FileMaker 15 to redraw table when editing search text to give instant search results (failed only in FMP15).
  • Added Socket.LocalPort and Socket.LocalIP functions.
  • The preferences dialog now warns if you run a beta version after release.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Happy new year 2018


We wish everyone a great start in the new year 2018.

We start right away in the next days with a new beta of our plugins. MBS FileMaker Plugin 8.0 is coming soon and we enter the 12th year of development. For Xojo I am now addicted for 20 years and the plugin finally turns 18.

On traveling the schedule is pretty full for 2018 already. Beside Xojo and FileMaker events, you may meet me at other places, e.g. at the curl-up 2018 in Stockholm.

If you know another conference, let me know:
MonthXojoFileMaker
Januar
Februar
MarchXojo Meetings in Toronto and MontrealFileMaker Conference in Montreal
MBS FileMaker Plugin Workshop in Hofheim &
FileMaker Stammtisch Rhein-Main
AprilXojo Meeting in StockholmFileMaker Meeting in Stockholm
Xojo Conference in Denver
MayXojo Meeting in ViennaFileMaker Meeting in Vienna
MBS FileMaker Plugin Workshop in Hofheim &
FileMaker Stammtisch Rhein-Main
Various FileMaker Events
JuneXojo Meeting in BerlinFileMaker Conference in Berlin
JulyXojo Meeting in DallasFileMaker Meeting in Dallas
AugustFileMaker Conference in Dallas
SeptemberMBS Xojo Conference in Munich
MBS Xojo Training days
OctoberEuropean FileMaker Conferences
FMK and others
November
DecemberMBS FileMaker Plugin Workshop in Hofheim &
FileMaker Stammtisch Rhein-Main
Not everything is planned or announced yet and some things may get moved or cancelled. But if you are interested in joining, I'd be happy to welcome you at one of those events.

FileMaker Version used


As you may know, we collect some statistics about plugin usage and today I’d like to show the versions of FileMaker used with MBS Plugins:



So we have about half of our users have FileMaker 15. FileMaker 16 is coming We currently have more users with FileMaker 11 as with FileMaker 16, but that will probably change quickly. As you may expect, we do still support FileMaker versions down to version 7 on Windows, but don’t test ancient versions any more (unless someone tells us about an issue). (more)

Three days left for DynaPDF Christmas Sale


Three days left for the DynaForms' Christmas Sale for this year:

Christmas Special: 25% Off on anything!

As a thank you for the good collaboration and your trust, you get 25% Christmas Discount on anything til the end of the year!

I wish you and your family Merry Christmas and a successful new year.

With kind regards

DynaForms GmbH

The MBS online shop is updated and we reduced all our DynaPDF prices by 25%. So if you need a new license or updates for up to five years, please order. If you have questions, please do not hesitate to contact us.
Order for Xojo - Order for FileMaker

LogicalDOC Webservice


Some of our clients use the Loigcal DOC software, a document management system.

They do offer a webservice API for their system, so you can connect and query documents from FileMaker or Xojo solutions.

Today we wrote a FileMaker script to query a file given ID and login to the server:

(more)

Merry Christmas


Frohe Weihnachten und ein gutes neues Jahr!

Merry Christmas & Happy New Year

Joyeux Noël et Bonne Année

Buon Natale e Felice Anno Nuovo


Franziska, Sebastian, Michael, Monika & Christian Schmitz

Search in FileMaker Calculations and Custom Functions


Monkeybread Software got you a Christmas present for all FileMaker developers using a Mac.

We add Command-F shortcut to show find bar in any text view in FileMaker. Your calculations got long and you can’t find a word? No problem, now you can search for it. The standard search bar on macOS offers controls to find text in a text view. You may have seen the find bar already in TextEdit application and others. Optional you can enable replace and replace text:



MBS FileMaker Plugin 7.6pr5 or newer adds this great feature for everyone who has the plugin installed. No license required (but appreciated) as this is one of the many free features included with MBS Plugin. You can turn the feature on and off in our preferences dialog.

So here is a calculation dialog with search:



In general this works for every text view in FileMaker. In custom functions window we saw redraw issues with focus ring, but that doesn’t change functionality, so please ignore the blue lines. When working right, it looks like this:



Like all our additions to the FileMaker Development tool, we use very defensive programming techniques. The plugin registers the command-F shortcut here. If FileMaker ever itself needs Command-F, FileMaker comes first, so the plugin would no longer get the key press event. When we get it, we check if focus is on a text view, so for any other control, we just exit. Finally we check if there is a find bar, so if FileMaker ever starts registering one with the text view, we exit and don’t do anything.

Another little thing added with the Command-F is the Command-Option-C shortcut to copy the formatted text of the calculation. This helps to copy calculations and paste them in a forum or on a blog.

Download new plugin here. Let me know if you like it!

Older blog entries:

2017-12-22 MBS FileMaker Plugin, version 7.6pr5
2017-12-21 Execute defaults command with Shell functions
2017-12-20 QR Codes for Invoices in Switzerland
2017-12-19 DenkForm Schulung zur Europäische Datenschutzgrundverordnung
2017-12-19 FileMaker Magazin - MBS Artikel
2017-12-19 Welcome 5th generation of MBS Pens
2017-12-18 Invitation à la 6e conférence québécoise des développeurs FileMaker®
2017-12-18 Two weeks left for DynaPDF Christmas Sale
2017-12-17 MBS FileMaker Plugin, version 7.6pr4
2017-12-16 Spotlight search in FileMaker with MBS Plugin
2017-12-15 Trigger FileMaker Scripts from JavaScript in FileMaker 16
2017-12-14 Upload email to Sent folder via IMAP
2017-12-13 MBS FileMaker Plugin, version 7.6pr3
2017-12-11 Install fonts for PDF generation in FileMaker Cloud
2017-12-11 MBS FileMaker Plugin, version 7.6pr2
2017-12-11 LDAP with JSON
2017-12-10 FileMaker Cloud Tipps & Tricks
2017-12-10 Three weeks till year's end
2017-12-07 FileMaker Magazin - MBS Artikel
2017-12-06 MBS FileMaker Plugin, version 7.6pr1

Archives

Jan 2018
Sep 2017
Aug 2017
Jul 2017
Jun 2017
May 2017
Apr 2017
Mar 2017
Feb 2017
Jan 2017
Dec 2016
Nov 2016
Oct 2016
Sep 2016
Aug 2016
Jul 2016
Jun 2016
May 2016
Apr 2016
Mar 2016
Feb 2016
Jan 2016
Dec 2015
Nov 2015
Oct 2015
Sep 2015
Aug 2015
Jul 2015
Jun 2015
May 2015
Apr 2015
Mar 2015
Feb 2015
Jan 2015
Dec 2014
Nov 2014
Oct 2014
Sep 2014
Aug 2014
Jul 2014
Jun 2014
May 2014
Apr 2014
Mar 2014
Feb 2014
Jan 2014
Dec 2013
Nov 2013
Oct 2013
Sep 2013
Aug 2013
Jul 2013
Jun 2013
May 2013
Apr 2013
Mar 2013
Feb 2013
Jan 2013
Dec 2012
Nov 2012
Oct 2012
Sep 2012
Aug 2012
Jul 2012
Jun 2012
May 2012
Apr 2012
Mar 2012
Feb 2012
Jan 2012
Dec 2011
Nov 2011
Oct 2011
Sep 2011
Aug 2011
Jul 2011
Jun 2011
May 2011
Apr 2011
Mar 2011
Feb 2011
Jan 2011
Dec 2010
Nov 2010
Oct 2010
Sep 2010
Aug 2010
Jul 2010
Jun 2010
May 2010
Apr 2010
Mar 2010
Feb 2010
Jan 2010
Dec 2009
Nov 2009
Oct 2009
Sep 2009
Aug 2009
Jul 2009
Apr 2009
Mar 2009
Feb 2009
Dec 2008
Nov 2008
Oct 2008
Aug 2008
May 2008
Apr 2008
Mar 2008
Feb 2008
XML: RSS Feed XML: Atom Feed