Jump to content

SkylineR37_

Members
  • Content count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About SkylineR37_

  • Rank
    member
  1. Hello! Does anyone have a list of upper level managers' contact information at FileMaker Inc? Specifically, a list of names and numbers of managerial folks who can make things happen? Thanks in advance!
  2. Thanks for your comment, Comment, You had a great idea. I've implemented that and works like a charm. Thank you! # Set Variable [$fields; Value:FieldNames ( Get ( FileName ) ; "Comparison Layout" )] Set Variable [$fieldCount; Value:ValueCount ( FieldNames ( Get ( FileName ) ; "Comparison Layout" ) )] Loop Set Variable [$currentField; Value:GetValue ( $fields ; $fieldCount )] Go to Records/request/Page [First] Set Variable [$value1; Value:GetField ($currentField)] Go to Records/request/Page [Next] Set Variable [$value2; Value:GetField ($currentField)] If [$value1 ≠ $value2] Show Custom Dialog ["Inequality"; "FieldName: " & $currentField & " doesn't match. Record 1: " & $value1 & " Record 2: " & $value2] End If Set Variable [$fieldCount; Value:$fieldCount - 1] Exit Loop If [$fieldCount = 0] End Loop
  3. I have a situation where I have a table with 10 fields and only two records, and I want to compare them and spot any differences. I have written a script that compares the two records by: a) Set ten variables with the contents of the ten fields of record 1. Go to next record. c) Set ten more variables with the contents of the ten fields of record 2. d) Compare the twenty variables, a pair at a time (one from record 1, one from record 2) to be alerted when a pair doesn't match. But now I have to do the same thing to a table with 75 fields (and still just two records). I feel as if there may be a better way, as this would take a very long time to set up the way I was doing it. Does not seem efficient at all, and seems like it would easily break. Any input would be appreciated. Thank you.
  4. Comment, you're a genius! That works perfectly and is far more elegant than I had envisioned the answer being. And you're right about #5 - which is exactly why it's better to let computers do the math. [= Thank you very much for your assistance. Need to buy you a beer!
  5. The two fields in a Punch record are timestamps, yes. My bad for over-simplifying the scenarios using plain English whole numbers for times. Here are the example scenarios again, this time using actual timestamps: 1) ClockIn = 01/01/2014 10:00:00. ClockOut = 01/01/2014 17:00:00. Calc should return "0", as none of those hours qualified for "night time" hours. 2) ClockIn = 01/01/2014 03:00:00. ClockOut = 01/01/2014 11:00:00. Calc should return "2", because two of those hours were during "night time" hours. 3) ClockIn = 01/01/2014 18:00:00. ClockOut = 01/02/2014 01:00:00 (the next day). Calc should return "4" because four of those hours were during "night time" hours. 4) ClockIn = 01/01/2014 03:00:00. ClockOut = 01/01/2014 23:00:00. Calc should return "4" because four of those hours were during "night time" hours 5) ClockIn = 01/01/2014 03:00:00. ClockOut = 01/02/2014 01:00:00 (the next day). Calc should return "7" because seven of those hours were during "night time" hours. It is not known wether or not one period can exceed 24 hours. Let's code on the assumption that no time period will exceed 23 hours, 59 minutes, 59 seconds and a fistful of microseconds. Thank you for looking!
  6. I've googled far and wide and have not been able to find anything that gives clues to solving this issue. I'm trying to write a calculation which returns the number of "night time hours" for a given Punch record, which can start and/or end inside of or outside of pre-determined "night time" hours. Our data: A) A Punch record has two timestamp fields: ClockIn, and ClockOut. Any valid timestamps can be entered. Typically, the time stamps will be on the same day, different times, but, can also span from one day until the next day, bridging the midnight hour. We know the time that we want to set as the beginning of "night time": For this exercise, let's set it at 9:00 PM, which is unchanging, can be hard-coded. C) We know the time that we want to set as the end of "night time": For this exercise, let's set it at 5:00 AM, which is unchanging, can be hard-coded. Our Scenarios. For simplicity, I'll use plain English whole numbers for times: 1) ClockIn = 10AM. ClockOut = 5PM. Calc should return "0", as none of those hours qualified for "night time" hours. 2) ClockIn = 3AM. ClockOut = 11AM. Calc should return "2", because two of those hours were during "night time" hours. 3) ClockIn = 6PM. ClockOut = 1AM the next day. Calc should return "4" because four of those hours were during "night time" hours. 4) ClockIn = 3AM. ClockOut = 11PM. Calc should return "4" because four of those hours were during "night time" hours 5) ClockIn = 3AM. ClockOut = 1AM the next day. Calc should return "7" because seven of those hours were during "night time" hours. Scenarios #4 and #5 have defeated me. I believe it has something to do with the fact that we have two separate groups of "night time" hours separated by a chunk of not-night-time hours. The phrase "recursive function" comes to mind, but not really sure, perhaps a really healthy LET and CASE without recursion?
  7. I've gone ahead and used ScriptMaster to create an example file that allows the user to select the folder of images to import. I'd still prefer to use AppleScript, but this can work for now. I've attached this example file for now in case anyone is curious. Thanks again! GroovyImport.fp7.zip
  8. Thanks for replying, Lee and Ocean. Lee, that's the very first thing I thought to try. It seems like it should work, but it doesn't. At least for me. What happens is I get an error #100 on that script step, it never gives a prompt to locate the folder again. I've tried this with the [X] No Dialog both check and unchecked, to the same exact result either way. Ocean, I was afraid it would go pretty much exactly how you describe. Please by all means do share if you can, any applescript etc to make it happen, would be grateful. Thanks!
  9. Looks great except it also fails #2 and #3. I am wondering if it's not possible without, say, applescript.
  10. Hello Newbie here. I am trying to create a remotely hosted FileMaker 11 script that has the following attributes: 1. Imports a folder full of image files. 2. The folder is never the same, it can be a different folder, on a different drive, etc. 3. Need to allow the user to select the folder they want. 4. Do NOT want the user to be presented with any other dialogue boxes, especially Import Field Order, or "Auto enter?" and so on. I've tried and tried, but every combination of options on the Import script step, in one way or another, does not meet all four criteria listed above at the same time. I can get it to do one-or-the-other, but not all of the above at the same time. How would one go about this? Thanks!
×

Important Information

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