Jump to content


Popular Content

Showing content with the highest reputation since 05/15/2017 in all areas

  1. 1 point
    your calculation value must be "un-stored" this way it will always evaluate to the current value. Choose storage options
  2. 1 point
    Hey Lewis, Great question. After some tinkering, I got it to work for me. There's a few steps involved which I'll walk you through. First off, we use Java methods to perform the encryption process for us. By default, the Java JRE only goes up to 128 bits (due to some security policy). If you are using Scripmaster version 5, you can swap out a couple of the jar files in the 360Plugin Java library to get it to work (notice that our plugins use this specific Java environment, not whatever version you have installed on your machine). The paths vary by operating system. On windows, they should be in ProgramData\360Works\Plug-ins\jre, and on Mac Users/username/Library/Application Support/360Works/Plug-ins. From Oracle, you want to download the Java Cryptography Extension located here: http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html In our JRE folder, replace the two existing jars with the ones you just downloaded located at ../jre/1.8.0_121/Contents/Home/lib/security/US_export_policy.jar. Using Scripmaster modules, I generated a 256bit key (instead of 128) and was able to encrypt and decrypt with it. I also checked to make sure my plaintext matched up after going through the process. Just a reminder that I tested this using Scriptmaster 5 and can't endorse this workaround with previous versions as they have completely different Java frameworks. Should you have any questions about this, let me know. It was a fun learning experience! Junior Perez 360Works Support
  3. 1 point
    If I understand your question correctly, you need to import your records (to a new table) multiple times, each time importing the title and one of unique combinations of size, color and short.
  4. 1 point
    Even better = BE_RegularExpression ( "AlphaBravoÇharlie" ; "(\p{Ll})(\p{Lu})" ; "g" ; "$1 $2” ) returns: "Alpha Bravo Çharlie" Basically, this looks for a lowercase character (excluding punctuation and digits) followed by an uppercase one, and inserts a space between them.
  5. 1 point
    I can't figure out what your question is. What is "a calculated list field"? And what exactly does "filtering by a calculated list field" mean? You speak of filtering portals, but then you say "My usual technique is to do by relationship" which makes no sense to me. Most often you filter a portal in order to avoid adding a relationship. Why don't you back up a bit and explain what you're trying to accomplish here, not how.
  6. 1 point
    Are you sure you are using FM Starting Points?
  7. 1 point
    The upside of the record number symbol is that you don't need to define a field. The downside is that if you want to fit {{recordNumber}} into a skinny space; that is difficult. There are some stupid FileMaker pet tricks you can use to resize it but they break if you touch the field. So I often use an unstored calc field, defined as get( recordNumber); and place that on the layout.
  8. 1 point
    Duh. I'll answer my own question. The issue wasn't with the attachments -- it was with the body text. I had been using type "rtf" -- which doesn't support both text and attachments. Once I switched to type=html, I can now get both attachments and body text in the same message. Thanks -- and sorry to bother the community. Perhaps my stupidity will help someone else searching for a similar question.
  9. 1 point
    Well wait a minute … words can be turned to repetitions and repetitions can be imported as records so … how about this way? I got this idea from you, LOL. It must be a full moon. update: I replaced the file. I had neglected to specify 'perform auto-enter' during the import. It is corrected now. TestMODr.fp7.zip
  10. 1 point
    Does this work all right for you? Testing2.zip
This leaderboard is set to Los Angeles/GMT-07:00

Important Information

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