Aller au contenu

Blogs

 

Master/Detail and Detail/Master

One of the most important feature of FileMaker 17 is the “current found set portal”. It makes it easy and fast to display the list of found records on the layout (Master/Detail). Not only does it display them, but it allows to browse records with a single click, without having to write a script or […] Cet article Master/Detail and Detail/Master est apparu en premier sur 1-more-thing.
>>> Lire la suite… <<<

fabriceN

fabriceN

 

Solutions de démarrage et conception d’apps complexes (5) dans FileMaker

Concevoir une app avec une solution de démarrage… Nous avons vu dans notre article précédent que dès les premiers pas que nous faisons avec une solution de démarrage, beaucoup de questions surgissaient. Même si dans une base de contacts, vous aurez toujours besoin du nom et du prénom de vos interlocuteurs, l’approche peut tellement varier d’une […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Solutions de démarrage et conception d’apps complexes (4) dans FileMaker

Concevoir une app avec une solution de démarrage… Dans les deux articles précédents, nous avons vu que le développeur des solutions de démarrage était confronté à deux problématiques en lien direct avec la conception de ces solutions. Du fait qu’elles s’adressent à tout public, il est difficile d’en adapter le langage. Le choix fait par l’éditeur de […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Our First FileMaker 17 Certified Developers

We’re pleased to announce two Beez who have earned the title of FileMaker 17 Certified Developer. Christopher Edwards, Senior Developer Vincenzo Menanno, Senior Developer Christopher and Vince are among the first developers to receive this designation since FileMaker 17 Certification was announced last week. FileMaker 17 Certification is the official credential offered by FileMaker, Inc., […]
Afficher la totalité du billet

vincenzo

vincenzo

 

Solutions de démarrage et conception d’apps complexes (3) dans FileMaker

Des solutions de démarrage à votre service… FileMaker vous propose par défaut des solutions de démarrage théoriquement prêtes à l’emploi. Elles peuvent vous faire gagner beaucoup de temps, du fait qu’une première étape de développement a déjà été effectuée. Mais nous avons vu hier qu’elles s’adressent aussi bien aux débutants FileMaker qu’aux plus expérimentés et […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Junior Application Developer career path for recent graduates

Growing up, everyone insists that a college education will open so many doors—and it definitely can! …But, what they don’t tell you is just how competitive it can be to find a job (let alone a potential career job). After graduation, you start looking around for an opportunity to start your career. Suddenly, you find yourself in this whirlpool of candidates (all just as qualified as you) pining for the same entry-level position. What’s more, the worst part is that—nine times out of ten—the entry-level position has zero growth potential… Seasoned workforce veterans chalk it up to being the “first rung on the ladder”—a step you have to take just to gain experience and clear that “entry-level” label. And once you’ve put in (at least) two years of hard work, sweat and tears, only then can you move on and find a job within your desired career path… How can that be fair? Let me be clear—it isn’t. You worked hard in your four years at school; you went the extra mile, taking on additional work and responsibilities to help distinguish yourself (not to mention your huge monetary investment). So, why waste your time competing for a job with a dead end?  You deserve to work for a company that recognizes your hard work—a company that wants to invest in you and your potential. A company that offers guaranteed growth potential. Did you just graduate from college? Did you major in programming or related field? Are you passionate about development? MainSpring’s Junior Developer career path may be the perfect fit for you. Junior Application Developer Job Location: Towson/Baltimore Metro Area Type: Fulltime, Mon-Fri Start Date: Immediately The Developer is responsible for designing, developing and implementing creative application solutions for a variety of government and commercial U.S and international clients. The ideal developer is innovative and efficient, and will adhere to proven processes and standards outlined in the MainSpring Agile Development process. Primary roles & responsibilities: Develop and support software and database applications for the MainSpring client base as well as for internal projects Ensure project development/features remain in scope and proactively communicate with the team and the client throughout the course of projects Provide budget and schedule updates to the project manager Schedule and actively contribute to project meetings Manage change order process for projects Meet/exceed billable utilization targets Maintain proficiency and certification in development platforms as required ​ Job requirements & qualifications: Bachelor’s degree in a related field preferred, comparable experience required Experience with FileMaker, Objective C, Swift, MySQL, HTML, CSS and PHP Experience with the Agile development process preferred, not required Fundamental knowledge of database and application design, scripting, data parsing, technical documentation Knowledge of relational database design and concepts with a primary focus on FileMaker and PHP development Demonstrate ability to work as part of an application development team; create task lists, timelines and deliverables, work to meet project schedules determined by others Excellent communication and customer service skills Demonstrated strong history of success with managing processes, people and projects Must work out of Towson, MD office About MainSpring MainSpring is an IT strategy and consulting firm that arms organizations with the strategy, tools and resources to grow. We foster a family-friendly, innovative, challenging, fun working environment earning the distinction of being one of Frederick’s best places to work and countless awards for employee programs, growth and innovation. Founded in 1993, MainSpring is headquartered in Frederick, Md., with offices in Florida, Ohio, Washington and Wisconsin. The firm supports a wide range of clients including businesses, nonprofits and government agencies, such as the Department of Defense. Like our clients, people tend to stay at MainSpring. If you think you’re a match, let’s connect! Apply today
Afficher la totalité du billet

MainSpring

MainSpring

 

Bravo les bleus !

Au lendemain d’une journée et d’une nuit de festivité, même s’il n’y a sans doute pas de lien direct entre FileMaker et le foot, et même si pour ma part je ne suis pas une adepte, je ne peux pas ignorer cette joie collective qui a saisi notre pays… Alors ! Bravo les bleus ! Au […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Solutions de démarrage et conception d’apps complexes (2) dans FileMaker

Des solutions de démarrage à votre service… L’éditeur FileMaker inc. propose des solutions de démarrage depuis fort longtemps. Ces solutions de démarrage poursuivent deux objectifs, comme le mot « démarrage » d’ailleurs le suggère… – Elles s’adressent à ceux qui démarrent sur FileMaker et offrent ainsi une première solution clé en main… – Elles permettent, notamment à des développeurs […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Pour installer FileMaker Server 17…

Si vous êtes une entreprise, une association, et que vous travaillez avec plusieurs collaborateurs sur le même fichier FileMaker, vous avez sans doute intérêt à installer FileMaker Server… Si vous avez besoin de connexions concurrentes pour travailler un fichier FileMaker depuis un navigateur web ou depuis FileMaker Go et un iPhone ou un iPad, FileMaker […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Tabbed List Views

One of the challenges I love the most within FileMaker is creating something which requires less time and effort than the "older way" of doing the same thing. Such is the case with a tabbed list view. I recently came upon a sample file showcasing how to do something in multiple list views. It was using an older method of "simulated" tabs by simply placing clickable buttons in a horizontal row and making one of the buttons look different on each respective layout. So I thought to myself, "Why isn't he just using a normal tab panel?". You can certainly do it. You just need a few key pieces of info in order to create a very powerful navigational tool for a tabbed based list view. And, that's what this video is all about Tabbed List Views. Click the title or link to this article to view the video.
Afficher la totalité du billet
 

FileMaker Gmail Integration

FileMaker Gmail Integration In 2016, Google announced that Gmail has over 1 billion monthly active users. Many companies even leverage Gmail to set up accounts using their company domain name. If you have a FileMaker CRM, or are wanting to have one, adding your email correspondence will help improve the visibility you have over communications with contacts. In this article we will demonstrate how you can import your HTML emails from Gmail directly into your FileMaker system.  Creating a Free Developer Account The first step of this integration is to create a project in the Google Developers Console if you do not already have one. Once you have created a project, you will then need to enable the Gmail API. Once it is enabled, go to the menu and go to APIs & Services > Credentials. We will need an OAuth 2.0 client ID and secret. If you have not done this before, you will need to create these credentials and set up the OAuth consent screen. We will be using HTTP requests, so you will want to mark that the API will be accessed via a web browser client. You will also need to set the redirect URI to https://dbservices.com or any valid website that will not redirect to something else. This is only used as a landing page for authentication and does not need to be anything special. Once the Client ID has been created, copy the Client ID and Client Secret into your solution. Keep your client secret hidden from the world as the combination of the Client ID and Client Secret will be used to authorize your solution to access the end user’s account. Authenticating with Google and OAuth 2.0 Once you have your API information, you will need authenticate your solution with the Gmail API. Google provides an OAuth 2.0 playground to view how to authenticate, or you can reference our sample database which accompanies this article. At a high level, in order to authenticate your solution, place the user into a web viewer at the API authentication endpoint. This will prompt the user to log in with their own credentials and choose the account to allow your solution to make the connection. Once they have agreed, they will be sent to the address specified in your redirect URI that was passed in the authentication request. When the user is redirected to the new address, the address will now have a URL encoded parameter, which will be the code needed for the next step. Set Variable [ $code ; Value: "https://dbservices.com/?code=058baec5-cfd7-42ae-b3ea-c0683fa4b6b5" ] Once you have extracted the code, you will use the code provided, along with your ID and secret to get your access token which will be used to make any API requests. Making Requests and Parsing the Response Before you make requests to the Gmail API, it is important that you understand JSON and cURL. Importing emails from Gmail requires 4 main requests: List Messages, Get Message, Get Attachment, and Modify Message. The List Message request will be needed to pull all messages based on the query provided. For example, you can find all emails after a certain timestamp by using the following: Set Variable [ $cURL ; Value: "-X POST --header \"authorization: Bearer XXXXXXX\"" ] Insert from URL [ Select ; With Dialog: Off ; $result ; ""https://content.googleapis.com/gmail/v1/users/me/messages?q=after%3A" & $startTimestamp" ; $cURL ; Do not automatically encode URL ] Keep in mind that the timestamp will need to be formatted for UNIX. Once a successful request has been made, a JSON-encoded response will be returned with the list of message IDs. You will then be able to use the function JSONGetElement() to pull any information out of the response that you wish. { "messages": [ { "id": "1234567890", "threadId": "8675309" } ], "resultSizeEstimate":1 } For example, you can get the ID by using the following function: Set Variable [ JSONGetElement ( $result ; "messages[0]id") ] Now that you have the ID of the message, you can use the Get Message request, which will give you the details of the message. Some messages will include an attachment ID, which you will then need to use the Get Attachment request. Finally, if you need to mark the message as read, or archive it, or just change where the message is located, you will need to use the Modify Message request. The Modify request is a little different from the others as it is a POST rather than a GET, so you will have to pass the extra information as JSON in the cURL options. Set Variable [ $cURL ; Value: "-X POST --header \"authorization: Bearer XXXXXXX\" --header \"Content-Type: Application/json\"" --data @$modifyJSON" ] Insert from URL [ Select ; With Dialog: Off ; $result ; "https://www.googleapis.com/gmail/v1/users/me/messages/" & $messageID & "/modify" ; $cURL ; Do not automatically encode URL ] I strongly suggest taking a look at our accompanying example file as certain portions of the API can be a bit tricky. For instance, pulling the details of the message is a little complicated and you will need to implement loops to traverse through the response to grab the specific information that you need. Conclusion Integrating your FileMaker app with Gmail will greatly improve your business’s visibility over communication with your company’s contacts. Feel free to contact us if you need further assistance or to discuss getting your Gmail account integrated with FileMaker. Download FileMaker Gmail Integration Database Please complete the form below to download your FREE FileMaker database file. Name* First Last Company Phone* Email* Deployment Assistance?Please contact us to assist integrating into your FileMaker Database. Yes Terms of Use I agree OPT-IN: I agree that I am downloading a completely free FileMaker application file with no strings attached. This database is unlocked, and I may use it for my business or organization as I see fit. Because I am downloading a free database, I agree that I should receive occasional marketing. I understand that I can OPT-OUT of these emails at anytime.
Afficher la totalité du billet

DB Services

DB Services

 

Une année éditoriale FileMaker exceptionnelle !

Avec la fin de l’année, – eh oui, chez nous, l’année se termine le 30 juin et pas le 31 décembre 😉 – vient l’heure des bilans. Alors, faisons comme les associations loi 1901 qui, en France, font pour chacune de leur assemblée générale un rapport moral, c’est-à-dire un rapport d’activité… Une année 2017-2018 exceptionnelle […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

FileMaker et des projets plein la tête !

Il y a, dans mon métier, une chose qui me sidère et m’émerveille à la fois… Je pense que tous les créateurs connaissent cela à un moment ou à un autre : l’angoisse de la page ou de la toile blanche… Vertige devant l’abîme, vertige qui exige l’acte créateur ! Mais l’acte créateur n’est pas […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

De la pérennité des fiches Astuces FileMaker…

Depuis quelques jours, vous lisez sur le blog un certain nombre d’articles concernant les fiches Astuces FileMaker. Vous avez notamment repéré que nous venons d’achever la 7e session annuelle de fiches Astuces et que nous commençons la 8e : une telle pérennité est rare dans le monde de l’édition et dans celui de la pédagogie […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Passage de relais d’une session à l’autre de fiches Astuces FileMaker

Juillet 2018 : lancement de la session 8 des fiches Astuces ! Vous aviez l’habitude de commencer l’année le 1er janvier ? Chez nous, elle commence le 1er juillet 😉 En effet, nous débutons ce 1er juillet une nouvelle année de fiches Astuces, qui correspond à une huitième session de fiches Astuces ! Déjà sept sessions, avec 131 fiches (fiches […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Ultimate FileMaker Debugging

Every craftsman should know how to use his or her set of tools effectively. When you know all the various uses and features of a given tool you then become more efficient at your trade. In FileMaker Pro Advanced, now available to pretty much everyone in version 17, there's one tool which helps you both understand what's happening and figure out what's not happening. The Script Debugger is an absolutely essential tool. Creating a well functioning script is a lot like Michelangelo creating David. It didn't just appear because he held the tools in his hands. It was because of the constant refinement with the tools until the beauty within was finally present. Writing a script is no different. You won't get it right the first time and you with almost always be able to refine and make it better. So, it goes without saying that knowing how to use the Script Debugger is one of the number one things you should know how to do when coding in FileMaker Pro. Click the title or link to this article to view the video.
Afficher la totalité du billet
 

Des fiches Astuces pour une formation continue FileMaker

Et voilà… Avec la fiche Astuce n°128 livrée ce vendredi, nous clôturons une nouvelle session annuelle, la septième… Mission accomplie pour cette année et, sans vouloir nous envoyer des fleurs à Magalie et à moi-même, mission bien accomplie. Outre le côté impressionnant en pensant qu’il y a déjà 7 sessions annuelles de fiches Astuces, ce […]
Afficher la totalité du billet

MagalieJ

MagalieJ

 

Client Side Virtual List

Last June at dotfmp 2018 in Berlin, we had the great honnor to welcome an esteemed Californian member of the FileMaker developer community, Kevin Frank (@FileMakerHacks) Besides being a long time friend -I remember the old times when participating in our ‘Friday Night Chat’ at 3AM CET wasn’t an issue for my young, fast-recovering body- […] Cet article Client Side Virtual List est apparu en premier sur 1-more-thing.
>>> Lire la suite… <<<

fabriceN

fabriceN

 

Virtual List Reporting with JSON Arrays

Acknowledgement: As always a huge thank you to Bruce Robertson, for inventing virtual list, and for many other contributions to the FM community over the years. Introduction As a follow up to my recent “Virtual List on Steroids” presentations at DIG-FM and dotFMP, today I want to take a fresh look at using JSON arrays […]
Afficher la totalité du billet
 

FileMaker 17 : Nouvelles fonctionnalités d’exportation de fichiers

Un exemple de scénario commun : vous montrez votre nouvelle application personnalisée à un client, un de vos supérieurs ou collègues et vous êtes fier de la façon dont il peut envoyer un courriel directement à partir de l’application. Cela permet aux utilisateurs de tirer parti de toutes les données stockées en son sein — assez puissant! Mais ce dernier demande ensuite s’il peut envoyer plus d’une pièce jointe, car le rapport hebdomadaire sur l’état des ventes comprend trois fichiers PDF. Vous expliquez que FileMaker Pro ne prend en charge qu’une seule pièce jointe par e-mail. Ceci était un réel obstacle jusqu’à ce que la nouvelle Plateforme FileMaker 17 arrive et offre la possibilité d’attacher plusieurs fichiers à un message électronique … Vous pouvez appeler cette option manuellement pendant le processus Send Mail ou vous pouvez la programmer en utilisant le moteur de calcul dans FileMaker 17, comme vous le feriez pour toute autre étape d’importation / exportation de fichier.
Puisque nous parlons des capacités d’exportation de fichiers dans FileMaker 17, nous devons mentionner sa capacité à créer des répertoires lors de toute action d’enregistrement de fichier. Disons que vous venez de créer ce rapport astucieux que votre équipe peut utiliser pour guider la réunion quotidienne de mêlée de projets. Simplement en cliquant sur un bouton, vous pouvez enregistrer un rapport directement sur votre bureau, sous format PDF. Cependant, vous ne voulez pas encombrer votre bureau avec un tas de fichiers, FileMaker 17 l’enregistre dans un dossier appelé “Daily Scrum”. Cela fonctionne bien jusqu’à ce que quelqu’un d’autre veuille exécuter et enregistrer le rapport sur leur bureau. Parce que ce dossier n’existe pas sur le nouveau bureau et l’ordinateur exécute une ancienne version de FileMaker Pro, vous obtenez cette boîte de dialogue indéchiffrable: Eh bien avec FileMaker 17, si le dossier n’est pas là, il le créera automatiquement! Tout ce que vous avez à faire est de spécifier l’option “Créer des répertoires: sur” située sur toutes les étapes du script d’exportation / enregistrement. Regardez la demo. Vous voulez upgrader votre app? Let’s chat! Article écrit à l’origine en anglais par Vince Dolan et publié sur le blog de notre partenaire et membre Platinum de FileMaker Business Alliance blog.supportgroup.com. 📍 Vous êtes interressé-e par le développement FileMaker ? Découvrez nos ressources dédiées pour les développeurs novices ou plus expérimentés. FileMaker 17 : Nouvelles fonctionnalités d’exportation de fichiers was originally published in FileMaker Fr on Medium, where people are continuing the conversation by highlighting and responding to this story.
Afficher la totalité du billet
 

FileMaker 17 Starter Solutions

FileMaker 17 Starter Solutions The FileMaker Starter Solutions are here for you to start your journey in developing your dream application.  FileMaker comes with 6 Starter and 16 Sample templates that assist in starting a new application and allow you to customize it to your business needs. The Six Starter Solutions are: Assets Contacts Content Management Inventory Meetings Tasks The 16 Sample Solutions are: Assets Contacts Content Management Estimates Event Management Expense Report Inventory Invoices Meetings Personnel Records Product Catalog Projects Research Notes Resource Scheduling Tasks Time Billing The 6 starter solutions are simple and a great springboard to create new FileMaker apps to manage your business. If however you need more advanced solutions, check out the 16 sample solutions. They have more features than the starter solutions, and may ultimately be a better fit for your business needs.  Difference From Past Years All 6 Starter Solutions have been designed with Universal Touch theme.  The new theme includes a variety of styles so you can more easily combine the different styles in the same layout. And when you install FileMaker Go on your iPad/iPhone, it comes with 4 sample solutions: Contacts, Event Management, Invoices, and Projects. To modify the FileMaker Go solutions you will need to email them to your desktop and make changes in FileMaker Pro Advanced. Creating a New Application To create a new starter solution, simply open FileMaker Pro Advanced and the launch center will come up. If you don’t already own FileMaker, you can download a free FileMaker Trial to give the templates a try. From here go to Create New.  You can choose one of the 6 Starter Solutions or you can scroll down to the samples to view the 16 Sample templates. The starter solutions are designed for the desktop, but can be accessed on an iPhone, iPad, or Webdirect.  If you would like layouts customized to iPhones, iPads, or WebDirect, check out the sample solutions.
Let’s take a l0ok at the 6 starter solutions. Assets The Assets starter solution is designed to track office assets, where the assets are purchased, and who is using them. Once the information is put in, the name, type, purchase date, price and used by date are at the top of the page for improved readability.
Meetings The Meetings starter solution is used to track meetings, along with setting agenda topics and assigning action items for each meeting. The meeting information is presented at the top of the page for improved usability.  The starter solution gives you a tab on the right to write down any notes you may have for the meeting and also put it at the top of the page.  The starter solution also includes the topics and action items tabs to put in information but with a different layout to make it easier to navigate.
Contacts The Contacts starter solution is used to manage personal and business contact information for several individuals. Below the picture you are able to input the contact name and job title and to the right you are able to enter and view additional information such as addresses and phone numbers.  Once this information is put into the template, the contact name and company displays at the top for usability. Content Management The Content Management starter solution is used for collecting and organizing documents, images, music etc.  At the top of the page it displays the name, the type of product/service, the status of it, and the location of it.  This new addition makes it easier to quickly identify the record you are looking at.
Inventory The Inventory Starter Solution can be used to manage inventory levels of products and supplies, along with tracking part numbers, transaction history, and more.  The template has made significant changes by first changing where the information in inputted.  The three tabs are for the part, the cost of the part, and the stock of it.  In the part tab it gives the option to put in the part number, barcode, description, location and date.  With the cost tab you can calculate the unit cost and unit price, along with making it taxable.  Below the category line is a stock button that can be used to order more of the product/part.  Once all the information is put in, the name, part number, units on had, and availability is displayed at the top of the page to alert you of the part’s current status. The Inventory Starter Solution is a great starting point for creating an inventory module as it contains only 2 tables: products and inventory transactions.
Tasks The Tasks starter solution can be used to track tasks and the priority, status, and due dates of those tasks, and you can add as many assignees to the task as you wish.  Any attachments are added to the right of the assignee with a description of the attachment available.  Below the attachment is the overall description of the task. After all this information is put in, the task, status of the task, category and due date are displayed at the top for ease of use. Conclusion FileMaker has continued to improve upon the starter solutions from years past to make it easier for you to create your own solution, and with now 6 starter solutions to compliment the 16 sample solutions, you have more options than ever before. If you are looking for a CRM and the starter solutions are not fitting your business needs, check out our own template, FM Quickstart. It is a free download and has been optimized to run on the latest version of FileMaker. And to learn more about the FileMaker 17 platform, read our FileMaker 17 Overview article.  
Afficher la totalité du billet
×