Leaderboard

A single table might have up to four layouts to present its data: List view (for quick reviewing of records) Print view ( a black & white view for printing) Search form ( holding all the fields in the table Users can search) Detail view (form layout used for editing a record) We've all known for years that we can hide things in sub-summary parts and only display them if properly sorted but now in 14, you can potentially use a single layout for list , searching and editing. In 14, navigation bars allow scrolling in form view and we can take advantage of this by using the Title Footer (or Title Header) to hold our 'form'. A simple switch from list view to form view can provide Users all the fields they need. The title footer can hold portals, tab controls and anything else you would place on an editing or find layout. Related records placed in the Title Footer are not fetched until switching to form view so they have no weight until displayed (just like popovers, tab controls and sliders). In the attached sample, layout triggers assist by switching to form view if in find mode and switching back to list view after a find. I have hidden the list view fields and labels when in form view to simplify the view. The benefits? Less layouts in a solution Light weight No need to switch layouts (which might fire triggers) Endlessly scrollable form view (not limited like popovers and sliders) Potential issues? Yes. The header is only one line tall in my sample (holding the list's labels). If you need a vertically-tall header for the list view then this approach might provide too much 'unavailable' space at the top. And switching the process later would not be simple task. I hid the header labels and fields in the list which makes it a bit more work to design (although minimal). You might wish to let them display and only provide additional fields below. This is just another useful, simple tool for our toolkits. BTW, I have specified 'not applicable' on the FM version because 14 hadn't been added as an option yet. Also, this new forum software doesn't allow a title or subject - only accepts a valid file name.

This technique was inspired by @Claus Lavendt in a tweet. Now with offset new card style mode you can now create a tool pallet to interact with a document in preview mode

Here is an example of a modal transactional popover on *list view that I created when 13 first came out. It uses Get ( RecordOpenState ) to lock the popover in place if a change is being made, eliminating the need to set global variables or fields. I'm including a screen shot so those with older versions can see what is possible in 13. It can come in handy if on ipad since we can't open modal windows. You can provide this popover with more details but allow User to scroll the list. If they DO change data, only then does the popover freeze which then requires button to exit. And since there is transparent button over the popover, the user cannot commit the record until time to exit, which provides transactional control and revert for portals - all only when finished and a save is requested. * The number of records in list view should always be kept at minimum in any technique. If nothing else, and if you wish for a good laugh, go through the people in the list. They were people who applied for the 'ugliest person in the world' contest. The data is dummy data. I enjoyed putting it together and I hope others find it worthwhile and humorous as well. :-)

Security Changes And Enhancements In FileMaker® Pro 21 By: Wim Decorte and Steven H. Blackwell The recently released FileMaker® Pro 21 new version continues the efforts of Claris/FMI and several members of the FileMaker Developer Community to enhance and improve the Security features in the products. In this White Paper Wim Decorte and I will discuss much of the Security information relevant to this new release as well as some aspects of other recent patches issued by Claris. Much of the specific discussion in the White Paper focuses on items within the purview and control of the developer, rather than of Claris, and thus it warrants more attention. These deal with issues that could cause an Escalation of Privileges for Subordinate Level Users.

This is essentially a port of WORDLE built-in FileMaker there are many who are addicted to this daily challenge.

Hello, Here is a file that allows - To have a foot in the final page, the very end of the last page. - To manage page breaks and reorganize its document the version fp7 it is the "ligth" version, the version fmp12 ( you will find here ) adds the ability to make pdf via a "robot filemaker" with WebDirect and go one can easily transpose it into any database. Do not hesitate to create records, test and tell me any bugs or curiosity. The file is opened 100% and any feedback is welcome! v9 - v14 Compatible.

