Popular Content

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

  1. 4 likes
    Hi All, I am happy to present the FmDynamix project, including cfCall () and #load (), my new 2 custom functions .... In an interest to further test FileMaker more and more ... I tried to give you a presentation of this new method, as explicit as possible, I hope to have succeeded ! You have the description and the presentation here, and take before the file demo : fmx_FmDynamix_Presentation.fmp12 I hope that this file will give you the urge to see this method, I do not think I have view of similar thing I hope that this "modularity" will please you and will give some ideas, feel free to test and give me your comments ! Thanks for your interest Agnès ( and thank you to Google Translate too )
  2. 2 likes
    if you change layouts while in find mode, the OnLayoutEnter will fire. But it has to be enabled for Find mode of course. If you want to trap the user switching modes on the same layout then the OnModeExit will do. OnRecordLoad fires after the Layout change but if you only want to capture the layout or mode change then RecordLoad is overkill since it fires on all record changes. Soliant has a big blog post with a triggers playground demo file that has all possible triggers enabled to make it easy to see the exact firings and sequences.
  3. 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.
  4. 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?
  5. 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.
  6. 1 like
    A zero is zero, no matter how it was entered. And GetAsText ( 0 ) ≠ GetAsNumber ( 0 ) returns false. IMHO, your real problem is having 90 fields - and I suspect you will run into it again.
  7. 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!
  8. 1 like
    No, I don't think so. This is the second time you report a behavior that I cannot reproduce. Are you sure you're using Filemaker?
  9. 1 like
    I am afraid I cannot look at your file. In case it wasn't clear, you need to run a script that will create a record in the Emissions table for each combination of EngineYearlyConsumptions and Substance (i.e. every row in your report). There is no other way to populate the table (unless you want to do it manually, or you have an outside source you can import)).
  10. 1 like
    You have to start by splitting this into individual records in an EmissionFactors table that has fields for: • Substance • YearOfManufacture • MinimumHorsePower • EmissionFactor • Units Then for your report generate a record in a third Emissions table for each Engine/Substance combination, and let it calculate the total emission. So your structure would be: Engines -< Emissions >- EmissionFactors and the relationship between Emissions and EmissionFactors would be defined as: Emissions::Substance = EmissionFactors::Substance AND Emissions::YearOfManufacture = EmissionFactors::YearOfManufacture AND Emissions::HorsePower ≤ EmissionFactors::MinimumHorsePower with the records on the EmissionFactors side sorted by MinimumHorsePower, descending. I don't see a given year in the example. If you have year-by-year data, this may affect the structure.
  11. 1 like
    Reconsider that. There is a huge upshot in keeping field names 'standards-safe and use only a-z, A-Z, 0-9 and the underscore. The 'dot' is the delimiter between a table name and a field name in SQL for instance.
  12. 1 like
    I am not sure what exactly your question is here. If you're asking whether I suggested that field labels will be visible only after the variables have been populated, the answer is yes. Technically, you could have default labels in a default language and hide these when the variables are populated. But that would be an awful lot of extra work. Like this? http://www.filemaker.com/help/13/fmp/en/html/create_layout.9.34.html#1064499
  13. 1 like
    You've mentioned that twice but it is not clear to me what you mean. Is your goal to have just one TO per base table? And if so, why? What specific problem would that solve for you? Or is an abstract notion? Abstract notions is what gets a lot of us in trouble, premature optimization, unneeded modularity,... that kind of thing.
  14. 1 like
    Do you have access to an older version of filemaker pro ? If you have access to a v13, you can access "manage security" without the first dialog.
  15. 1 like
    Yes, as our German friend's doppelganger just said : go have a look ! Even if it's only through the eyes of a kid at a magician's show ! It's worth it.
  16. 1 like
    MirrorSync stores its internal sync data based on the database file name on the hub, so if you change that name, it will be necessary to edit the sync configuration, point it to the new file, and then distribute new offline files which will run through the initial sync process. I would also recommend resetting the sync data (by right-clicking the name of the configuration) to save some disk space. Do this BEFORE changing the database name. Once you edit the sync configuration, older offline files will no longer be able to sync, so have them run a final sync before doing this.
  17. 1 like
    While it may take a while (and more than one time listening to Agnès explanations… ;o) to fully understand what she has done it is definitley worth trying it out! It is not only a different way of thinking about storing and handling elements/code of a solution, it is also challenging to get behind all that in a positive way! Go and check it out! :o)
  18. 1 like
    I believe the best strategy for field labels (and perhaps for all language-dependent strings) would be to load some global variables with strings in the selected language, at the time the language is selected. How to store these strings depends on whether the number of languages is constant or not. Note that in v.14 and higher you have the option of placeholder text, which can be calculated.
  19. 1 like
    check the "external data sources", there are probably a bunch of them in there and you don't need anymore.
  20. 1 like
    There can be a big difference between how many times a keyword comes up as a pattern match and how many times a keyword comes up as a word. Consider for example the following sentence: Bob the nabob went home to eat kabobs and watch the skibobbing competition. Using PatternCount() will return 4 occurrences of the pattern "bob" - while a custom function such as CountWordOccurrences() will detect only 1 occurrence of the word "bob".
  21. 1 like
    Filemaker will not hyphenate long words for you - but you can prevent words being broken by going into File > File Options… > Text and selecting the "Use Roman language line-breaking" option. This will work for as long as you don't have a word that's longer than would fit on a single line.
  22. 1 like
    Or make ItemRef lookup the value from the subtable as an auto enter option, or simply show the now related firld from the subtable - Category::ItemRef
  23. 1 like
    See if this helps: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional value list
  24. 1 like
    You need to point a (sub)domain being used for SSL with an A record, not a CNAME record. - John
  25. 1 like
    Recently bought some DYMO M10 scales and wanted to grab the weight from them. Turns out this is not as easy as you think talking to USB, but after a lot of crashing out and frustration I managed to get a proof of concept working, so here to share... You will need hid4java and jna, best grabbing them from Maven // ReadDYMO // 17_02_28 JR // v1.0 // read weight from Dymo M10 scales //requires hid4java.jar and jna.jar import org.hid4java.* import org.hid4java.jna.* import java.nio.ByteBuffer // specifc to these scales Short VENDOR_ID = 0x0922 Short PRODUCT_ID = 0x8003 Short raw_weight = 0 DATA_MODE_OUNCES = 11 message = new byte[8] hidServices = HidManager.getHidServices() devices = hidServices.getAttachedHidDevices() dymo = hidServices.getHidDevice(VENDOR_ID, PRODUCT_ID, null) if (dymo){ val = dymo.read(message, 1000) dymo.close() } //end if hidServices.shutdown() if (dymo){ byte[] data = [ message[5], message[4] ] wrapped = ByteBuffer.wrap(data) raw_weight = wrapped.getShort() if ( message[2] == DATA_MODE_OUNCES ) { scale = 10.power(message[3].toString().toShort()) weight = (raw_weight * scale) + ' oz' oz = true } else { weight = raw_weight + ' g' oz = false } //end if return weight } else { return '0' } //end if
  26. 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...
  27. 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
  28. 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.
  29. 1 like
    Sorry, "nested functions" (if one is an aggregate) do not seem to work well in eSQL. try this: Let ( [ $query = " SELECT MIN(checkins.date_due) FROM checkins WHERE checkins.id_contact=? AND checkins.isComplete=0" ; $result =ExecuteSQL ( $query ; "" ; "" ; id ) // returns yyyy-mm-dd ]; If ( $result ≠ "?" ; Let ( [ $y = Left($result; 4) ; $m = Middle($result; 6; 2) ; $d = Right($result; 2) ]; Date($m;$d;$y ) ) ; "?" ) )
  30. 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
  31. 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
  32. 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
  33. 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
  34. 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.
  35. 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
  36. 1 like
    This might help: http://sixfriedrice.com/wp/filemaker-9-tip9-web-viewers-without-the-web/
  37. 1 like
    here are a few options http://fmforums.com/forum/files/file/19-context-free-record-creation/ http://www.filemakermagazine.com/videos/super-quick-data-entry.html
  38. 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
  39. 1 like
This leaderboard is set to Los Angeles/GMT-07:00