Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About RadioSaigon

  • Rank

Profile Information

  • Industry
  • Gender

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    10.13.5 High Sierra

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

849 profile views
  1. I knew I wasn’t seeing the woods for the trees! Many thanks comment, that’s working perfectly. Regards
  2. Greetings I have spent a fruitless couple of days searching, testing and generally getting frustrated... I’m relatively certain my problem is a simple one, however: I am trying to calculate fuel required for a trip. It’s a simple Time/Speed/Distance calculation. The basic mathematics is in place and calculating accurately, so so-far, so-good. BUT, what I need the result to display as, is a whole number, Rounded UP to the nearest 50/100. So for example, if my TSD calculation returns a result of let’s say 716, I would want the result to display 750. Similarly if the calculation result
  3. @bcooney: many thanks! The google search has definitely thrown-up some interesting possibilities! I’ll look at each and see how best to implement. Why? My database stores around 450-odd different airstrips for which there has previously been no or very little data available for, as well as another 800-odd route and approach waypoints. The airstrip records each comprise roughly 90 unique data-points, the waypoints a lot simpler at under 10 data-points. I currently publish the data as PDF documents both electronically and as hard copy. The electronic document I further process with internal
  4. Greetings I wonder if anyone knows of a method for FMP to monitor the fields and records in my database for changes, flag and report the changes on a semi-regular basis? if I can achieve a report, it would massively simplify my update process, for hard-copy and PDF distributed documents. TIA for any suggestions! RS
  5. Hi there My database downloads a map (Google Map API), based on coordinates within the database records. I have the same field on another Layout (intended for printing) which is (currently) downloading the same map, every time. Unfortunately, it won't print. I'm guessing because the database itself is so large -around 1000 records- that it's trying to download the maps for every record prior to printing, locking the whole system up. So my query: as the coordinate data related to each record is quite static, is it at all possible to simply download the map Once, store it and reuse the
  6. Pleased to be able to advise, it turns out to be easier/simpler than I thought! I have modified all my existing TIME fields to be an Auto-entered, Calculated value, with the calculation above referencing back to the same field. So, if the field I'm working on is formatted as a Time field, and I have called it Time1, for example, my calculation is: Let ( t = GetAsText ( time1 ) ; Time ( Div ( t ; 100 ) ; Mod ( t ; 100 ) ; 0 ) ) I have unchecked the "Do not replace existing value (if any)" box. It's working exactly as I'd hoped, with everything working as it should.
  7. ...and it works! Now all I have to do is work it into my database without upsetting all the existing calculations! The calculation: Let ( t = GetAsText ( YourTable::Timefield ) ; Time ( Div ( t ; 100 ) ; Mod ( t ; 100 ) ; 0 ) ) I created a calculated field, as above, selected Calculated result as: TIME, 1 repetition, and "do not evaluate if all referenced fields are empty" selected. Data entry takes place as 0125 in a TEXT field, and reports where I want it as 01:25. I'll need to do a little shuffling for aesthetics sake, but that's a relatively minor thing now. I said
  8. hmmmm ok, I'll go looking for it again! Thanks... likely my assumption it was a script-step that bought me undone. 205 would still enter as 02:05... the fields are all set for leading zeroes. 25? Don't know. I'll try it and see. Just 5? as I understand the data-entry rules for FMP, that would enter as 05:00. My understanding is that single-digit entries are assumed to be hours. You might be obscuring the woods with trees there a little... my database is designed for and will be used by aviation professionals, all of whom are pretty au fait with 24hr time-entry systems. I'm merely try
  9. Greetings I'm running FMP14 on a Mac. I have several time fields, all of which are configured to UTC time in 24hr format and are working pretty much as expected. Several calculation fields are run off those fields. My issue is, during data-entry, not everyone is as consistent in their notation as perhaps would be ideal... we all know how FMP loves consistency! To resolve difficulties there, and remove the need to enter ":" between HH & mm, (as in 23:45 =5 keystrokes, and a Shift-key), I'd like my dbase users to be able to enter their times as simply 2345 and have FMP manage
  10. Greetings. New to the forum, using FMP14 on a Mac running Mavericks, FMP novice, aviation industry. Right... I think the best way to get to where I need to be is provide a little background: I'm working in what would politely be termed a 3rd World area -Papua in Indonesia, to be precise. There is not a lot in the way of structured organisation at a professional level here. I have developed (over the last 4 years or so) a database of navigational waypoints which we use here daily. I have sourced the data from a fairly diverse range of sources and now have a database that is really quite us
  • Create New...

Important Information

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