This sample file was designed to generate a Table of Contents from a sub summarized report. In FileMaker there is no inherent way of knowing what sub summary part exists on which page as this information is only displayed when in preview mode. There are two versions of this solution one with JSON and one without - I over engineered the first one with JSON - and then revised it to remove JSON - as it wasn't necessary. How this technique works. On the report layout in the header and footer there are some button objects each has a Hide object when calculation that declares a $variable by use of the Let function that evaluates when a script is running. Once setup the script uses the $hState, $hPage, and $hRec and compares them to the same variables in the footer - to determine if a summary part spans multiple pages. In order for this to work you have to be in preview mode and the script must pause for the at most a second i enter .001 but its somewhere between that and a full second. This gives the script enough time to evaluate the variables, and then it loops thru testing each record it finds on the page by comparing the $hRec and the $fRec which are the starting record number and ending record number on that page and then loops thru each page. After a bit of transformation of the data it generate a table of contents by use of a Virtual List. Then it computes the how many pages the Table of Contents there are and offsets this value for every page of the report then it will output a PDF to the desktop firstly the Table of Contents then append to that PDF the report itself. Since this technique relies on preview mode - it can't be used on server (server can create pdfs but doesn't have preview mode so can't get the page number.) Because it also pauses for each record it would not be ideal for super large report.

This tool is for the mapping and testing of JSON API calls. The user can first map, capturing a list of names returned within a result set, and they then can also import a mapped result set to compare to their own solutions result set for the purposes of trouble shooting.

Wim Decorte and I are pleased to release another White Paper in our on-going series about extending OAuth2 and OIDC in the FileMaker Platform. Addendum 6 Comparative Analysis:Providers and Operating Systems provides an overview of the many options among various IDaaS (Identity as a Service) Providers and Brokers and various versions of FileMaker Server, both on-premise and Cloud-based.

Wim Decorte and I are pleased to announce release of Addendum2 in our oAuth series for the Claris FileMaker Platform. This one focuses on the use of the OneLogin IDaaS service.

Wim Decorte and I are pleased to release an Addendum to our recent White Paper entitled How FileMaker Developers Can Extend Authentication Options With New Additional OAuth2 Identity Providers In The FileMaker Platform. This Addendum has some additional technical details for FileMaker Platform developers and server administrators. It also has two Case Studies about where variations of these techniques are in place.

FileMaker® Server 16, introduced in April of 2017, brought with it the capability to use three oAuth2 Identity Providers to authenticate Identity Assertions made in attempts to access hosted FileMaker® Pro files. Google, Amazon, and Microsoft® Azure AD were the three Identity Providers. Since then various members of the developer community have sought ways to expand beyond those three providers to employ other Identity as a Service (IDaaS) options. Wim Decorte and I are pleased to advise that we have succeeded in an effort to expand the available Identity Provider services to additional systems. We have documented the underlying mechanism that FileMaker Server uses and have identified at least five new major IDaaS providers whose oAuth2 capabilities we can leverage to permit their use in the FileMaker Platform environment. We hope this means, among other items, that the FileMaker Platform can now be used at locations where heretofore it was disqualified due to lack of support of these Authentication options. We were aided in this endeavor to a substantial degree by assistance from Claris International, Inc. (formerly FileMaker, Inc.) working in a customer environment. This ratifies to a substantial degree the maxim postulated by well-known business author Tom Peters back in the 1970’s that “Innovation doesn’t come from the R&D Department; it comes from the customer base.”

What is LatitudeZERO? LatitudeZERo is a free FileMaker Developer Tool that lets you calculate distances between latitude and longitude coordinates right from within FileMaker. LatitudeZERO is a set of FileMaker custom functions that you can easily incorporate into your own FileMaker solutions. The custom functions let you do a number of tasks such as calculate distances between two coordinates, determine if a coordinate is within or outside of a certain radius, convert distances to miles, kilometres or nautical miles, calculate the bearing between two points. With LatitudeZERO you can: Calculate the distance between ZIP / postal codes – (requires geocoded data) Calculate the distance between coordinates – (anywhere in the world) Show a list of customers within a certain radius Show the closest sales rep to minimise travel time and more … More Information To download the latest version, or for more information visit: FileMaker Developer Tool - LatitudeZERO Code-X was developed by Hi-Voltage, you can visit our site here: FileMaker Programer Melbourne Checkout our other FileMaker related products and services here: FileMaker Products and Services

