Portals can be used for essentially two different functions. Either data presentation or interaction. Of course, as you already know, you can also use a portal for both aspects of presentation and interaction as the same time.
In this video, we continue the growth of our Home Project database where we take a look at the core differences between a Master/Detail portal (Current found set) and one which uses a Self Relationship.
If you've not come across the differences between portal types, and
We finished three days of Tableau Conference 2022 (TC22) in sunny Las Vegas! The in-person and virtual attendees from Beezwax’s Data Analytics & Tableau development teams shared a few more highlights of TC22 sessions, with information, insights and a few key takeaways. Read our Day 1 TC22 session highlights here. Read our Day 2 session […]Afficher la totalité du billet
Hello again from Tableau Conference 2022 (TC22) in sunny Las Vegas! The in-person and virtual attendees from Beezwax’s Data Analytics & Tableau development teams shared more highlights of TC22 sessions, with information, insights and a few key takeaways. You can read about Day 1 session and conference highlights here. By the way, most of these […]Afficher la totalité du billet
Les listes virtuelles, suite de l’atelier de novembre 2021 Pour cet atelier, je vais céder la place de présentateur à Jérémie Gimenez (Par Jupiter) qui va creuser le sujet déjà abordé lors de l’atelier de novembre. Je lui laisse la plume pour vous annoncer le menu : Dans la suite de cette première présentation, où […]Afficher la totalité du billet
Hello from Tableau Conference 2022 (TC22)! Beezwax's Tableau/Analytics team attended in-person and virtually, and here we focus on highlights from the range of TC22 sessions.Afficher la totalité du billet
De quoi s’agit-il ? Comme je vous l’indiquais dans mon premier article de cette série sur les annonces de Claris, un tout nouveau programme fait son apparition. Son nom officiel est « Claris Problem Solvers Circle » et il ne sera pas traduit dans les différents langues. Lorsque j’ai interrogé Douglas et Marie à ce sujet, ils […]Afficher la totalité du billet
Any FileMaker solution is a growing collection of stuff to be maintained. By the nature of development, some things will be replaced leaving some aspects to be abandoned and others to be lifted up by revitalizing them. Regardless of what goes and what stays, it's best to have a plan for how things will be added and how easy it will be for your future self, or anyone else, to be able to identify those things.
In this video, I walk through the Home Project database I'm working on and I talk about
Moment privilégié J’ai eu la chance de pouvoir rencontrer (virtuellement) hier (12 mai 2022) deux collaborateurs francophones de Claris, qui m’ont accordé pendant plus d’une heure une interview passionnante. J’imagine que beaucoup d’entre vous ont déjà deviné que je parle de Marie Normand, responsable des partenaires Claris sur la région « EMEIA » et Douglas Wallis, responsable […]Afficher la totalité du billet
Designing within FileMaker can either be pretty easy or somewhat hard. There's no exact way to design the look and feel of your solution, but the process of implementing the design can be easier when using FileMaker's grid.
In this video, I talk about the process I use to first determine the size of a layout and then go on to refining its size so it fits within the golden ratio.
Finally, I talk about implementing my use of the grid to make the styling of objects easier and give myself some gui
Happy Star Wars Day! I found this Yoda Translator from funtranslations.com the other day and decided it was the perfect time of year to put out a fun demo file for Star Wars Day. All you have to do is type your text in the first field and click Translate to get the [...]
The post May The Fourth – Yoda Translator appeared first on The Scarpetta Group, Inc..
Afficher la totalité du billet
Being in need of a new database system myself, I decided to simply document the process of adding new features to a FileMaker system as it evolves. This is a great way to learn about the ins-n-outs of what goes on when developing a new system. There's a number of things which may or may not make sense when you take a look into how someone else created something. So, why not make videos as the solution progresses.
In this first video, I showcase how I originally started the file and where I shou
Deux annonces à suivre de près Mardi 26 avril 2022, Claris a publiquement annoncé deux informations importantes et qui peuvent changer la vision que vous avez de FileMaker.Le détail de ces annonces est en train d’être distillé par les équipes de Claris et nous en apprendrons plus dans les jours et les semaines qui viennent, […]Afficher la totalité du billet
Les petits plus de FileMaker Go Savez-vous que vous pouvez faire lire un code-barre à FileMaker directement ? Ou encore obtenir une signature manuelle dans une rubrique conteneur directement ? Connaissez-vous les formules de calculs qui ne fonctionnent qu’avec FileMaker Go ? Et que même dans les scripts, on peut trouver quelques pépites réservées à […]Afficher la totalité du billet
Le besoin : un tableau de bord mensuel Je vous propose de découvrir l’une des multiples façons de visualiser des informations récapitulées par jour sur une période d’un mois. Cette méthode peut facilement être adaptée pour une visualisation sur une semaine, voire même dans un contexte indépendant d’une notion de calendrier. Notre point de départ […]Afficher la totalité du billet
Having recently consulted with a newer developer unfamiliar with the way FileMaker hosting/sharing works, I found that discussing the process would be a good primer for anyone just starting with FileMaker. If you've only ever worked or developed your file on your local machine, then learning how to host that file will be a big benefit. Especially if you need to collaborate with another developer.
One of the key benefits of developing with FileMaker is the fact that it allows for collaborative l
Over the years I've created a number of videos about restoring user state. Returning windows to their last viewed location, restoring tabs and slider panels to those last viewed, etc. I've also created videos about super quick startup and managing users within a Users table.
What I haven't shown is how I combine all of those processes into a powerful user environment restoration routine. Along with highly maintainable (and transportable) code. I've used this approach on most all of the solution
Recently we’ve discussed optimizing SQL queries in FileMaker, and had some fun with various SQL experiments. Today we’re going to explore some ways FileMaker can use ExecuteSQL and the While function to perform letter frequency and text pattern analysis on candidate words for the popular Wordle game. The list of words comes from https://github.com/tabatkins/wordle-list and… Continue reading Exploring Wordlespace with SQL and WhileAfficher la totalité du billet
As developers, creative ideation is critical. With that in mind, here are 5 unique Custom Functions (courtesy of Christopher Edwards, that are potentially !useful for FileMaker developers. We built some of these for very specific, and oddly niche, use cases, such as this blog post. Happy Day!Afficher la totalité du billet
Soulager en délégant Vous avez sûrement déjà constaté que certaines actions ou certains calculs se faisaient instantanément quand le fichier sur lequel vous travaillez est directement sur votre poste alors que les mêmes instructions étaient extrêmement longues (voire insupportablement longues 😉 ) dès que le fichier était hébergé sur un serveur. Depuis quelques versions déjà, […]Afficher la totalité du billet
Sometimes, it's just good to reflect on how you use certain FileMaker features. You know, the simple ones. Like Show Custom Dialog and Get ( LastMessageChoice ). If you use FileMaker for mobile a lot, then Show Custom Dialog is a great way to go. With Desktop, you might have less than optimal results because users can reposition and resize the dialog.
Aside from those few issues, however, it's probably one of those script steps you find yourself sprinkling all around your FileMaker solution. Th
INTRO Today we’re going to pick up where we left off last month, and today’s article will assume the reader is familiar with the material we covered last time (in SQL Multi-Table Query Optimization). This time we’re going to dig a little deeper into multi-table SQL queries, conduct some SQL experiments, and look at a… Continue reading SQL Multi-Table & Miscellaneous ExperimentationAfficher la totalité du billet
When you really want to master creating all kinds of powerful solutions within FileMaker, then you'll have to be familiar with as many functions as possible. In fact, it doesn't hurt to know and have used every single one at least once or twice. The sooner you become familiar, the more things you'll be able to accomplish.
Reflecting on my own journey with learning all of FileMaker's functions, I remembered working with a dog-eared paper manual with sticky notes popping out all over the place. T