• Content count

  • Joined

  • Last visited

  • Days Won


doughemi last won the day on December 17 2015

doughemi had the most liked content!

Community Reputation

82 Excellent

About doughemi

  • Rank
    lifetime learner

Profile Information

  • Gender
    Not Telling

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Cross Platform
  • Skill Level

Recent Profile Visitors

7,703 profile views
  1. In Layout mode, go to Layouts->Layout Setup...->ScriptTriggers, check the appropriate trigger, and select the corresponding script.
  2. Use this calculation: Let( [~getID = Substitute(YourURLField; "="; "¶"); ~gotID = GetValue(~getID; 2)]; ""& ~gotID & "/maxresdefault.jpg" )
  3. All of Fitch's solutions are good ones, but be aware that in a multiuser solution, there is a very real danger that numbers will be duplicated if requested at about the same time (if the first one isn't committed before the second one is requested).
  4. Try this: <?php $row=0; $bgcolor = 1; foreach($records as $record){ $row++; if($bgcolor == 3){ $bgcolor = 1; } if($bgcolor == 1){ echo '<tr class="alt_row_color">';// ...etc } else { echo '<tr>';// ...etc } if($row % 2 == 0){ $bgcolor++; } } ?>
  5. Hi Doughemi, I'd like to do a search where the the result doesn't equal something.  My coding is obviously wrong, but hope you get the idea.  All records where myField does not equal '1'


    $myFind->addFindCriterion('myField', '!=1');

    1. doughemi


      I prefer that you ask questions on the forum in the future. That way, others can benefit.

      See this thread.

      I can't tell if the link was included in the previous reply.  It is


  6. Check the Data Entry Options (File->File Options...->Text)
  7. Try this: Vacation Tracker_dh1.fmp12
  8. Are years calculated from anniversary date or from some other date?
  9. Yes, with the setOmit(TRUE) statement: $theFind =$fm->newCompoundFindCommand('YourLayout'); $request1=$fm->addFindCriterion('yourField', $value1); $request2=$fm->addFindCriterion('yourOtherField', $value2); $request3=$fm->addFindCriterion('yourOmitField', $valueOmitted); $request3=$fm->setOmit(TRUE); $theFind->add(1,$request1); $theFind->add(2,$request2); $theFind->add(3,$request3); // you could sort here with $theFind->addSortRule() statements $foundSet = $theFind->execute();
  10. Marius - please check your PM
  11. I could not reproduce this behavior in Filemaker Pro 14 Advanced v14.0.6 on OS X 10.11.6. I tried to just add a field in an existing table, paste the character, and perform a find on that field. It behaved normally. I then followed your sequence of creating a new db, creating a field, and pasting the character in the field. In either case, performing a find on this field created no problems. I pasted the character in Find mode, performed the find, and the record with that character was found with no problems. EDIT: I would start troubleshooting by suspecting a corrupted font file.
  12. Inadequate testing. Tests with a number of dates worked ok (including 9/5/2016) but others fail (like 12/29/2015).
  13. This works, too: date > "10/5/2016" and date < "12/31/2016" Edit: could it be that FM is trying to do the division in your original calc?
  14. I don't know, but I've gotten to the point that I let FileMaker do the heavy lifting (with the Date( ) function) on anything having to do with dates.
  15. I got it to work with date > Date(10;5;2016) and date < Date(12;31;2016) But even that didn't work unless the year is 4 digits.