We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Search the Community

Showing results for tags 'filemaker pro tips-n-tricks'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16 Discussions
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform
  • Dungeon

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker

Categories

  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 4 results

  1. Editable FileMaker Pro Virtual Lists FMP tip developed by David Thorp, Article written by Andy Persons *Tested in FileMaker Pro 14-16 Virtual Lists Since FileMaker Pro virtual lists were introduced more than five years go, they have seen wide use due to two primary benefits: flexibility and performance. The whole point of this tip is EDITING values in a virtual list. That's new and fancy and most people believed impossible, until now! Flexibility FileMaker Pro Virtual lists allow us to display information (usually in a portal) in virtually (pun unintended) any configuration we want. We can gather information from a variety of sources and combine them how we wish, without impacting the schema (other than the initial setup of the virtual list structure). Once the structure is in place, we can also reuse it for multiple purposes. Performance FileMaker Pro Virtual lists have another, sometimes crucial benefit: they can be dramatically faster than retrieving data directly, especially over a remote connection. Because developers control what data is retrieved, they can avoid loading unnecessary data; because they control when it is retrieved, can avoid reloading it unnecessarily. This can result in greatly improved user experiences. Limitations However, FileMaker Pro virtual lists have a crucial limitation: because they rely on calculations, they cannot be edited directly. This technique allows us to work around this limitation. This can be applied to any usage of FileMaker Pro virtual lists. For example, you might wish to quickly retrieve a list of contacts in a popover, while retaining the ability to edit names for quick corrections. Or you could display a list of students with their classes in a cross-tab arrangement, with the ability to change their class assignments on-the-fly. Here’s an overview: Global fields are placed over the virtual fields and set to be hidden except for the active row. When a user clicks in a virtual field, the value is entered into the corresponding editable field and the focus moved there. When the user modifies the editable global field, the database is updated. The virtual list is then refreshed to load the changes. The result is that a user can click into the unstored calculation field on the virtual list directly and it will seem like they are directly editing the values. Though this technique was developed with FileMaker Pro virtual lists in mind, it could be used any time you want to create the experience of “editing” a calculation field. Please see the demo file for more details. • • • Download Demo File • • • ENJOY! **This article is provided for free and as-is, use, enjoy, learn, and experiment at your own risk – but have fun! eXcelisys does not offer any free support or free assistance with any of the contents of this blog post. If you would like help or assistance, please consider retaining eXcelisys’ FileMaker Pro consulting & development services. About eXcelisys, Inc.: Founded in 2001, eXcelisys (www.excelisys.com)is an FBA Platinum Partner and FileMaker Certified developer organization. eXcelisys specializes in designing, developing, customizing, supporting, consulting, migrating, upgrading, fixing, and integrating of database solutions for Desktop, Mobile, and Web applications. Our core technology competencies are FileMaker Pro, FileMaker Go, and MySQL for database frameworks, along with FileMaker WebDirect, WordPress, MySQL, PHP, CodeIgniter, PostgreSQL, Joomla, Drupal, Magento, CSS, HTML5, and Javascript for web sites and web applications. Aside from providing eXcellent customer service, our goals are to use these technologies to intuitively automate your organization’s data solution needs seamlessly and flawlessly across the web, mobile, and desktop platforms. Contact eXcelisys today for a free estimate and consultation about making your business more efficient through intuitive and effective software automation. 866-592-9235. eXcelisys, Inc. is an independent entity and this web site/information/blog post has not been authorized, sponsored, or otherwise affiliated with FileMaker, Inc. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries.
  2. FileMaker Pro Progress Bar V3

    V3 FileMaker Pro Progress Bar – Gangsta with Gradients! OK, one last riff on progress bars! The V2 FileMaker Pro Progress Bar demo file showed how to have the bar change color based on the percentage, such as changing the entire bar from green to yellow to red as the percentage increased. That approach has some good uses (showing how full a container is, for instance), but some people had something else in mind: having the bar incrementally change color as it progressed. In other words, a gradient. In the course of solving that problem, I created a native FileMaker Pro 13 gradient generator. Enter as many colors and steps as you wish and the file will create a corresponding 100 x 1 pixel gradient image. You can even specify whether it should use an RGB or HSB gradient. The RBG option is probably what most people are used to, while an HSB gradient will traverse the color wheel on its way from one color to the next. The first sample gradient is a good example to demonstrate the difference. The resulting gradient can be used on its own as a native image or generated dynamically. The progress bar portion is very simple. It takes three parameters: the progress percentage, a background color (in base64) and a 100 x 1 pixel image (also in base64). It then simply reveals the portion of the image as specified by the progress parameter and displays the background color for the remainder. How cool is that! Enjoy! Download Demo of V3 Gradient FileMaker Pro Progress Bar About Excelisys, Inc.: Founded in 2001, Excelisys (www.excelisys.com) is an FBA Platinum Partner and FileMaker Certified developer organization. Excelisys specializes in designing, developing, customizing, supporting, consulting, migrating, upgrading, fixing, and integrating of FileMaker Pro and FileMaker Go database solutions, MySQL, PHP, CodeIgnitor, PostgreSQL, QuickBooks-FileMaker Pro Integration, Excel and MS Access to FileMaker Pro conversions/migrations, iPhone and iPad business solutions, and other various database frameworks and web technologies that automate your organization’s data solution needs for use on the web, mobile, and desktop platforms. Contact Excelisys today for a free estimate and consultation about your business software automation needs @ 866-592-9235.
  3. Double-Single Click Trick

    FileMaker Pro Tip-n-Trick: A Double-Single Click Trick By Andy Persons A nice little FileMaker Pro Tip-n-Trick showing you a double-single click trick! Have you ever wanted to add support for double-clicking in your FileMaker Pro solutions? FileMaker Pro doesn’t currently support that natively, but various workarounds have been created over the years. Unfortunately, none of the techniques I found support exclusive actions. BOTH the single and double-click actions occur when the user double-clicks. This file demonstrates a simple alternative that enables your solutions to perform only one OR the other. This technique and the demo download has been tested and works in FileMaker Pro versions 12 and 13. class="wp-image-1430 size-medium" src="http://www.excelisys.com/blog/wp-content/uploads/2014/12/DoubleClick-300x173.png" alt="FileMaker Pro Tip-n-Trick Double-Single Click Demo File" width="300" height="173" /> Download the free demo file! Although untested, this technique is likely to work in any version of FileMaker Pro that supports both the Get(ScriptName) function and fractional seconds in the Pause Script duration. Click away and Enjoy! – Andy *This article is provided for free and as-is, use and play at your own risk – but have fun! Excelisys does not provide free support or assistance with any of the above. If you would like help or assistance, please consider retaining Excelisys’ FileMaker Pro consulting & development services. About target="_blank">Andy Persons: Andy is a Senior Lead FileMaker Pro Developer with Excelisys: Andy has been an industry leading FileMaker Pro developer creating FileMaker Pro solutions for over 17 years. In addition to being one of the lead developers of three top-rated and most-downloaded FileMaker Pro solutions of all-time; the FileMaker Business Tracker and the Excelisys eX-BizTracker & eX-BizTracker Pro jump-start solutions, he has shared his incredible and advanced talents by authoring numerous Tips-n-Tricks files and white papers, including Hierarchical Portals, Recursive Calcs, Audit Logs and Drag-and-Drop using FileMaker Pro. About Excelisys, Inc.: Founded in 2001, Excelisys (www.excelisys.com) is a dedicated organization specializing in the designing, developing, customizing, supporting, consulting, migrating, upgrading, tweaking, fixing, and integrating of FileMaker Pro solutions, FileMaker Go solutions, MySQL, PostgreSQL, QuickBooks-FileMaker Pro Integration, Excel and MS Access FileMaker Pro conversions/migrations, iPhone and iPad business solutions, and other various database technologies and frameworks that automate your organization’s data solution needs for use on the web, mobile, and desktop platforms. Contact Excelisys today for a free estimate and consultation about your business software automation needs @ 866-592-9235. target="_blank">* FileMaker and FileMaker Pro are registered trademarks and owned by FileMaker, Inc. in the US and other countries. class='bbc_url' rel='nofollow external'>Source
  4. FileMaker Pro Progress Bars, chapter 5: Gantt-Man By Andy Persons In which nothing can Bar our intrepid code from Progressing to Uncharted territory! We received an interesting variety of responses to our FileMaker Pro Progress Bars demo files. Can you make it show an image for the foreground? How about an animated gif? It’s too blurry; can you sharpen it up? Any chance it can do my taxes? One of the requests that piqued our interest was the ability to have the foreground color appear in the middle of the bar. That is, to be able to specify a background color segment, then a foreground color, then a background color. Sure, we could do that, but why stop with a ham sandwich when you can throw a luau? So we donned our grass skirts and created the ability to generate Gantt charts. This FileMaker Pro progress bars demo file showcases our GanttChart() custom function that allows you to specify an unlimited number of segments via a return-delimited list. Each line in the list should specify a percentage (where the segment begins) and the color of the segment (in base64; don’t worry, we also provided a tool to convert from RGB colors to base64). Of course, this custom function could also be used for a host of other purposes, including: Stacked bar charts Dynamic interface elements, where the ability to specify the color on the fly is crucial (since FileMaker Pro’s styling doesn’t allow for that). Possibly even bar codes, although we haven’t tested that one Also, remember you can rotate elements in FileMaker Pro, in case you wanted to use this vertically. Oh and we decided to throw in the autofocus as well by upgrading the base graphic from 100 pixels to 1000. This should eliminate the blurred edges that some users experienced when they expanded the container to very large sizes. Download the demo file and give it a whirl! Hope you enjoy it! *This article is provided for free and as-is, use and play at your own risk – but have fun! Excelisys does not provide free support or assistance with any of the above. If you would like help or assistance, please consider retaining Excelisys’ FileMaker Pro consulting & development services. About Excelisys, Inc.: Founded in 2001, Excelisys (www.excelisys.com) is an FBA Platinum Partner and FileMaker Certified developer organization. Excelisys specializes in designing, developing, customizing, supporting, consulting, migrating, upgrading, fixing, and integrating of FileMaker Pro and FileMaker Go database solutions, MySQL, PHP, CodeIgnitor, PostgreSQL, QuickBooks-FileMaker Pro Integration, Excel and MS Access to FileMaker Pro conversions/migrations, iPhone and iPad business solutions, and other various database frameworks and web technologies that automate your organization’s data solution needs for use on the web, mobile, and desktop platforms. Contact Excelisys today for a free estimate and consultation about your business software automation needs @ 866-592-9235.
×