Jump to content
  • Welcome To FMForums

    Welcome to our community, full of great ideas on developing your FileMaker solutions effectively,  for peer-to-peer support of the FileMaker Platform and related products and services. Register and join the conversation!

All Activity

This stream auto-updates     

  1. Past hour
  2. Nickenich, Germany - (May 21st, 2019) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 9.2 for macOS, iOS, Linux and Windows, the latest update to their product that is easily the most powerful plugin currently available for FileMaker Pro. As the leading database management solution for Windows, macOS, iOS and the web, the FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 9.2 has been updated and now includes over 5800 different functions, and the versatile plugin has gained more new functions: For MacOS Mojave we added new ContinuityCamera functions. Those allow you to start a process where a nearby iOS device is asked to take a picture and return the picture to the Mac. You can use both iPhones and iPads nearby with at least iOS 12. If you have multiple devices, you can show a popup menu to pick one. And you can choose to scan a document, which allows to merge several pictures taken into one PDF document. If you like our data structure functions, you may enjoy the new Matrix functions. They provide you a 2D array data structure which preserves the data type of the values. You can fill them with SQL in FileMaker and query their content as text if needed. As you may know we have printer functions for both MacOS and Windows. For MacOS we got a new set of PageSetupDialog functions to script the page setup dialog. You can select options there automatically and even decide to not show the dialog at all. This allows you to set different paper format for print preview or PDF creation. We added new TextView functions for MacOS, Windows and iOS to create a plugin controlled text field on a layout. This control is independent from FileMaker and doesn't belong to a record or a layout. It features already functions to load and save styled text, RTF and HTML. You can configure it to use the OS provided spell checker. On MacOS if you press command-R in a text area for entering calculation or custom functions, you can see the ruler and we add more tab steps for you. You can press Command-I to show invisible characters. For DynaPDF we added a function to convert colors in PDF pages to e.g. gray scales. You can set PDF viewing preferences, e.g. to open a PDF document with showing two pages at a time. DynaPDF.Initialize got updated for iOS to allow use of DynaPDF library or framework. Our ListDialog functions can show more than one column and show column headers. You can show dialogs for PKCS12 and X509 on MacOS to show details for them. If you enjoy our MapView functions to use Apple Maps in FileMaker, please check the new functions to calculate directions. You can show routes in the MapView and get them detailed as JSON. You can format and parse distances for the user in localized format. Our Drag & Drop control can accept RTF and HTML text data and return it to you. Merging Word files can add a page break in-between. Printing with PDFKit has more options to set. GraphicsMagick can return attributes as JSON and Screen.Scale function tells you the scale of a display. Finally we updated CURL to version 7.64.1, DynaPDF to, SQLite to 3.28.0 and Xcode to 10.2. LibXL is updated to version 3.8.5 for MacOS and for Linux and Windows. See release notes for a complete list of changes. More details in the release notes. Please take the time to check our 500 example databases and check where you can use our plugin features in your solutions. System Requirements: * macOS 10.9 or later, including macOS 10.14 * Windows 7 and newer, including Windows 10 and Windows Server 2016 * FileMaker Cloud (64-bit Linux) * FileMaker Pro 7 to 18 * FileMaker iOS SDK 16 to 18 Pricing and Availability: MBS FileMaker Plugin is available directly from the MonkeyBread Software website with licenses starting at just $149 (USD). You can just download and try the plugin without a license or request a trail license. Not all functions are available in all platforms, please check specifications. Please join us on the next conferences and visit our booth. Monkeybread Software: http://www.monkeybreadsoftware.com/ MBS FileMaker Plugin Website: http://www.monkeybreadsoftware.com/FileMaker/ Function Reference: http://www.mbsplugins.eu/ Download Free Trial: http://www.monkeybreadsoftware.com/FileMaker/download.shtml Events and conferences: http://www.monkeybreadsoftware.com/filemaker/events/ Logo: http://www.monkeybreadsoftware.com/images/MBSLogo.jpg Release notes: http://www.monkeybreadsoftware.com/filemaker/releasenotes.shtml Located in beautiful Nickenich, Germany, MonkeyBread Software is a privately held company founded in 2000 by Christian Schmitz. MonkeyBread Software focuses on the Macintosh, Linux and Windows platforms. With over twenty years as a software developer, Christian's aim is developing unique and useful utilities, complemented by first-class customer support. Copyright 2000-2019 Christian Schmitz Software GmbH. MonkeyBread Software is a registered trademark of Christian Schmitz, Nickenich. All Rights Reserved. Apple, and the Apple logo are registered trademarks of Apple Computer in the U.S. and/or other countries. FileMaker Pro and FileMaker are trademarks of FileMaker, Inc. Other trademarks and registered trademarks may be the property of their respective owners. Greetings Christian Schmitz Monkeybread Software
  3. Today
  4. Two possible solutions come to mind: 1. Have your OnTimer script do one thing every 15 seconds, and two things every 15 minutes (or every 60th runtime). 2. Use a web viewer for showing the current dance (will require some Javascript work).
  5. Also running MirrorSync and today all of the sudden got this 959 error. Uninstalling MS and reconfiguring the FMS 16 server did not work. I had to uninstall everything and reinstall from scratch.
  6. I have this little app that uses google sheets as its base for the data. When the app starts, it runs a script that downloads via insert from url a google sheet and stores it in a container field. it parses it all out into fields etc. As you can see in the pic, the bottom line in yellow shows the current dance. done by comparing current time against another table via join. This value is derived by a InsertOnTimer script that runs every 15 seconds and flushes the join to keep current dance value at the top. My problem is, when there is a change in the spreadsheet (btw this is the clients choice of storage) I need another timer to run in the background that checks every 15 mins or so and notifies there is an update. I have the update script working seamlessly..about 10 to 15 seconds for 810 records and 7 fields, and can do this update manually as well from the preferences screen. I can't for the life of me get the timer to run to check for updates. I understand 1 window 1 timer. I think it would be nice to notify the users of the change in data. I have tried to used the push notification as well...again works but will not kick because one window one timer. And I have read that the timers are windows based and not layout based.. So thanks in advance. it is late here so if clarification is needed just say so. Dave
  7. I didn't initialize the variable before I used it. Add this line: $list = ''; before foreach($showRec as $record){ $data = $record->getField('WBForm_Company_Name'); $list = $list . '<br>' . $data; } (lines 55-58)
  8. Yesterday
  9. doughemi, The record created ... thank you. I get this error though ... PHP Notice: Undefined variable: list in C:\Program Files\FileMaker\FileMaker Server\HTTPServer\conf\5072\c_newrecord.php on line 57 As long as the record is being created I'm good to go. Yes I would like to error out if the record does not create so the customer can see that there was an issue, with some instruction what to do, but I will take this for now. Fantastic. Thank you. ***I did not want to forward the files but I had no choice, the tutorials (many) were useless other than Soliant's php db connection test and I am unable to communitcate to this forum in a manner that you guys require. I can only say, I am sorry. And, I still have no idea what went wrong. I will take time now and study your file; run many test ... Again thank you. I'm going to comment out this error and put pack the thankyou.php. This was an exhausting ... 5 days. To whom it may concern, doughemi suggest that I remove the pdf / files I had to post to resolve this issues, but I have no way of doing this ?? The edit button is not available to me anymore. If anybody has any suggesiton how to do this I would be grateful. Thank you.
  10. Attached is a modified copy of c_newrecord.php which works with your database. You will have to change the name back to c_newrecord.php. The file will echo a list of the Company Name fields in the database each time you run it. The code which does this is marked with comments so you can remove it. You may want to delete your pdf in your earlier post-- TMI on a public forum. I removed the login info from the file, but I made no changes in what you provided. You do not need the .fmp12 extension on the filename. If FileMaker.php is in the same directory as c_newrecord.php, then the relative path is simply FileMaker.php in the include statement. c_newrecord_dh.php
  11. So I navigated over to Soliant and they had a little php to test the connection ... I ran it and adjusted the parameters so that I got the "connected" echo. So I went in an replaced my entries in my php and I still error. I've reattached the form ( index.html ) the create new record ( c_newrecord.php ) and the thankyou.php. The url: https://31.datatrium.com/5072/index.html Any assistance here I would be grateful. I am only pushing in one field from the form at this time. will do the rest later when things work. When I click on the submit button the form action is calling the c_newrecord.php script. This is right from the tutorials I'm referencing. I just don't understand what I'm doing wrong. Thank you. index.html c_newrecord.php thankyou.php Here is the test_connection.php file; test_connection.php
  12. Here is the error that is returned. I've included some other stuff. Thank you. mrignoramus_01.pdf I am going to assume that "pm" means permissions ? I've got a call into the server to check on them. But on my side, I've create the account for the php and I've assignd the php access in the privilege set. So I don't know what else I can check. Thank you.
  13. doughemi, Thank you for the file ... I just returned with what I've done and noticed your file. I will have to study it. I've attached what I've done and I can not get past the $fm variable error. For some reason I can not log into the database. I've removed sensitive log in data but I have tried both the numeric value for the host and the host name; meaning hostname.com and I also tried entering the file name; menaing FileName and FileName.fmp12 I also tried entering both the include and the require_once I keep erroring on line 13/14 I've checked the server to make sure php is on and that the user has been assigned the privilege set for the php ? I'm planning on speaking to the server in the morning to see if there are any privileges not set on the server end ... can any one look at the code I've written and see if I'm doing anything wrong. I would be grateful. Thank you. c_newrecordtst.php
  14. I use Filemaker Pro 14 to communicate with my cabinet shop. I host my databases on a remote server that costs me $55 per month. The total ecosystem consists of three iMacs, three iPads and an i-Phone. The iPads & iPhone are, of course, hooked to the database with FM GO. I am usually fairly slow to adopt new software and new operating systems for several reasons. For many years I was first in line for every hardware and software upgrade. Over time I accumulated a lot of software and a lot of machines. The machines were always smarter than me and the software plenty competent enough. None of the new features were compelling enough to jump ship from what I was working with. Usually an upgrade on a piece of software required an upgrade to OSX. I couldn't simply upgrade one piece of software without upgrading all of the software and sometimes this meant I needed new work stations as well. I would be happy with Filemaker 14 for the rest of my life. My CAD software is out of date but I can play it like a piano. I prefer desktop applications over cloud based solutions. I am also getting a little fatigued by everybody having their hand in my pocket for $70 a month. (The software companies seem to have concluded where price elasticity kicks in) Enough of my rant: MY QUESTION is: Is it possible to add (FM14 compatible) Filemaker Go to to additional iPads if they are accessing FM14 based solutions?
  15. Last week
  16. Because it wasn't created efficiently for that. Keep in mind that you don't have control over the SQL statements that are being sent. FM interprets a user's actions and then tries to create a query to match what you are asking of it. Sometimes it is perfectly fine and other times very very inefficient, depending on what the structure and action given. It is best suited for ancillary activities to a core system IMO. Calculation fields created in FM in the shadow table of your SQL table will be unstored calculations and not indexed. It is better to create the calculation in the view or table in your SQL table itself. As for what UI changes that should be made etc TBH I am sorry to have some bad news for you... It would take a lot more than the forums to create an efficient system. It just takes a lot of experience and trials, a very good understanding of SQL besides just basic SQL selects, and then knowing when to leverage the native SQL system features where you can. Again for things such as simple relationships and simple searching, you may want to give it go as it should be efficient enough. However, if it gets pretty complex then better to find a work around. I would start here and then also read all the additional resource info. https://www.filemaker.com/learning/custom-app-academy/205/external-sql-sources-ess.html
  17. I have recently attempted to upgrade from version 9 to version 11 of FM Books Connector but I cannot successfully registerer the plug-in - I am getting Error 1550, as detailed here: https://help.productivecomputing.com/help/installation-error-1550 I have followed the advice to install, and then un-uninstall and re-install, the Visual C++ 2008 redistributable package, Visual C++ 2013 redistributable package and .NET Framework but this has not solved the problem. I am also being repeatedly asked to install the QB Bridge despite doing so. What further steps can I take to make this plug-in work? Its a Windows 10 Professional machine. v9 was working fine.
  18. Maybe display these emails in a webviewer so that the html code gets displayed properly? I did a google on removing urls form emails and got a lot of responses that had negative results from this. Apparently not as easy to do as it has a tendency to break a lot in the emails.
  19. This is not going to be simple, because Filemaker can divide text only to paragraphs (values) and words. In your example, the substring: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmypcsecurity.webrootanywhere.com%2Funsubscribe.aspx%3FT%3Dasdffsdf34228e3b-77d9-4eb2-8132-778fd4dea454%26UEM%3Dsupport%40madso.uk&data=02%7C01%7Cuser@company.com%7Casd29c4c0901c808d673d792d0%7C7a80fada51274aa9aaedca692e314d1d%7C1%xxx68237670672dddata=0YhXOxZRHF6%2Fls6fY%2BA4za%2BvsGo6dPBtWMQhVQZo%2ByE%3D&reserved=0 is actually 32 separate words, the way Filemaker sees it. So you need to make up your own division - probably by looking for spaces and returns as the only separators to consider. And of course, this must be a recursive process, taking each "token" in turn and examining it for length. In the attached demo, I used a looping script (with 2 loops, one for paragraphs and one for tokens separated by spaces). To make this a calculation, you would need to replicate the same logic using a custom function (or functions). ShortenLongStrings.fmp12
  20. Emails are retrieved as records. And the body of the email might contain something like this: Click this link to unsubscribe from this email: https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmypcsecurity.webrootanywhere.com%2Funsubscribe.aspx%3FT%3Dasdffsdf34228e3b-77d9-4eb2-8132-778fd4dea454%26UEM%3Dsupport%40madso.uk&data=02%7C01%7Cuser@company.com%7Casd29c4c0901c808d673d792d0%7C7a80fada51274aa9aaedca692e314d1d%7C1%xxx68237670672dddata=0YhXOxZRHF6%2Fls6fY%2BA4za%2BvsGo6dPBtWMQhVQZo%2ByE%3D&reserved=0 It's these long strings of text that I would like to remove as they make reading emails difficult (especially when there are multiple emails contacenated). But there are so many different ones that I can only think to do a search by length, rather than a specific substitute calculation.
  21. Then I am afraid I don't understand what you mean by "string". Wy don't you provide an example or two of what's in the field and what you would like to see as the result.
  22. The string(s) could appear anywhere within the field. I'm trying to clean up emails where there's lots of strings from hyperlinks that are in the signatures (usually from the email signature).
  23. Hi all Is there a calculation to remove all long text strings (say anything over 20 characters) from text fields? Thanks
  24. Fantastic!!! Thank you very much guys. Very exciting! API has hopefully solved this for everyone. mr_vodka - is there a specific reason that FM should not be used strictly as UI to build off of SQL systems? Is it just pointless? And what sort of UI changes would be made? What happens to calculation fields? Is filemaker able to recreate them but alongside the SQL table? Thanks
  25. Thank you Joshua (and Jesse). That re-opens the option for us. We still need to think about the (obvious) need to have the modification timestamp field updated for the record to be considered in the sync. But if our calculated field value changes due to a field value change in another table, the modification timestamp will have not been updated and the record will not sync. So it appears that to be sure any changed calculated field value is synced, we would have to forcefully modify the modification timestamp for ALL records in the table. That would defeat the principle of "sync" since it would be equivalent to transferring the entire table every time. So, some more brainstorming to do on our end it seems... But thank you for the offer of a trial license! I will surely get back to you on this in case we want to explore this option further.
  26. Hi Pedro. What comment is saying is spot on. You may be able to get the result you desire but you may have to change the type of UI you use. You can search for "google type search filemaker" and you should come across many posts on the subject. Also quick finds will search all your fields. Perhaps this old thread can help you a little.
  27. Besides having to ensure that your data will fit properly into SQL data types, once migrated over, I don't think you should expect to just use the existing UI and repoint it to the new SQL tables. FM should not be used strictly as UI to build off of SQL systems. You would have to reevaluate and re create some of the UIs to efficiently use via ESS. A bunch of things can be off loaded to the SQL side with optimized views, trigger, and stored procedures.
  1. Load more activity
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.