Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About HazMatt

  • Rank
  • Birthday 07/28/1979

Profile Information

  • Gender
  • Location
    Minnesota, USA

Contact Methods

  • Website URL

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. BaseElements has an "Overview" layout that has a nice list of element counts. There are columns for Count, Errors, Unreferenced, Warnings and Performance. Errors are in red. A report card containing raw data of that kind (and perhaps a few subjective grades) would be very helpful to get a quick idea of potential issues.
  2. I really don't mind, but I just rarely visit the forums these days, so it would likely be out of date next time I post something.
  3. Fascinating… glad I'm not crazy or [too] stupid! I figured out a more "pure" way to accomplish my goal, one that would work no matter what the order of the tests was in: Let( [ d = Self ]; IsEmpty(d) or IsValid(GetAsDate(d)) or (d = Filter(d; "0123456789") and Length(d) = 4) ) For the record, I agree… sort of. A field named "Birthdate" should be a legitimate, valid date. But there are trade-offs to the suggested approach… 4 fields instead of 1 make for a wider table and a more complicated user interface that precludes the use of the drop-down calendar and possibly
  4. Use-case: Full birthdate is not known… only the year. Better to have a valid 4 digit year OR a full, valid date than whatever the user feels like entering. The field is Contacts::Birthdate (Text). Field validation by calc is turned on with this code: Let( [ d = Self ]; IsEmpty(d) or d = GetAsDate(d) or (d = Filter(d; "0123456789") and Length(d) = 4) ) If I enter nothing in Birthdate, it is accepted. If I enter "4/25/2016" in Birthdate, it is accepted. If i enter "2016" in Birthdate, it is rejected as not meeting field validation requirements. BUT, if I
  5. comment, you're a genius. Copying and pasting "¶" (where the ¶ is the invisible character, of course) does work manually, and your suggestion to use a script got me thinking… So, here's my script: Script Name: Find All Records with "¶" In Current Field # If [IsEmpty(Get(ActiveFieldName))] # Cursor not in any field Beep Show Custom Dialog [Get(ScriptName); "Please place your cursor in an active text field and try again."] Exit Script [] End If # # Attempt the find Enter Find Mode [] Set Field By Name [Get(ActiveFieldTableName) & "::" & Get(ActiveFieldName); ""¶""] Set E
  6. I'd like to verify that a number of fields do not have any carriage returns (¶) in them. I already have an auto-enter calculation that I am adding to each field to prevent this from happening in the future. One solution is to create a secondary calc field that will return "1" if a carriage return is detected in 'FieldName': PatternCount(FieldName; "¶") > 0 If I search for "1" in this secondary field it works great (and I can fix individually or quickly via Replace Field Contents), but changing the calculation is tedious to do for a large number of fields. Is there instead a way I
  7. Ahh, advanced SQL coding techniques… Probably beyond my ability (and time) at this point. I just updated my skill level in my profile to "Expert" but I think you are ahead of me.
  8. Yep, I know. Just surprised, is all. Yes, the "gaps" I speak of are null values. Average() automatically ignores blanks, so it would have been nice to use it. eos and comment, I spent the time since my original post to try and figure out an alternative, and I came up with a similar method, although it looks like your script steps are probably more error proof. Here's my custom function, GetAverage(Values): /* Purpose Calculates the average of a list of values. Useful for when the Average() function does not work. With inspiration from: • Debi Fuchs' "CullNulls" (http://www.bria
  9. I am writing a script where I need to calculate the average of a bunch of numbers. There may be 1 number (where no averaging is calculated) or up to 10 or so. There may be gaps in the numbers from time to time as well. Set Variable [$CalculatedAvg; Value:Average($ListOfValues)] Doesn't work—no variable is created. Can anyone suggest something that could work? I was hoping to use the Average function because it automatically accounts for blank values. Not looking forward to having to eliminate blank values, adding up the remaining values and dividing by ValueCount(). Perhaps virtu
  10. Yeah, seems like a hack no matter which way you 'slice' it, eh? Thanks for pointing out the record #1 load issue—I do have this in my script: Get(RecordNumber) = 1 #WebDirect always loads record #1 regardless of record number specified Exit Script [] End If
  11. I might just do that. Thanks for the suggestion. Being the "IT Guy" I certainly have admin access to all the machines.
  12. I agree that the inability to pass custom parameters upon launching a WebDirect solution is needed! I am working on replacing our broken PHP job application form with WebDirect and here's what I'm doing, which might work for you if you do not need to pass dynamic parameters: 1) Create a table "webdirect_solutions" and create a couple of records. 2) In the second record, enter a value "New Job Application" in the Action field. (this will be the static script parameter) 3) Create a layout "lyt_WebDirect_Landing_Page" and add a script trigger for OnRecordLoad, which passes the value
  13. I manage a fleet of workstations that are all configured to sync time with the NTP server 0.pool.ntp.org. While there are some Windows workstations in the mix, there are many Macs running OS X Mavericks 10.9.1, and for now I'd like to just focus on the Macs, since that's what my most vocal users are using. Even though I have everything set correctly in System Preferences, (i.e. the 'Set date and time automatically:' checkbox is set, etc.), the computers tend to drift over time. My own workstation was off by 2 minutes and 1 second today, for instance. I checked Activity Monitor and 'ntpd
  14. Yes, it is odd. In fact, I hope to be using a Windows server for FileMaker Server in the next couple of months. Screw OS X Server! Gosh it makes me sad to type that.
  15. I installed FileMaker Server 13 the other day and was annoyed when I got the prompt. I wasn't aware of this requirement, and it makes it all the more difficult because they want you to uninstall the old FileMaker Server before installing the new one (so I'd have to re-install the old FMS if I didn't like it). I ended up going ahead with the installation which disabled OS X Server's web service. I only had a few pages that weren't that important, but now I have to figure something else out. On the plus side, no more Java.
  • Create New...

Important Information

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