What is CalendarBOX? CalendarBOX is a free customisable date-picker for FileMaker Pro. Use CalendarBOX within your own solutions to select dates via a pop-up window or use the code to incorporate the date picker within your own layouts. Choose from a single date picker or a date range picker which is ideal for reports. CalendarBOX is an unlocked FileMaker Pro file, allowing you to modify it any way you please and include it within your own FileMaker solutions. CalendarBOX is easy to use, easy to install and requires very little scripting. More Information To download the latest version, or for more information visit: FileMaker Developer Tool - CalendarBOX Code-X was developed by Hi-Voltage, you can visit our site here: FileMaker Programer Melbourne Checkout our other FileMaker related products and services here: FileMaker Products and Services

This White Paper was originally released in conjunction with FileMaker® Pro 10 in mid-2009. It still contains information useful to understanding the processes that are part of the File Recovery feature in the FileMaker Platform.

A friend asked if I could help with a Reservations App for her new Camp/Caravan site, it only has 5 van pitches and 10 tent pitches. I couldn't find a free one and as this is her first steps did not want to recommend a big spend solution for something that would only be used as a standalone on a MacBook. So I struggled for a week or two with FileMaker, and the great help from the Forum questions and solutions. So thanks everyone, you have helped a newbie make something that seems to work. I guess that I have done everything wrong/badly but I eventually enjoyed the experience. This is where I step away, if you find it in anyway useful as a learning experience or whatever then that's enough. (Oh you may want to change the archive/backup folders referenced as I pointed those at a Box Sync folder.) Thanks.

Hi, A very simple example of a progress bar that updates itself without any field, plug-in, custom function. Just copy the object on your window and it works! Jos Hofman

Hi guys, this is a sample to show how to make a notification system in FileMaker 13 using a Slider.

As a consultant I strongly discourage to clients NEVER to print partial sheets of labels for the sake of saving the few pennies on leftover labels, when it could end up costing hundred or thousands of dollars fixing a printer should the label decide to affix itself to the inter workings during printing. However with all caveats in place here is a technique to print the found set or current record and account for the 'missing' labels so that the labels will shift to accommodate them. This technique utilized the Virtual List concept to generated the output.

This is a FileMaker Solution that provides user to search in multiple columns/individual columns by multiple ways. The solution is developed in FileMaker pro 12 Some Salient Features of FM solutions-Advance Searching: FileMaker ExecuteSQL inbuilt functions to make some simple ways for searching data No external plug-ins required to search data Working fine in FM pro 12 & 13

"Custom User Login Template" is a FileMaker Solution that provides user to use custom login process of user rather than to use default FileMaker user login dialogue. The solution is compactable and workable with FileMaker Pro 12. Silent Features of Custom User Login Template: - Provides a way to use custom login process without using default FileMaker login dialogue - It also demonstrates how to show password characters as asterisks dynamically while logging in to FM application. To discuss about our FileMaker service, expertise and how we can help you, please contact us on E-Mail or call 1-248-686-1424.

"Sort Portal Rows" is a FileMaker Solution that provides user to sort his portal dynamically by multiple ways. The FM solution is compatible and workable with FileMaker Pro 12. Silent Features of Sort Portal Rows Solution: - The portal rows are getting sorted by sort fields - User can sort portal rows according to the selected value from a custom value list - Each custom value re-presents a column field so based on the field's value the list of keys - Portal rows can sort by selected value from the value list of exact field name - Portal rows can sort by selected value from the value list of Custom Value - Portal rows can sort by selected value from the value list of Portal Header To discuss about our FileMaker service, expertise and how we can help you, please contact us on email or call 1-248-686-1424.

