-
Content Count
3,924 -
Joined
-
Last visited
-
Days Won
74
Ocean West last won the day on November 16 2020
Ocean West had the most liked content!
Community Reputation
172 ExcellentAbout Ocean West
-
Rank
I have an idea!
- Birthday 11/26/1971
Profile Information
-
Title
Consultant
-
Gender
Male
-
Location
San Diego
Contact Methods
-
Website URL
http://www.fmforums.com
-
Skype
oceanwest
FileMaker Experience
-
Skill Level
Expert
-
FM Application
18
Platform Environment
-
OS Platform
Mac
-
OS Version
Catalina
FileMaker Partner
-
Certification
7
8
9
10
11
12
13
14
15
16 -
Membership
FileMaker TechNet
FileMaker Business Alliance
Recent Profile Visitors
-
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
-
Trouble parsing json with jsonGetElement
Ocean West replied to jbmia's topic in Script Workspace and Script Triggers
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.
-
Trouble parsing json with jsonGetElement
Ocean West replied to jbmia's topic in Script Workspace and Script Triggers
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" ) ) -
Trouble parsing json with jsonGetElement
Ocean West replied to jbmia's topic in Script Workspace and Script Triggers
i think ":" and "." are illegal in json paths. -
Trouble parsing json with jsonGetElement
Ocean West replied to jbmia's topic in Script Workspace and Script Triggers
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
-
Converting symbols when importing data from a .txt file.
Ocean West replied to romankonis's topic in FileMaker Pro 19
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. -
Converting symbols when importing data from a .txt file.
Ocean West replied to romankonis's topic in FileMaker Pro 19
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 -
Converting symbols when importing data from a .txt file.
Ocean West replied to romankonis's topic in FileMaker Pro 19
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. -
ScriptMaster 5.3 won't enable on FMS 19.1.2
Ocean West replied to mk.h's topic in ScriptMaster by 360 Works
you need a new version.