Ocean West

Internally you should use a meaning less id or UUID for relationship purposes you could create another field that contains meaning should something happen where you realize you entered S1 and meant M1 then that would change or orphan records. You could maintain a table of objects that know or set the next sequence number and then append that to with the "designator" M or S Or scripted you could isolate the known set of record for a given material then figure out the MAX value by various means then create a new record for this material setting the identifier to the max + 1 such as

perhaps use a web viewer with some javascript that uses a different JSON parsing library that can manage paths with characters that FileMaker can't.

After download it wanted to launch BBC News.

I seen it and my client has seen this and can't figure out why... After sync we had a new build ready to update and starts downloading And then get a message that FileMaker 19 is opening BBC app.

Pretty ugly but... Let ( [ a = $JSON ; b = JSONGetElement ( a ; "putExpDateMap" ) ; c = JSONListKeys ( b ; "" ) ; d = Position ( a ; c ; 1 ; 1 ) ; e = Replace ( a ; d ; Length(c) ; "MYKEY" ) ; f = JSONGetElement ( e ; "putExpDateMap.MYKEY" ) ; g = JSONListKeys ( f ; "" ) ; h = Position ( f ; g ; 1 ; 1 ) ; i = Replace ( f ; h ; Length(g) ; "MYKEY" ) ; z = "" ]; JSONGetElement ( i ; "MYKEY[0].mark" ) )

i think ":" and "." are illegal in json paths.

You're going to have a hard time with this because keys have a period in the json object "52.5" fmp can't handle json key's with periods.

in layout mode right click and customize the tool bar or when in layout hit command-option-k to get access to Open quick layout start typing to find a layout.

Really depends - one way you could ease the transition is to perhaps use Apps on Demand where you could provide users mac/pc access to a hosted provider that will provide an App On Demand experience. All users would essentially be remote in to their session. The users would experience FileMaker running on windows which may allow them time to assimilate to working on windows - which may be difficult to die hard mac users.

Much more elegant

Someone requested on face book a function to find a gap in sequence. This is my attempt for that with a While Function If I were to add this to a custom function i would Replace X with a parameter - also perhaps suggest to do a unique list and sort list on the parameter. While ( [ x = "1¶2¶3¶6¶7¶8¶12¶13¶16¶17¶18" ; y = "" ; z = "" ; out = "" ; i = 1 ; c = ValueCount ( x ) ] ; i ≤ c ; [ y = GetValue ( x ; i ) ; z = case ( y+1 = GetValue ( x ; i+1 ) or y-1 = GetValue ( x ; i+1 ) ; "" ; "-" & y & "," ) ; out = Case ( i = 1 ; y ; Right

The original file was sent to me via PM, i chose to reply here the same original file is in the container field. which include % symbol, and other characters.

The issue here is the original file needs to be cleaned up. It starts as a CSV but doesn't have quotes around the fields, so it is harder to parse - also i have detected invisible charters in the original file, could be some conversion issue? So in this example you drag the CSV file to a global field then the script will move the file to known location and then look at the contents of the file and perform some substitution on the data and write out the data to a known location to a .txt file then the data will be imported. The final part is to put the data in to your repeating field

I would import the file and all the fields should be text then you can create shadow fields that sanitize the text data and then export these fields and or import them in to another table.

you need a new version.