Jump to content

Ocean West

Administrator
  • 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 Excellent

8 Followers

About 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

71,104 profile views
  1. 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
  2. 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.
  3. After download it wanted to launch BBC News.
  4. 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.
  5. 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" ) )
  6. 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.
  7. 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.
  8. 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.
  9. 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
  10. 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.
  11. 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
  12. 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.
×
×
  • Create New...

Important Information

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