David Jondreau

Members
  • Content count

    2,012
  • Joined

  • Last visited


About David Jondreau

  • Rank
    Huzzah!

Contact Methods

  • Website URL http://www.wingforward.net

Profile Information

  • Gender Male

FIleMaker Profile

  • FM Application 13 Advanced
  • Platform Cross Platform
  • Skill Level Expert
  • Certification 9
    10
    11
    12
    13
  • Membership TechNet
    FileMaker Business Alliance

Recent Profile Visitors


12,561 profile views

David Jondreau's Activity

  1. David Jondreau added a post in a topic: There must be a simpler way   

    ​It's style.
    I do it that way because it makes it easier for me to write/debug a calc that way. I generally write calcs in the Data Viewer. This calc is pretty simple, but if it were more complicated I could drop different calc variables outside the variable declaration and see if the result matched my expectations. For example, I could have written the calc the following way, and if it wasn't returning the right result, debugged it, by, say making sure the "too.long" variable was correct:
    Let([
    len = table::lengthRequested ;
    standard.lengths = List ( 22.25 ; 22.5 ; 25.25 ; 25.5 ) ;
    max.length = 25.5
    match.length = not isEmpty ( FilterValues ( standard.lengths ; len ) ) ;
    too.long =  len > max.length ;
    result = Case ( match.length ; 10 ;
    too.long ; 20 ;
    0 )
    ];
    //result
    too.long
    )
    • 0
  2. David Jondreau added a post in a topic: Deselect Field or Bypass Tab Order   

    Putting Exit Script [ False ] at the end of the script will generally solve this issue but it may depend on the trigger you're using.
    • 0
  3. David Jondreau added a post in a topic: There must be a simpler way   

    How about...
    Let([
    len = table::lengthRequested ;
    standard.lengths = List ( 22.25 ; 22.5 ; 25.25 ; 25.5 ) ;
    max.length = 25.5 ;
    result = Case (
    not isEmpty ( FilterValues ( standard.lengths ; len ) ) ; 0 ;
    len > max.length ; 20 ;
    10 )
    ] ;
    result
    )
    • 0
  4. David Jondreau added a post in a topic: Compatibility of FM13 to FM14   

    You can run FM 13 and FM 14 simultaneously on one machine. FM 14 files will run in FM 13, except for FM 14-specific features (for example, the new Top Navigation part will show up with a big red "X" in FM 13).
    I don't think there's an Advanced version for demo, but I'm not sure.
    • 0
  5. David Jondreau added a post in a topic: ExecuteSQL with conditional Arguments   

    I would do it this way:
     
    /*for example: SELECT id_contact FROM contacts WHERE contactFirstName='Tom' AND contactLastName='Ad' AND ( contactSSN='111-11-1111' OR contactSSN IS NULL )
    */
    Let([
    select = "SELECT id_contact FROM contacts" ;
    where.name = "contactFirstName='" & contacts::searchNameFirst & "' AND contactLastName='" & contacts::searchNameLast & "'";
    where.dob = "( contactDOB='" & contacts::searchDOB & "' OR contactDOB IS NULL )"  ;
    where.dob = If ( not IsEmpty ( contacts::searchDOB ) ; " AND " & where.dob ) ;
     
    where.ssn = "( contactSSN='" & contacts::searchSSN & "' OR contactSSN IS NULL )"  ;
    where.ssn = If ( not IsEmpty ( contacts::searchSSN ) ; " AND " & where.ssn ) ;
     
    sql = select & " WHERE " & where.name  & where.dob & where.ssn ;
    result = ExecuteSQL ( sql ; "" ; "" ) 
    ];
    result
    )
    • 0
  6. David Jondreau added a post in a topic: ExecuteSQL with conditional Arguments   

    OK, but which one will be left empty? 
    Will a user leave a search global empty or will the contact record not have a value for a field? I'm guessing the user may not enter a birthdate when searching, but I want to confirm that.
    • 0
  7. David Jondreau added a post in a topic: ExecuteSQL with conditional Arguments   

    Do you mean searchDOB will be empty while contactDOB has a value?
    Or searchDOB has a value while contactDOB does not?
    • 0
  8. David Jondreau added a post in a topic: How do they do that? - FMP14 Getting Started Layout   

    They're using 19 different layouts for that one "menu" in the left window. 
     
     
    • 0
  9. David Jondreau added a post in a topic: Adding up only certain rows of a portal   

    How are you planning on using it? There are several ways to do this depending on the end result you're looking for.
    • 0
  10. David Jondreau added a post in a topic: Runtime DEPRECATED?   

    comment, Why are you trying to discourage this topic? If you don't want to engage in the conversation, why don't you just unsubscribe from the thread and let people who want to engage in it do so?
    • 0
  11. David Jondreau added a post in a topic: Adding up only certain rows of a portal   

    I think the simplest would be to make a summary field in the Inventory table summing the costs. Then put a single row portal on the layout showing that summary field and filter the portal where inventory::relatedService =/= Service::Name.
    That should work...I haven't tried it with a relationship that's two "hops" away though.
    • 0
  12. David Jondreau added a post in a topic: Allow User Abort   

    I don't write a single script that doesn't have Allow User Abort[Off] as the first script step.
    • 0
  13. David Jondreau added a post in a topic: Runtime DEPRECATED?   

    I apologize. I didn't mean it as a challenge. I'm just trying to understand something.
    I've heard several runtime developers express the sentiment that deprecating runtimes in future versions of FileMaker is bad for FileMaker. That runtime developers are important to FMI somehow.
    Clearly the deprecation is bad for that developer. I get that. And even if it won't actually affect anyone for 2-5 years (time until deprecation + time until OSes become outdated), it's usually hard to face the mortality of something.
    I'm not a runtime developer myself so I don't feel the emotional punch.
    It's not clear to me why someone would think it is bad for FileMaker itself. As comment mentions, we can only pretend to know what's good for FileMaker. I think it's extremely likely that FMI has actually thought this through, run the numbers, and decided rationally that runtimes aren't worth supporting anymore.
    I don't understand why runtime developers say it's a bad decision for FMI. Or why they're an important subset.
     
     
    • 0
  14. David Jondreau added a post in a topic: Runtime DEPRECATED?   

    Curious...Why do you feel you're an important subset of FMI's customers? I'm assuming you own a single license of FMPA. How many customers do you serve with that license?
    • 0
  15. David Jondreau added a post in a topic: Conditional Values   

    The "starting from" table should be the table that the layout you're putting the menu on is based on. Probably Projects.
    I'm not 100% sure about your naming convention, but I'd say you should relate CategoriesSub 2 to Projects based on Category_Relation -->CategorySub_Relation. You'll have to delete the current relationship to make the new one.
    Once that relationship is in place, the value list should work as you've defined it.
    • 0