Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About benmayo

  • Rank
  1. Dear FileMakers, I am attempting to write a script to Ping an IP address, perhaps 10 times over, and to output an average response time in ms, and the packet loss as a %age to fields in my DB. In my searches, I found an AppleScript which can be called from within FM and give a response time within a dialogue, but no %age packet loss, in a dialogue: https://discussions.apple.com/thread/3833490?start=0&tstart=0 And that is as far as I've got in quite a long time. Ideally, calling the script from within FM would trigger the ping test and output the time and packet loss to their respective fields, but if this is unfeasible then simply outputting to dialogue would be ok. Thank you in advance, please advise if further information is required to provide useful assistance. Ben
  2. Thank you Comment, that is a very elegant solution and works perfectly.
  3. Dear FileMakers I have two data loggers, each outputting data to a CSV file, which then gets imported into two separate tables on my FM DB. One data logger creates a record each second, the other each minutes. So I can splice the seconds data together with the minutes data, I am trying to create a third table with time in minutes, which averages the data from the seconds table. So I'm trying to create a third table to average the output of the seconds table into minutes. Starting at the Average table, I need to get the value in the time field (say 12:20) and to then go to the Seconds table, and find all records between 12:20:00 and 12:20:59, take an average of the specific field and then paste that back into the relevant field within the Average table. That's how the code would run in my head - but I might be way off base. I hope someone can unpick this for me and help. Many thanks, Ben
  4. Ok - sorry, one more question I also have a date filter, enabling me to search between dates. The script I was using for that was: Set Field [Datefield; GlobalStartDate & "..." & GlobalEndDate] However, I can't make it work with the checkbox code Comment provided. Could someone explain how I should work it into the script, so I can search for multiple trains across selected dates? Thanks!
  5. That is perfect, exactly what I was looking for - the script works great! This is also extremely useful - I would not have known that. Thanks for your help, Ben
  6. Right - that's exactly what I'm trying to achieve - in the file I provided there is a global check box field, and a find button, set to perform the following script: Enter Find Mode [] Set Field [CheckBox::Train; CheckBox::Global Train] Perform Find [] The outcome of this is: Selecting Train 5 brings up results for 5 Selecting Train 6 brings up results for 6 Selecting 5 and 6 brings up results for 56 - when I'm looking for results from 5 or 6 Ben
  7. Ok, I know how to new find requests to provide the OR function, and I know how to find records. I've got those basics down now. I need to make the interface perform as the user would expect it to and minimise their learning curve - and I think they'll already understand the checkbox set to represent an OR search, without training them in find requests. Isn't that the purpose the checkbox is meant to serve? If not, what does it do?
  8. Hi Barbra, I work for a company providing internet access to high-speed rail. There are 25 trains in this particular fleet. Everyday the trains run their routes, and we collect lots of data from various sources regarding the performance of our systems. Right now I can search one train, across a date range, and see how it's performed over a period - which is very useful. But I can't search the whole fleet on one day. Or maybe take a look at a few trains of particular interest. For my own education, how would you input that search? For example, I know that 5...10 would search trains 5 through 10. How would I request trains 5 or 10? Thanks, Ben
  9. I'm looking to be able to find multiples Thanks, Ben
  10. Thanks (again!) for the reply Lee, Regret that I don't understand how to hook that piece of code up to the checkbox. To be clear, the user should be able to search for x OR y OR z, with x y and z being defined via the 1>10 checkbox range. Am I missing something here? Ben
  11. Dear FileMakers, I'm trying to get a checkbox menu to work. Please see the example. There are 10 trains. When I select train 5, the find brings up train 5's data. Then, when I also select train 6, it finds train 56's data. There is no train 56 - I'm trying to bring up results for train 5 OR train 6. Seems it should be very simple, but it's had me going around in circles. If someone could the attached to work, and provide a explanation of how you did it I'd be so grateful! Ben CheckBox.zip
  12. Hi Lee, Doug, My fault for not being clear in my explanation and causing confusion - but Doug hit the nail right on the head. Thanks so much for going to the trouble of making that up for me. The user selects ok / not ok / not available. The field with the number is hidden, they just simply use the colours.
  13. Hi Lee, I think I may have confused the situation with my incorrect terminology. What I'm trying to achieve: On the first click of the button, the value in the field is 1 On the second click, the value in the field is 2 And so on... I'm not trying to make the button change shape as I hover over it. Thanks for your help. Ben
  14. Thanks Lee, very helpful. As a first poster, it's great to get a response from the man whose contributions to this forum have helped me so many times. Ben
  15. Dear FileMakers, I'm trying to create a single button with three different states, through which the user can toggle. I've completed the following tutorial: http://www.filemaker.com/11help/html/fmpa_tools.24.23.html ...and have the button with it's three different colours toggling nicely. Where I'm stuck is attaching a value to the different states. How do I get the button to output values (1, 2 and 3) into a field? Thanks in advance, Ben
  • Create New...

Important Information

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