Popular Content

Showing most liked content since 03/24/2017 in all areas

  1. 3 likes
    Hey everyone, I love how open the Filemaker Community is, and how much is shared freely, so I wanted to contribute. I created a database to manage SVG icons. The icons are all royalty free provided by Syncfusion and there are about 4,000 icons, all with search tags to make finding them super easy. You can find out more about the file, and download it here: http://www.indats.com/2015/06/15/indats-icon-manager/ Please let me know any feedback you have on the file, thanks!
  2. 3 likes
    Stacey Chamblee has a modified FMEASY Signature that is moddified to work on windows. Here is the link if that helps. https://www.dropbox.com/s/p79mjv6g1rnypwn/FMEasySignature-Mac%26Windows.fmp12?dl=0
  3. 2 likes
    Clearly the file was damaged and in order to make it open FM had to delete large chunks of the corrupted file. In this case that were data blocks. Nothing much that can be done with it. You can try to recover with different versions of FM. You can try to recover on Mac and on Windows. Those are all long shots but you never know. What it really points to is that the file was used in a manner that led to this corruption. Very often that is because of OS-level file sharing, AV scanning,... If you have other FM files in use, carefully scrutenize your deployment to make sure you minimize the risk that other files will get damaged.
  4. 2 likes
    You could write simply: If ( CountryAbbreviated1__lxt = "CA" and ( StateAbbreviated1__lxt = "NU" or StateAbbreviated1__lxt = "NT" or StateAbbreviated1__lxt = "YT" ) ; "Territory" ) Or, if you prefer a shorter version: If ( CountryAbbreviated1__lxt = "CA" and not IsEmpty ( FilterValues ( StateAbbreviated1__lxt ; "NU¶NT¶YT" ) ) ; "Territory" ) I see no good reason to use the Let() function only to rename your fields. I also don't see a good reason to use such gobbledygook field names to begin with. And the numeric suffixes raise a red flag: if you're using numbered fields, you almost certainly have a structural issue.
  5. 2 likes
    Hope this link helps https://github.com/timdietrich/fmeasysignature
  6. 2 likes
    In addition to the invoice example that Bruce mentions, I would also recommend looking into emerging techniques like the "selector connector" that has been discussed. http://www.seedcode.com/filemaker-data-modeling-with-selector-connector/
  7. 1 like
    Hi all I am writing this post because I would like to share a custom function I created for generating EAN-13 barcodes. As almost every other (paid) solution involves plugins, scripts, fonts or other garbage, I decided to create something much cleaner. Everything the file needs is two custom functions, one that calls the other. The first, "GenerateEAN13_Raw" creates the binary string starting from the actual number, and the second, "GenerateEAN13_BMP_380px" takes the same number and generates a BMP file (that can be stored in a container) with the actual rendered barcode (sharp and clear). It took me many hours to create this, so I hope this will be useful for somebody. I just wanted to post everything to FMFunctions but the site is currently down. I know someone should not trust unknown download links, but I'm not attaching viruses here. The proof of concept is hosted on my site here: Download Feel free to use the code as you wish. No, this is not for UPC or other barcodes, just EAN-13. You can take the basic idea and then make yours. Some of the code was inspired by another solution, but in the end I had to recreate even the BMP header from scratch.
  8. 1 like
    I agree with Wim.... as I also posted above. Is it always easy ? - no, of course we all run into clients and people, who don't understand or who have a belief that some other platform is better. However, the FileMaker platform is still very much alive and growing. That is after more than 30 years in the market. Something that can't be said about many other platforms. Personally I work more than full time - in fact 10-12 hours a day, 7 days a week and I have trouble keeping up with all the projects. But, if you have doubts about the platform, it would be interesting to hear your arguments...
  9. 1 like
    No to what? I know some of the folks that responded here personally and we all make a full-time living of working with the FM platform. At the company I work for I lead a 25+ team of full-time FM developers. So the question of "Is anyone making a living off FM?", the answer is a resounding: "yes!" So I'm guessing you're answer is more in the realm that you don't believe in FM's future? Care to elaborate?
  10. 1 like
    Hi bradQual, First, the parameter you pass into EmailReadMessageValue should be "attachments" instead of "attachments=true". EmailReadMessageValue("attachments") returns a return-separated list of paths to the attachments for a message. You will then need to loop through this list and call EmailReadAttachments(path) in a Set Field script step for each value in the list. This will put the attachment at (path) into the container field. You would either need multiple container fields or create a new record for each attachment. Storage options are entirely up to you. A side note, I highly recommend against modifying the Example Client. It was set up specifically to not download attachments at first and then download them on demand when a message is viewed. As you have discovered, it becomes quite convoluted trying to modify it to do exactly what you need. In my experience with other customers trying to do this, you will save yourself time and heartache by using the scripts as a general guide and then creating your own data structure and writing your own scripts in your solution.
  11. 1 like
    Yes, it essentially does whatever a keyboard can do. https://hbase.net/2012/12/18/building-a-barcode-system-in-filemaker-pro/ https://dbservices.com/articles/filemaker-barcode-techniques/
  12. 1 like
    This may be helpful. http://msnmedia.com/blog/2015/04/10/geocoding-and-mapping-module-filemaker-pro It is definitely possible to do what you are looking for. You may need to tweak this a bit. But definitely not too terribly difficult.
  13. 1 like
    I was having a hard time getting something to work with CURL. As is one of the best things about the FM community is a lot help, but Josh finally got it right (and it was not an obvious solution). THANK YOU JOSH!!!
  14. 1 like
    OMG , this WORKED!!! I don't get what I was doing wrong but I'll take and and give THANKS!!!! I have version 3.3.4 of the Base Elements (download just a few days ago. Funny how although it's listed as a GET function in the API docs...it's POST that got it to work. Really appreciate it Josh. I didn't have the funds to spend on this and was about to abandon the project. I am very grateful to everyone who contributed and I hope this thread helps someone else who runs into this any curl issues... Alfred P.S. I would have sworn I tried that combo... but after a while it's get overwhelming to remember exactly everything tried....
  15. 1 like
    I used that function and it worked fine for me. No need to do anything else. Set Variable [ $result ; BE_HTTP_POST ( "http://api.easysendy.com/ver1/listAPI"; "api_key=101ab54dbdad0ddeabfeb648f914c0b8bca616e3&req_type=allLists" ) ] From there, I could do whatever I wanted. But it returned to me the same list as you demo'ed earlier. What version of the plugin do you have installed?
  16. 1 like
    You can't open a remote file. The ActiveX interface is limited to local files. You can however open a local FM file that has a file reference to the hosted file and open it implicitly that way. You can also use the FMP URL protocol to open a hosted file directly and not bother with the ActiveX interface.
  17. 1 like
    A couple of things could be the issue: - SQL queries are case sensitive whereas native FM finds are not case sensitive. So if the _id_assigment is not numeric that can cause a discrepancy. - if you use PSoS to do the query but the user has not committed the record yet then server does not know about it and will return the results minus the user's record. So always do a commit before the SQL query.
  18. 1 like
    Have you considered it might be your data that's the issue? Or the $_id_assignment variable? I'd recommend simplifying the query so you can run some tests in the data viewer and/or in a test script. In said script, I'd create the query in a variable (e.g., $query) so I can see it in the data viewer.
  19. 1 like
    Your expression is a tautology, because if the current user is Matt, then it isn't Haley - so at least one of the OR'ed statements will always be true. Try instead: Get ( AccountName ) ≠ "matt" and Get ( AccountName ) ≠ "haley" and Get ( AccountName ) ≠ "kristen" or (same thing): not ( Get ( AccountName ) = "matt" or Get ( AccountName ) = "haley" or Get ( AccountName ) = "kristen" ) or shortly: IsEmpty ( FilterValues ( Get ( AccountName ) ; "matt¶haley¶kristen" ) ) --- Of course, a better solution would be to assign Matt, Haley and Kristen to a different privilege set, and base the test on that. Then you won't have to remember to modify your layout every time you make changes to the staff.
  20. 1 like
    I am agreed with comment, use a relationship and then on the parent table, make a calculation field with "Count(field)" function which counts the field from the child table (the one used for relationship, this can be your filtering criteria). If you need more than one filtering criteria, then add more TO of the child table and use a new field for the relationship.
  21. 1 like
    Hi Sarah, Thanks for the edition. It is much clearer now. Please have a look at attached file and see if it does what you need or not. Regards, Timesheet copy Copy Copy_V1.fmp12
  22. 1 like
    Is your portal filtered on its own? If yes, can the filtering be reproduced by using a relationship only? In general, portal filtering works on layout-level only, and it's difficult (though not impossible) to get the result at the data level (where calculation fields operate). If you really need it at data level, you probably don't want to accomplish it using layout-level measures, because that will only work on that specific layout, and depend on that layout remaining unchanged.
  23. 1 like
    If you're thinking 'bandwidth' as in network throughput then that is rarely a bottleneck. Processing power is. Or in the network realm: latency. Having filemaker servers that are more local to the users makes sense from that perspective but not from a pure bandwidth perspective. server-to-server syncs can be done but it is a ton of work and requires an extremely stable and monitored deployment; so do it only for the right reasons and start by monitoring your current bottlenecks so that you don't try to solve a problem that doesn't need solving. The go-to product for this kind of server-to-server sync has been SyncDek; now rebranded to http://www.syncserverpro.com/ I do believe that MirrorSync also offers server-to-server sync. I definitely would not use FMEasySync since it is an abandoned product; for this kind of thing you need something that offers support.
  24. 1 like
    First thing you should do is rename the 6 Total Premium field to a valid name. The next step depends on whether the brackets and the associated rates are constant and will never change, or can they be updated at some point (as is often the case with inflation and fluctuating markets). If they are constant, then use the Case function along the lines shown by Steve Martino (except you could reduce it to = Financed Monthly Amount * Case ( Total Premium < 2501 ; 1.06032941 ; Total Premium < 5000 ; 1.05 ; Total Premium < 7500 ; 1.04 ; // more brackets here 1.03 ) ). Otherwise you will need to lookup the rate from a table of current rates into a local field, where it will be protected from future changes.
  25. 1 like
    The installer log files are at /tmp/360Installer.log, as well as /Library/360Works/Internal/Logs/stderrProscTomcatDaemon. If you want to send those files over to support@360works.com, somebody here can review them. On your second question, yes, it is OK to share the same db on the same device as long as there is no record filtering.
  26. 1 like
    Use this, I created it myself. It's available for free. http://www.mc128k.info/2015/12/codici-a-barre-su-filemaker-con-una-funzione/ It generates a BMP for a container field, I believe paid solutions use the same technique.
  27. 1 like
    HI RJS-IT, The error you are getting means that Java cannot complete the SSL handshake because the mail server you are trying to connect to either has a self-signed certificate or the certificate it has is not part of the Java trust store. Try adding the "forceTrust=true" parameter to the EmailConnectSMTP function call. This should force Java to trust the SMTP server's certificate and complete the SSL handshake.
  28. 1 like
    Hi Mike, Yep, there's no way to do that currently, nor will there be in v16 afaik. Why do you want to have one header across all layouts? For a menu?
  29. 1 like
    Basically, you have two options: 1. Import the file twice, once into the Payments table and once into Orders. In each table, define a Type field and set it to validate by calculation: Self = "Payment" and: Self = "Order" respectively, validate always. When importing, map the keyword to the Type field. 2. Import into a temp table first, then do a find for each type and import the found set into the corresponding target table. Both options can be scripted so that the user only needs to select the file.
  30. 1 like
    Hi again... Could you provide an updated ETA on an update that won't require Java 6? We have a major new release of a vertical market product in a couple months and really need to leave the Java 6 thing behind... I'd like to avoid figuring out an alternative to our custom ScriptMaster plugin if at all possible! Soon please soon!
  31. 1 like
    No You could have the second popover somewhere else and have a button on the first popover open the second popover by object name. If you did this, the first popover would close and the second one would open.
  32. 1 like
    Hello Ralphonse, The file is simple but it contains two custom functions. Those functions aren't in standard Filemaker and that's probably part of the problem. The file also appears to use the ScriptMaster plugin for Filemaker Pro. It's a freebie I think and available here: http://360works.com/scriptmaster/ To get those custom functions into your database you need to use Filemaker Pro Advanced and copy the functions from the QR Minimal file into your own file. Be aware that I only did a cursory examination of the example file. There may be more at work here.
  33. 1 like
    Well, yes and no: Gradation also means the passing of one tint or shade of color to another, or one surface toanother, by very small degrees, as in painting or sculpture. Although, given this is one colour directly to another (due to the way the sliders have been used), 'hard' may be an accurate modifier...
  34. 1 like
    A while back I wanted to see if I could emulate the UI of Reeder3. While not very practical, there is a bit of an illusion that is kind of interesting. The sample has two layouts. The one you see in the gif and another with actual data. Enjoy RIVET 3 panel slider.zip
  35. 1 like
    "you have to click the button and then click anywhere else in the layout" You need to add a commit record statement after the set field statement.
  36. 1 like
    I have 4 layouts for a form that we print and the script goes to the layout for the form 4/6/8/12 depending on the data (wells) in the record. It turns out they need to batch print and its convoluted to write a print a script to switch layouts in an automated fashion. So I had revised it by using hide object when and stacked all the elements up on the layout but it turns out to be rather ugly in layout mode. this was using repeating fields in order to get the desired data to show. But then i decided on a better method - using button bars and hide objects. This essentially does the same thing but much easier to see in layout mode. Now I can write a script to print the found records and the proper form will print based on the data The segment or button bar will hide based on the record type, and the data displayed is also calculated and evaluated on the fly.
  37. 1 like
    There is a technique for pop-over buttons that are not attached to a specific button. It's described here: https://www.gomainspring.com/simple-time-savers/building-a-modal-dialog-using-popovers/ From within your first pop-over button you could use the GoToObject script step to open the second pop-over. Then use OnObjectExit to restore the first one. This would be a switching between two pop-over buttons though, nothing layered. Come to think of it, you could do that with two normal pop-over buttons too... :-| HOWEVER, with method above, a transparent pop-over area stretching your entire screen, you could probably "fake" a second layer to your objects placed within by help of show/hide and conditional formatting...
  38. 1 like
    H, You have to choose where you want the Popover to display, i.e. Top, Bottom, Left, Right, but if it can’t display because of space, it will move the displayed position. I think the second question was answered in the first question response. Let us know if it something else. Lee
  39. 1 like
    Hey, Just wanted to let everyone know about a little module we put together for geocoding and mapping. Simple to install and free to download. I'd love to hear what people think. http://msnmedia.com/blog/2015/04/10/geocoding-and-mapping-module-filemaker-pro
  40. 1 like
    Hello all Here we've posted an example FileMaker 13/12 calendar. You can download it for free and use it in your own code. Go here to read blog post. Have fun! The igeeks
  41. 1 like
    Just added a blog post on what you get from Custom Function parameters... http://www.soliantconsulting.com/blog/2013/11/custom-function-parameters-value-or-reference
  42. 1 like
    Hello all A short blog post you may find useful: improved PatternCount searches: http://www.igeek.co.uk/blog/66/FileMaker-Improved-PatternCount-Searches.html Thanks, The igeeks Twitter: igeekUK
  43. 1 like
    The technique described is OK, but we've had FilterValues since FileMaker 7. Rather than: PatternCount ( "¶" & List ( cListOfJobIDs ) & "¶" ; "¶JOB11333¶" ) You can do this: FilterValues( List ( related::JobIDs ) ; "JOB11333" ) The result will be the text you searched for, rather than a boolean. You can then test for IsEmpty. Another nice thing about FilterValues is that you can test for multiple values at once. PS: your original formula was missing that second ampersand. PPS: note that single pilcrows no longer need quotes since FileMaker 7. PPPS: it seems likely that cListOfJobIDs is already a list, so you wouldn't wrap it in a List function.
  44. 1 like
    “What's in a name? that which we call a rose,
 By any other name would smell as sweet.” —Juliet (Romeo and Juliet, Act II, Scene 2, William Shakespeare)— “The beginning of wisdom is to call things by their proper name.” —Confucius— An entire series of recent studies published by well-known and well renown international security analysis and information industry firms have all made, in slightly varying language, the following key points: Data housed in files in organizations are under relentless and persistent attack by a variety of threat agents including criminals, nation states, so-called “hacktivists”, and disgruntled current or former employees.Organizations of all different sizes are vulnerable; however, smaller businesses and organizations are particularly susceptible to data breaches because they have fewer resources with which to protect themselves and are often in the supply chain of larger organizations that may house particularly valuable data. This is not to say that smaller organization themselves do not also have the same type of particularly valuable data.Financial gain, industrial espionage focused on the theft of intellectual property, and embarrassment or disruption of organization activity are three principal motivations driving threat agents to undertake attacks that result in data breaches.The data are the target, not networks or web sites, or other digital infrastructure items. It’s the data.The data housed in FileMaker databases and resident in organizations using FileMaker Pro and FileMaker Server fall squarely into this realm. So contrary to Juliet’s assertion, we need to adopt the Confucian approach and call this by its proper name. FileMaker databases are susceptible to attack, and the data in them can be compromised and stolen or altered or manipulated by unauthorized persons. The sooner the community recognizes this, and the sooner developers and administrators recognize this, the sooner we can begin a serious and focused discussion about how to identify the likely attackers, identify what vulnerabilities in the software they might exploit, assess the likely risk of their doing so, and develop plans to mitigate the adverse impact of successful attacks. What type data are vulnerable? The answer is: all types. Some categories are more valuable than others; these are likely high on the list of any attacker. Financial data, personally identifiable information, intellectual property, business process information, and organizational IT data are major targets. What type organization is most at risk? Both small and large organizations in the for-profit, the not-for-profit, and the government and education sectors are targets. While certain types of attacks tend to focus on different sized organizations, all are vulnerable. And since smaller organizations frequently lack the resources or the processes to protect themselves, they can be especially hard hit. FileMaker Pro database systems can be found in every type organization imaginable of every size and description in well over 100 countries on seven continents. Some of these databases are well-defended; others are defenseless. We in the developer community are lagging in our efforts to address the seriousness and pervasiveness of the threats to FileMaker databases found in all types of organizations, large and small, across a range of business segments. One sentence in one of those reports[2] I referenced at the beginning of this post stands out as a stark reminder: “Some interpret attack difficulty as synonymous with the skill of the attacker, and while there’s some truth to that, it almost certainly reveals much more about the skill and readiness of the defender.” It’s time for the developer community to get busy about and to get serious about protecting information stored in the systems we create. What information do your clients have that needs protecting? And what happens if you don’t do that? We will explore those two questions, along with how to determine threats and risks, in coming entries on this BLOG. Verizon, 2013 Data Breach Investigations Report Mandiant, 2013 M Trends Threat Report Solutionary, 2013 Global Threat Intelligence Report (GTIR) Sophos, Security Threat Report 2013 [2] Verizon Report p. 48 View the full article
  45. 1 like
    Yes it is possible http://www.filemakermagazine.com/videos/creating-filemaker-go-launch-icons.html http://campsoftware.com/products/golaunch/
  46. 1 like
    Hello Everyone, i hope this helps some people because it took me a while to figure it out so here is the attached sample file as well as a link to the video. http://www.youtube.com/watch?v=2abc1jIgsLc enjoy, -i cond-value-lists.fp7.zip
  47. 1 like
    I use a calculation by Comment which allows the most flexibility and control possible. You can specify the precision, currency, separator etc: [color:blue]Let ( [ // USER DEFINED: input = numberfield ; precision = 2 ; currency = "$" ; separator = "," ; decPoint = "." ; // DO NOT MODIFY FROM THIS POINT ON inputRound = Round ( input ; precision ) ; Amt = Abs (inputRound ) ; Dollars = Int ( Amt ) ] ; // PREFIX Case ( inputRound < 0 ; "-" ) & currency & // BILLIONS Choose ( Dollars < 10 ^ 9 ; Right ( Div ( Dollars ; 10 ^ 9 ) ; 3 ) & separator ) & // MILLIONS Choose ( Dollars < 10 ^ 6 ; Right ( Div ( Dollars ; 10 ^ 6 ) ; 3 ) & separator ) & // THOUSANDS Choose ( Dollars < 10 ^ 3 ; Right ( Div ( Dollars ; 10 ^ 3 ) ; 3 ) & separator ) & // UNITS Right ( Dollars ; 3 ) & // FRACTION Choose ( precision < 1 ; decPoint & Right ( 10 ^ precision & Amt * ( 10 ^ precision ) ; precision ) ) ) You will not use it only once but many times when this type of need arises. :wink2:
  48. 1 like
This leaderboard is set to Los Angeles/GMT-07:00