FileMaker requires you to be on a layout or use the relationship to establish context in order to create a record in a given table. You could us a plugin that uses SQL to create a record in a table or you can use this technique. It's very simple. From the Source table you export field context the primary ID field to a text file. I choose to export it to the temporary directory path. Then you immediately import that same file in to the target table --- That is right you do not need to be on a layout that tied to the base table occurrence -- you could be on any unrelated table. On import you adjust the field map to import the value of the text file into the foreign key field of the target table. In this example it is a different take on a Note Log. You can type into a global field and on exit it will trigger the script to export and import that one record then clears the global field. Data entry options in the note field in the target table is defined to use the value stored in the global field. you could choose to do things more elaborate like either exporting more columns of data by building a tab separated values to a global field and export that and import it into any table matching field names (provided your first row includes field names - and you omit them on data entry ) OR you can set variables to the desired values and then on the target table set the data entry options to the corresponding variables. And if you choose to include data other then the ID fields you may wish to also delete the file you can do this by un checking the Specify Field checkbox on the Export Field Contents script step. ================= Now with all this established I realized that this technique will not work on FMGo because the exporting of the file. So there is also another script layout and table that will in essence do the same thing and it only needs to IMPORT one record from a temp table and doesn't need to export. I actually like this method better; but kept both concepts in the sample file for you to explore. Cheers Stephen

This is a modification of comment's sample file found here: http://fmforums.com/forum/topic/71867-getting-more-out-of-filtered-portals-2view-selected-child/ This version uses custom functions to manage the selected values in a single global variable, and a calculated field/relationship instead of a filtered portal. The goal was to provide access to the selected child via a relationship, and to define a default selection, if no child has been selected. This should work with versions older than 11, but I didn't bother to test with any older versions of FileMaker.

This SQL code generator will generate ExecuteSQL() code for FileMaker allowing you to use unsafe field names and make changes to database schema after making the code. If you have feedback of any kind such as bugs or feature requests please visit the support topic for this file. UPDATE 5/23/2012 Code window opens at start up Disabled field name check at start up. No bug fixes ( please send bug reports in the support topic ) UPDATE 5/23/2012 Added Settings page Added Loading page Fixed bug in code window UPDATE 5/16/2012 Misc bug fixes and UI tweaks UPDATE 5/15/2012 Table and Field ID's are now tracked allowing for auto repairing of table and field names after schema changes Misc bug fixes and UI tweaks UPDATE 5/13/2012 All new UI Support for more functions UPDATE 5/9/2012 (v1.0?!) Support for FROM and Right JOIN Table Aliases Misc. bug fixes Tweaked the UI UPDATE 5/5/2012 You can now group by a field without displaying it in the results Added JOIN Example UPDATE 5/4/2012 Added a Statement Creation Wizard ( v07 ) Improved Dynamic Parameters Support. ( v0601 ) Support for Dynamic Parameters. UPDATE 5/2/2012 ( Back From Vacation! ) Starting Value navigation buttons. Output code display options can be set at the bottom of the details layout. UPDATE 4/29/2012 Added warning icons that show up if a field no longer exists so that schema changes can be easily tracked down. Added starting value and maximum results in the results window. UPDATE 4/25/2012 Fixed "AND OR" Bug Insert functions into select field lines Adding a function to a WHERE line will change it into a HAVING line Manual entry will populate when entered on SELECT and WHERE/HAVING lines UPDATE 4/24/2012 Fixed bug in ORDER BY Table Occurrences are now all that is needed to populate the field list. UPDATE 4/23/2012 Added "Get at Date or Time" Check box for SELECT lines and an example of how it works. Statements can be assigned categories Simplified the code when there is no JOIN statement Code now has formatting to make reading the code easier Dropped the use of Quote() and now use escaped quotes You can attach a sub-query when using "WHERE IN" by clicking on the icon to the right of the value field UPDATE 4/22/2012 More Unsafe Names UNION drop down menu and examples showing how to use it. Documentation Thanks for the feedback so far...

A couple of weeks ago, we posted our solution to cross-platform Skype calling from within a Filemaker database. We were pretty pleased with it for our database solution as it allowed us to utilize our Skype subscriptions directly no matter whether we were using a Mac, PC or iPhone. But it wasn't quite perfect. So, we've worked on it some more and now it will send a SMS from Skype, and if you're on an iPhone it will send a SMS using the Message app and make a call using the Phone app. Check out the solution attached, and a PDF of the script as well as the attached demo file are available here: http://www.soundsessential.com/blog/42-information-technology/filemaker/72-filemaker-pro-cross-platform-skype-part-2-sms-iphone-calling Again, hope this helps with your solutions.