Aller au contenu


  • Compteur de contenus

  • Inscription

  • Dernière visite


À propos de MainSpring

  • Rang

Visiteurs récents du profil

Le bloc de visiteurs récents est désactivé et il n’est pas visible pour les autres utilisateurs.

  1. FileMaker, Inc. recently adopted a new core message that encapsulates the strength of their software platform and helps business leaders better understand their focus. FileMaker is a Workplace Innovation Platform. Essentially, the platform bridges the gap between appliance applications (like Quickbooks, Microsoft Office, file sharing) and enterprise systems (ERPs, CRMs) in order to free up time to focus on critical and strategic projects by eliminating manual processes, managing spreadsheets, disconnected systems and administrative tasks. Are you spending too much time on repetitive tasks? Do you feel like your time would be better spent working to grow your business, but you’re too bogged-down with manual processes? You are in a work rut. It’s likely that you’re using a mix of limited appliance apps and enterprise systems that have a different focus and are cumbersome to customize. This is where a Workplace Innovation Platform comes in – it’s a customizable tool that allows you to put your ideas and expertise into action. FileMaker’s Workplace Innovation Platform provides a way to easily create applications that can be shared across your organization and integrated into your other applications. There’s no other tool that’s as easy to get started with developing that still has the depth to create powerful applications. While the ability for self-service development is one huge advantage to the FileMaker platform, the efficient development toolset also means that working with a development partner amplifies your return on investment. Innovation made simple with FileMaker Innovation is the driving force behind FileMaker. When it comes to building custom apps, getting an idea out of your head and into the world can be a daunting task. FileMaker focuses on removing the barriers between ideation and actualization. A basic custom app can be produced in minutes – hours instead of weeks – months. Choosing a platform with a low entry barrier and quick delivery time means that you’re able to achieve results with a small, initial investment, while still reaping the rewards of having a customized tool. MainSpring’s development process MainSpring has rolled out a new way for clients to work with our expert development teams that’s specifically driven by the rhythms of developing in the FileMaker platform. Our AMP Pro program provides our clients with the process and tools to quickly deliver custom applications. We teach you how to define and communicate your ideas so that they can be translated into working custom applications as quickly as possible. Once your applications are deployed, we work with you to provide continued proactive development so that you can adopt a cycle of continuous improvement and innovation. MainSpring also provides cloud hosting, application, and end user support, making FileMaker easy to integrate into your organization. Free development consultation MainSpring’s expertise in the FileMaker platform extends over 20 years. Our team of skilled consultants and certified developers is paired with processes and tools that we’ve developed to ensure success. If you’re stuck in a work rut, or think that there must be a better way to get your team to achieve their goals—chances are that FileMaker’s Workplace Innovation Platform is the solution that you need. Afficher la totalité du billet
  2. Restructuring—no matter how big or small—can be a tough transition. It takes time, money and effort from the entire team—and, ultimately, every part of the business is re-examined. The spotlight rests on an organization’s processes: who does what, who talks to who and how everything fits together. Couple that with exponential team growth, and you’ll find you have a real mess on your hands. …That is, unless you have someone like Ryan Klenk, MainSpring’s application development team’s technical lead. Taking initiative Despite already having a unique and innovative approach to development, MainSpring’s Application Development team knew they wanted to further improve their clients’ development experience. So, they established a simplified way of doing development, called AMP Pro, that puts clients and their needs at the front of the line. In effect, they also created a junior developer career path to attract the D.C. metro area’s best young developers to help fuel the new initiative. With so much on the table, Ryan Klenk jumped right in—focusing on capturing existing processes, recording new ones and documenting coding standards. As a champion of the new AMP Pro subscription service, Ryan recognized the predictability of development through subscription and wasted no time introducing the service to his clients to help move their development needs to the front of the line. Simultaneously, he streamlined MainSpring’s recruiting process for junior developers, helping hire more qualified candidates to fulfill the needs of the new AMP Pro initiative. What’s more, he’s spent copious time mentoring these new junior developers and has established training milestones, which, ultimately, have helped pave their career path. Predictable process delivers predictable results Restructuring tends to shift processes around from person to person; however, with Ryan’s tenacious, process-driven approach, he’s helped his team take full ownership over their job roles, while also providing them with somewhere to turn when they need help. Making this essential information accessible has made the transition easier, and Ryan and his team are poised to better assist clients with their development needs. Afficher la totalité du billet
  3. 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
  4. MainSpring

    MainSpring celebrates 25 years in business

    If you haven’t already heard, 2018 marks MainSpring’s 25th anniversary in business—25 memorable years of growth, innovation and an unrelenting commitment to succeed. From its inception in a small basement in Montgomery county and settling into the first office in Poolesville, Md., to rebranding to MainSpring and moving to downtown Frederick, MainSpring’s goal has been, and will continue to be, striving for excellence in both quality and service and providing clients with the tools and technology they need to reach their business goals. It’s all seemed to happen so fast, yet nothing happened over night. So, today, we take a look back at the milestones we’ve celebrated over the last 25 years… Afficher la totalité du billet
  5. MainSpring

    FileMaker 17 licensing updates

    MainSpring is excited to announce the release of FileMaker 17! With the new release, FileMaker, Inc. is changing their licensing program to be dramatically more simple and user-friendly. New features of FileMaker 17 licensing programs The new licensing programs will license the entire FileMaker platform—there are no longer separate products, so everyone receives access to all aspects of FileMaker. Another major change is that there’s no longer a difference between FileMaker Pro and FileMaker Pro Advanced; all copies of the desktop client can enable the Advanced functionality. FileMaker Data API The FileMaker Data API is also now fully released and covered by the new licensing programs. The Data API allows for unlimited inbound data and 2GB of data usage per month for each licensed user on an annual basis. Essentially, if you have 10 users, that means you’re licensed for 240GB of outbound Data API transfers every year. If you find you need more than that, though, all you have to do is increase your user count. Single license key Perhaps the most convenient change to the licensing program is that each licensing contract will have a single license key. That license key will also remain the same from version to version for as long as your contract is active. This greatly simplifies deployment, as well as the management of license keys. Three licensing programs available There are now three different licensing programs: User Licensing, Site Licensing, and Concurrency Licensing. In all cases, users can choose to purchase an annual or perpetual license. Most companies, however, will utilize the User Licensing program. User Licensing User Licensing is based upon the total number of users who will be using FileMaker in an organization. All of those users will be able to access FileMaker Solutions using FileMaker Pro Advanced, FileMaker Go, and FileMaker WebDirect. User License holders will also be able to install up to three instances of FileMaker Server. If you have annual licensing, one of the three server instances can be installed in FileMaker Cloud. Site Licensing Site licensing continues to offer a wonderful value for organizations with a large percentage of FileMaker users. Site licensing continues to have a minimum head count of 25 users. However, Site License holders are now only able to install as many licenses of FileMaker Server as they have in their headcount, which is a slight change from the previously unlimited number of FileMaker servers. Concurrency Licensing Concurrency Licensing continues to be an option for companies that require a shared pool of anonymous connections for WebDirect and FileMaker Go. Concurrency contracts can only install a single instance of FileMaker Server, and they have the highest cost per user. The good thing is that most instances of concurrent connections that were licensed in conjunction with the previous volume license program can now probably be covered by the new User Licensing program. Please contact MainSpring if you’d like to talk through your use case for Concurrencies. What to expect when you receive your FileMaker 17 license key For users that are under an annual contract, or have maintenance for their perpetual license, here’s what you can expect when you receive your FileMaker 17 license keys: Volume Licensing and Team Licensing becomes User Licensing Volume Licenses transitioning to User Licenses will have a user count equivalent to the number of copies of Pro and Pro Advanced If you have multiple contracts, you will receive one key for each contract in the same email If you have a Volume License and Concurrent Connections for your server, you will receive a User License and a Concurrency License Save money with price protection Don’t forget about price protection! FileMaker is offering price protection for users for the first year after release. This means you can renew your contract at FileMaker 16 pricing for up to one year after the release of FileMaker 17. When you renew your contract, you can also renew for up to three years, which locks in substantial savings. Afficher la totalité du billet
  6. FileMaker Server makes another significant leap forward with a sleek new node.js based admin console. Take a tour of the new interface in FileMaker 17, and find out some of the changes in store from the upgrade. Afficher la totalité du billet
  7. MainSpring

    FileMaker Go 17 feature roundup

    With the release of the FileMaker 17 platform, there are many new FileMaker Go 17 features to review as well. Here’s a summary of the latest new features and changes to FileMaker on iOS. New features in FileMaker Go 17 Keyboard shortcuts. As power iOS users utilize external keyboard devices, they have noticed a lack of support for common FileMaker Pro shortcut commands via FileMaker Go. The new functionality in FileMaker Go will not only bring support for dozens of shortcuts in FileMaker Go, but also custom menu support for those shortcut actions. Local notifications. You will notice a new script step in FileMaker 17 called “Configure Local Notification”. This new script step allows you to script powerful OS-level alerts to display to your users. Alerts can be displayed at a timed interval and will persist even if FileMaker Go is no longer running! You can also tie alerts to scripts to fire off actions from the alerts. This functionality was previously only possible via 3rd party external apps, like AlertFlag. Drag & drop support. Text, photos and files can now be drag-and-dropped in FileMaker Go, enhancing the ease of use for storing files in FileMaker Go. App delegate. While not apparent to most, this is a big improvement to the FileMaker iOS SDK. The addition of an App delegate setting to the iOS SDK will allow developers to interact with iOS system events to provide a more seamless iOS app experience. GetSensor() function. FileMaker rolled out an impressive new GetSensor() function that can query and pull data from various sensors in iOS devices. Ever since I developed CoreScope, I have been asking for FileMaker to implement similar functionality. Now that it’s here, I’ve documented all the amazing new metadata features of this function in this blog post. Changed features in FileMaker Go 17 Launch center context menu. A new menu available in the launch center of FileMaker will allow you to perform a number of new file actions: Pin/Unpin files: Allows you to pin favorite files Delete files (Local files view): Allows you to remove files from the device Remove files (Recent files view): Allows you to clear the recent files list Share (Local files): Brings up the share/send file menu Rename (Local files): Brings up a dialog to rename the file Auto-complete/Type-ahead support. Edit boxes that use value lists will now support the “auto-complete using existing values” function via a native selector menu that will appear while typing. This will be especially useful for very long value lists, where you don’t want users to spend a lot of time scrolling to find a matching value. This update will result in quicker and more accurate data entry. Deprecated features in FileMaker Go 17 Get(WindowOrientation) function. This function is being removed as better functionality has come along since its release in version 13. Afficher la totalité du billet
  8. MainSpring

    New portal features in FileMaker 17

    In this video, I’ll show off the two, new features of the portal object in FileMaker 17. We’ll start by quickly building a powerful master-detail layout. Then, we’ll automatically create relational database schema using the add-on table feature. Afficher la totalité du billet
  9. MainSpring

    New for FileMaker 17: GetSensor function

    FileMaker 17 introduced the new GetSensor function as a new mobile function available for use in FileMaker Go apps. With this new function, you can gather sensor data from an iOS device and use it programmatically in your custom app. While this is a good start, there’s still some device metadata and sensor data that is not available from the function. A few years ago, I released a metadata gathering app, CoreScope, that allows for more information to be gathered from the device. Due to my familiarity with iOS programming and sensors, I found some parts of FileMaker’s documentation on this function to be a little confusing. So, I dug deeper into Apple’s developer documentation to put together the below chart explaining in detail what each sensor reading represents. Use these helpful tables in order to understand and use sensors with the GetSensor() function. Interested in a deeper dive? Let me know in the comments, and I can link you to Apple’s documentation. Configuration Battery sensor Location sensor (Note that if the optional accuracy and timeout parameters are not specified, a default accuracy of 100 meters and 10 seconds is used.) Attitude, speed & acceleration sensor (Note that if the optional accuracy and timeout parameters are not specified, a default accuracy of 100 meters and 10 seconds is used.) Magnetic sensor (Note that if the optional accuracy and timeout parameters are not specified, a default accuracy of 100 meters and 10 seconds is used.) Step count sensor (Note that if the optional second parameter is not specified, it returns the values measured since midnight of the current day. The sensor can be inaccurate if the user has not calibrated their phone’s step settings inside of health data and motion calibration. Also, returned measurements may be localized to the user’s iOS localization settings, eg. meters vs. feet.) Air pressure sensor Afficher la totalité du billet
  10. Next week, renowned FileMaker speaker and developer, Mike Beargie, will travel down to Le Pavillon hotel in New Orleans, La. to speak at the Pause on Error conference, hosted by the Women of FileMaker group, on May 7-8. When asked about the setup of this conference, Beargie replied, “Pause on Error is a bit of a wild-west style meetup. The smaller rooms lend well to allow speakers to share prototype work and techniques that drives innovation in our community.” Continuing, Beargie explains the sessions aren’t “present and consume,” like they are FileMaker DevCon, or other conferences. Instead, group discussion and participation are not only encouraged, but invaluable to the community. “I always look forward to Pause because it inspires me to innovate, both in my own work and with more community contributions,” Mike exclaimed. Pause on Error has 24 feature sessions presented by a panel of community-driven speakers from all walks of life, including speakers from FileMaker, Inc. Specifically, Beargie’s session will be geared towards out-of-the-box thinking when designing FileMaker application features. “There’s loads of inspiration that can be taken from web apps,” Beargie said. “With recent improvements to the design surface in FileMaker, it makes it a lot easier to develop similar functions in FileMaker. In my session, we’ll look at how to recreate these inspired features in FileMaker.” Stay tuned for updates after the conference from Mike! Afficher la totalité du billet
  11. In this vlog, we cover building a simple alert (or dialog) in FileMaker 16 in about five minutes. Creating an alert using this tutorial allows for more flexibility, both in terms of appearance as well as follow-up actions available for the end user. The reasons for building an alert into an application vary greatly depending on each individual need, but here are some basic examples: Notifying or reminding the end user about a task assigned to them Notifying the end user about an update to the application Notifying the end user about a message from another user Afficher la totalité du billet
  12. MainSpring

    What is an MVP?

    My favorite aspect of my job at MainSpring is discussing the myriad of great ideas that our clients have, and helping them turn those ideas into a solution. One of the biggest challenges in this process is helping people understand the value of starting off small—and that starting small is the first step toward achieving the ultimate goal. It’s easy to be entranced by your ideas and want to do everything immediately, but there are a number of definite advantages to starting off with the Minimum Viable Product (MVP). The beginning is not the end You’ve probably heard the term MVP used a lot in the technology space, and this largely stems from modern application development methodologies that stress early delivery and flexibility as the keys to delivering great results. The basic premise of an MVP is to deliver the smallest possible feature set while fulfilling the core requirements of the users. Building an MVP comes with the understanding that there will be more work required to achieve the ultimate goal, and that the ultimate goal is best achived through confident organizational buy-in and informed decision making. Planning through evaluation Choosing to develop an MVP can seem antithetical to the motivation to build a custom app—you know you want everything, so why not plan for everything from the beginning? The truth is, it’s inevitable that, once the users get their hands on a custom app, the requirements change. Perhaps the most important reason for building an MVP is to get users involved in the feedback cycle that fuels the requirements for further development. Shifting the focus to requirements for further development is incredibly valuable; therefore, planning based upon the evaluation of what you’ve already built delivers the most valuable features. Gain adoption through delivering value Developing an MVP first verifies that the custom app is a viable solution because it only requires a small initial investment, yet it delivers value right away and builds stakeholder buy-in. Seeing that value upfront is crucial to helping an organization determine three things… How much they should build How fast they should build How they should prioritize what to build The value produced from the MVP defines the case for further investment and drives the engagement of users who will operate the tool. Learning how to achieve together Many of our clients have never worked on a custom app development project, or even used an interactive process to accomplish a project—and it’s definitely a learning experience. One of the overlooked advantages to the MVP approach is that clients are able to learn about the development process through hands-on experience working with developers. At the same time, our consultants get to learn about your team, your company and your industry. The post-deployment evaluation of the MVP generally serves as a sort of “shakedown cruise” for the whole team. Essentially, we get to evaluate our interactions with our clients and discuss how we can achieve better results together, which allows us to deliver more value in future development. Afficher la totalité du billet
  13. MainSpring

    FileMaker across borders

    Through my annual visits to FileMaker DevCon, and my recent trips to the Japan FileMaker Conference and Quebec FileMaker Conference, I’ve met a lot of great people from the worldwide FileMaker community. One thing I’ve found is that many people don’t realize that the use cases for FileMaker can vary as much as the developers making their apps. Therefore, I’m happy to share some of my experiences and things I’ve learned from communicating with developers across the globe. FileMaker data security In Europe, one of the major concerns right now is data security. As this recent thread in the FileMaker Community points out, the new GDPR regulations in Europe will soon take effect. With that comes a greater responsibility for app developers to take a security-forward approach to developing data-driven apps. In America, we have similar approaches for apps that require PCI and HIPAA, but something like GDPR affects a much broader app market. We can learn from this by taking security-forward approaches to our own apps. For instance, we recently conducted internal security testing that lead to the discovery of a flaw in FileMaker WebDirect 13 and 14. That’s why it’s so important to audit your own systems on a regular basis. Contributing FileMaker ideas and issues to the community During my time at the conference in Japan, it was shocking to see and hear that there are so few consulting developers in Japan—so much so, that the conference itself was made up of tracks geared toward business prospects rather than developers. For example, an entire day and track was devoted to Healthcare. The vendors’ exhibits also varied greatly, focusing on vertical market products that were ready for sale, rather than developer tools, like at the North American FileMaker DevCon. Mike speaking at FMCJPAs the small-team FileMaker market grows around the world, so the citizen developer role has risen. A citizen developer is someone that bridges the role between a consultant, or professional developer, and just a regular user. In Japan, a lot of citizen developers are in the FileMaker community. They do lightweight changes on their company’s apps and may not be involved with sharing in the community. While this allows for conferences (like Japan’s) that are more geared toward business, it can lead to equal frustration from the professional and consulting community, as they end up not receiving the community support and innovation that other areas have. In fact, there’s always a large group of Japanese developers that attend FileMaker DevCon in the United States just for that reason. Consequently, it’s important to provide support in the community in a way that equally benefits all levels of developers. FileMaker user groups One last experience I’d like to share is that of user groups. FileMaker recently started promoting and setting up spaces for user groups inside the community, like my Central Ohio FileMaker User Group (COFMUG) space. This is a unique commitment to grow the community around FileMaker and allow for the entire ecosystem to grow. However, when it comes to FileMaker user groups, there is this phenomenon of “super cities”—where certain cities, like in southern California and Montreal, Canada, hold regular meetings with large groups of developers attending. In comparison, COFMUG struggles to keep a 5-10-person monthly attendance average. What’s more, I recently read about a developer that was trying to start a user group in Maine who was also worried about attendance… My hope is that, with these new community user group resources, the borders in our community will start to blur to the point where simply sharing ideas and concerns matters more than the developer’s geography. Growing the FileMaker community There’s a whole, wide world in the FileMaker community. It’s important for consultants, developers and users alike to start taking advantage of its resources. Explore the FileMaker Community site, attend some of the worldwide DevCon events and join as many FileMaker user groups as possible. Afficher la totalité du billet
  14. MainSpring

    FileMaker 13 & 14 WebDirect security patch

    Even though FileMaker 16 is the current version, MainSpring has supported clients with WebDirect servers since it was released in version 13, and FileMaker server 14 will be supported until September 2018. Because of this, it’s important for us to call attention to the recent security risk that was identified on FileMaker servers 13 and 14. WebDirect security risk discovered Recently, we discovered that due to a lack of a robots.txt file in the WebDirect installation on FileMaker server 13 and 14, the URL of your WebDirect server can be indexed by search engines such as Google, Bing and Yahoo. This could unintentionally grant remote users the ability to visit your WebDirect homepage, and potentially gain access to files in an unexpected way. A robots.txt file is a simple text file that asks any “search bot” that’s crawling a page or archiving information to follow a specific set of rules. While the robots.txt can be ignored by malicious bots, most modern search engines will respect those rules. In FileMaker Server 15+, the server configuration already contains the rules for turning off indexing by default, but you can still install the robots.txt file if you want. How to install the WebDirect security patch So, how do you add this patch? Simply create a robots.txt file in the following directory: Mac: HDD/Library/FileMaker Server/HTTPServer/conf/ PC: C:/Program Files/FileMaker/FileMaker Server/HTTPServer/conf/ Folder path on a windows serverInside of your robots.txt file, input the following code: User-agent: * Disallow: / robots.txt file in the folderNow, save, and you’re finished! This would be a good time to install any updates, and restart your server, as well. Also, it’s important to note that, if your server address was already indexed on a search engine, it may take a few weeks for the bots to revisit your page and refresh their directory. Additional ways to secure your WebDirect server So, here are some other steps you may want to do in order to secure your server… Disable guest access for all files, or at least perform a security check to make sure the guest account has severely limited access Enable the server setting “Show only files for which each user has access to”. This will require a user to provide their username and password in order to view the WebDirect homepage. Make sure to check that none of your files are hosted with the default “admin” account with no password. If so, we recommend setting a strong password and changing the account name from admin to something else. Install an SSL certificate if you do not have one already Other security settings in FileMaker server Afficher la totalité du billet
  15. One of the more common requests we get when building custom applications is the addition of a progressive value list. A progressive value list is something you may see more often than you realize—like when you’re entering an address into your car’s GPS system. Have you ever wondered how it’s able to limit the names of streets based on the house number or the state you’ve entered? Now, let’s break down this concept a little more… What is a progressive value list? A common use case of the progressive value list is when you have a set of fields whose value lists are dependent on previous selections that are mutually exclusive. To explain this further, we’ve created a sample file for you to follow along with using the common scenario of ordering from a menu… How to build a progressive value list in FileMaker In the sample file, our first selection includes a category of proteins to select from. Then, once that choice is made, we’ll choose the protein itself and, finally, the method of preparation. Each selection we make will determine the options available to select for our next choice. In order to display the correct set of options for the previous selection, we’ll need to utilize the option for value lists labeled “Include only related values starting from”. This allows us to set what the first table occurrence evaluates. Simply put, it allows us to dictate whether something is considered related and, thus, will show up in our progressive value list. In our file, we named this the Dinner table occurrence. Next, we create two table occurrences for selection purposes, ProteinSelect and PreparationSelect and relate them to the Dinner table occurrence. From there, we select the category that will produce the available options in the next dropdown, which, in our sample, is the ProteinSelect. Selecting the category sets that field with the ID for the category, which allows the display of only those proteins who have the same value in their ID_Category field to show up. The same goes for our methods of preparation. When we select the protein, we set the ID into the field, which will display only those preparations with the same value in their ID_Protein field as our selection. Finally, in order to ensure the user follows the correct order for selections, we need to set “hide conditions” on our fields so that the proceeding field only becomes available for entry after a selection has been made. Doing so allows us to ensure that the user will always have a valid set of values to select from. Self-order kiosks and apps are becoming increasingly popular. Talk to your development team today about incorporating progressive value lists into your custom app.Adding value (and automation) to your FileMaker custom app Adding a progressive value list is incredibly useful to help usher your users through an automated workflow by setting constraints on what information is available and when. Not only does it cut down on human error, it also allows your users to become more productive by limiting the amount of time needed to manually sort through information. At the same time, this technique involves very little overhead from a development point of view, so this could be an easy, low-cost project for you to implement into your custom app. If you’re interested in talking about this project further, book a time to speak with our Business Development Manager, Chuck Melton. Afficher la totalité du billet