The document picker copies the document, leaving the original unchanged. The user selects an external destination. Each mode provides a slightly different approach to sharing files between apps: So we implemented UIDocumentPickerViewController class from iOS to provide functions for FileMaker. For iOS we didn't yet have a file dialog function and sometimes people like to pick a file via dialog. Show Custom Dialog ĭocument Picker Functions for MBS FileMaker Plugin For next version of MBS Filemaker Plugin, we added new DocumentPicker functions to our FileDialog section. You can specify column and first/last row to use. So you can do a query once and than let the plugin sum up the values or calculate an average on a subset of the result. We got a few new functions for this: FM.SQL.Max, FM.SQL.Min, FM.SQL.Avg and FM.SQL.Sum FileMaker SQL with Sum, Min, Max and Avg on resultsĪs you may know, you can do SQL queries in FileMaker with MBS Plugin and than get result stored in memory to call other functions on that.