Excel formatting and charts from FileMaker using XlsxWriter April 9, 2016 Simon Brown Leave a comment If you’ve developed solutions with FileMaker for any length of time, you’ve almost certainly created files using FileMaker’s native Excel exports. Although quite useful, this feature gives almost no control over the formatting, and definitely no way to set formulas, charts, or even text formatting.
However, the Python based XlsxWriter library and bBox can provide an easy way to add this to your solution.
Recently, in the midst of various reporting and charting projects, I've found myself wishing for an easy way to "dynamically instantiate" one or more variables... in other words, set them by name, with the name determined programmatically, as opposed to being hard coded. This issue has come up from time to time on this blog…
The web is a rainbow of color options. Color is a great tool for grabbing the attention of users, providing visual interest and impact and creating contrast for readability. Color is also at the center of many design trends, including flat and material styles. But can you go wrong with color? Are there hues or […]
Conditional Formatting on radio buttons 18/03/2016 | Michel Beyaert Conditional Formatting is an often used technique in FileMaker. It allows to distinquish types of data very easily. One case where it is often used is to review a list of invoices. By conditional formatting you can easily set the text color of invoices that are late in red, the ones that are paid in green, the ones that are about to be send out in light grey, ..The FileMaker community has been implementing this in very innovative ways, even to hide or reveal elements by setting the color of an object to the color of the background.
This post we will see how to have FileMaker Server run imports and free up the FileMaker client to allow users to perform other tasks without waiting for the import to finish. It really is like having minions at your beck and call…exciting stuff. Plus as an added bonus Donovan (one of our talented Beezwax developers) has provided a little custom function that enables a spinner graphic to keep the user informed of the progress of your import.
Get some help customizing SeedCode with an implementation package: now 15% off through March 31st. This edition also includes some tips for working with WebDirect URLs and visualizing your priorities. Enjoy! - John firstname.lastname@example.org
A simple FileMaker database that allows a business analyst, project manager, subject matter expert (SME) and other project team members to create and store use cases. This is a open product, distributed "as is" without support but also open for customization by a FileMaker developer.
This system allows you to ...
create new use cases quickly & easily
duplicate and modify existing use cases for emerging needs
copy complete use cases for integration into MS Word documentation
distributed open and open to design modifications by FileMaker developers
t’s a common scenario. You’ve got a reservation system of some kind or another and you have a limited number of resources available. When you add a reservation (for a specific date), you want to be able to only select the resources that are available; in other words, they haven’t already been booked for another reservation on that same date. This is not a terribly complicated scenario but you may find it a little difficult to get your head around; I certainly did. However, it is a really powerful, and useful, technique that has many different applications so it’s worth making the effort. So, let’s give it a whirl.
I am implementing a button bar interface for a client. They need an in house ordering system. Across the top of the layout there are 4 buttons. Each button represents a step in the process. I have decided to follow my own advice, and for this client, it made sense to create a tabbed interface using a Slider and Button Bar, instead of a regular Tab control. See my previous post on that subject.
If you do complex data analysis, then from time to time you probably need to group, summarize, and parse data into variables and/or fields. There are various ways to accomplish this, including the Fast Summary technique, which regular readers of this blog may be familiar with, as it has made a number of appearances here…
Development Tips How big is my database, exactly? March 18, 2016 | Julio Toledo
Bits and Bytes Been nurturing a FileMaker database for a few years now? Is it fast approaching "big data" proportions? Concerned about exactly how big your file(s) have become? With a maximum size of 8 Terabytes per file, it's quite possible to accumulate a large amount of data in a FileMaker application, especially on a multiple file solution.
“Universal Search” is 100% reusable, modular search code. It can be used to run any number of search requests (“FileMaker” style or SQL), in any context (layout), using dynamically specified (not stored) search fields and search terms. “Universal Search” works on any FileMaker file you paste it into. It works locally as well as a Remote …
Because Dropbox is so simple to use for basic file syncing, it’s easy to forget that you can do far more with it than just sync files between two computers.
If that’s all you’re doing, you’re missing out!
Author Joe Kissell explains why Dropbox is cool, shares best practices for using Dropbox on your own or with a group, helps you avoid common mistakes, clues you in to newer and advanced collaboration features, teaches you how to secure your Dropbox account, and describes unusual uses of Dropbox.
Readers can quickly benefit from the book: new users can start in the “Dropbox Quick Start,” which directs you to beginner basics or to special information for people who just want to access a shared Dropbox document.
But, for those who already know Dropbox basics, “Check Your Dropbox Skills” routes you immediately to help with exciting new features that you may not yet have mastered — or even been aware of(!) — such as Dropbox Team, Dropbox Paper collaboration, file requests, and Office integration/collaboration.
POSTED BY LIFESTYLE, TRAVEL, FASHION With Filemaker 14 we have the ability to use SVG files for our icons which are small, light weight files that can be sized as large as you want with no loss in image quality and as an added bonus they can be styled with hover states, and conditional formatting! Basically SVG files are awesome! The only problem is that they aren’t nearly as common as PNG files, and while Filemaker does come with some great built in icons to get you started, their simply aren’t enough to deal with all the weird icons most Filemaker developers need at their disposal.
I’ve always been a big fan of Syncfusion’s Metro Studio tool which has an excellent selection of royalty free icons, but they didn’t export to SVG very well for Filemakers purposes, so I created a little database that lets you search and find icons like Metro Studio, and exports them to a Filemaker friendly format.
Sharing your scoops to your social media accounts is a must to distribute your curated content. Not only will it drive traffic and leads through your content, but it will help show your expertise with your followers.
How to integrate my topics' content to my website?
Integrating your curated content to your website or blog will allow you to increase your website visitors’ engagement, boost SEO and acquire new visitors. By redirecting your social media traffic to your website, Scoop.it will also help you generate more qualified traffic and leads from your curation work.
Distributing your curated content through a newsletter is a great way to nurture and engage your email subscribers will developing your traffic and visibility.
Creating engaging newsletters with your curated content is really easy.