Leaderboard

Try: Sum ( Onhand ; PendingOrders::sTotalQtyByWeekR[1] ; PendingOrders::sTotalQtyByWeekR[2] ; PendingOrders::sTotalQtyByWeekR[3] )

I would start by substituting "+" and "," with ¶. Then loop over the resulting values. If the current value contains "-", create the intermediate values and add them to the result. Otherwise add the value to the result.

If you don't have the Advanced version, you cannot use a custom function (unless someone installs it for you). And if you don't have version 18, you cannot use the While() function. That leaves us with a looping script. The attached demo shows how it could work. Note that you can use a script trigger to run the script automatically OnObjectSave. ProcessEntry.fmp12

Actually, you only need to "deal" with the "-" operator. The "+" and the comma can be simply substituted with a carriage return to get a list that Filemaker recognizes as a list of values (assuming that's what you want as the result). Iterating from 1 to 5 and creating the intermediate values requires either a custom recursive function or the While() function or a looping script. Please update your profile to reflect your version and OS so that we know which one of these you can use. -- Note: 1. A field where a user is allowed to enter "12+82" or "1-5" or "31,33,35,37" should be a Text field. 2. You may face a difficulty if a user enters a value that does not fit one of your 4 formats listed above.

Hold on: I've found a stupid mistake in my file. Try it again. BarcodeLookupAPI.fmp12

Here's another option, perhaps a more intuitive one: While ( [ text = Yourfield ; result = "" ] ; not IsEmpty ( text ) ; [ result = List ( result ; Left ( text ; 4 ) ) ; text = Right ( text ; Length ( text ) - 4 ) ] ; Substitute ( result ; ¶ ; " " ) )

Actually, I stole it from here: https://fmforums.com/topic/32095-how-to-format-a-numerical-field-to-show-as-smpte/?do=findComment&comment=145473 It could be = While ( [ text = Yourfield ; start = 5 ] ; start ≤ Length ( text ) ; [ text = Replace ( text ; start ; 0 ; " " ) ; start = start + 5 ] ; text )

Strictly speaking, this is a looping calculation and requires either a recursive custom function or the While() function. However, if the input is limited to 16 digits or less, you could settle for a simple: Trim ( Left ( Yourfield ; 4 ) & " " & Middle ( Yourfield ; 5 ; 4 ) & " " & Middle ( Yourfield ; 9 ; 4 ) & " " & Middle ( Yourfield ; 13 ; 4 ) ) or, if you prefer: Trim ( Replace ( Replace ( Replace ( Yourfield ; 13 ; 0 ; " " ) ; 9 ; 0 ; " " ) ; 5 ; 0 ; " " ) ) This is assuming that the grouping should start from left - so that an input of 1234567890 will return "1234 5678 90".

For the first time, DB Services has been ranked #3494 on the annual Inc. 5000 list, which ranks the country’s “fastest-growing innovators” based on overall revenue growth over a three-year period. The Inc. 5000 list has brought attention to America’s growing private businesses since 1982. DB Services now joins the ranks of other Inc. 5000 list alumni such as Facebook, Zappos, Pandora, and others. DB Services is top ranked FileMaker Platinum Business Alliance Partner on the 2019 Inc. 5000 list. DB Services joins 63 other Indiana-based companies, and ranks #42 in the state. DB Services’ mission is to make organizations more efficient and effective through the use of custom FileMaker solutions. Since 2003, they have provided custom applications and workflow solutions to Fortune 500 companies, small businesses, K-12, universities, and non-profit organizations. DB Services is a FileMaker Business Alliance Platinum Member that offers FileMaker Development, FileMaker Support, FileMaker Training, FileMaker Cloud Hosting, and FileMaker Licensing. For a complimentary consultation with one of our Certified FileMaker Developers, call the main line at 888-488-0191, or fill out a Contact Form on the DB Services website.

Of course. Having to know the encryption key before being able to open the files protects against an unauthorized person opening the file. By then you'd be several layers in already, but it is a good extra line of defense. Yes, they would have to have a copy of the files. The most likely source is from a backup. Protect your backups

I have not tested with AdoptOpenJDK 12, you need to install AdoptOpenJDK JRE 8. This is the version that I have installed. Select OpenJDK 8 and select hotspot and click install JRE. I recommend removing version 12 before installing 8. When you get to the screen shown in the attached screen shot in the installer make sure to select all the options.