Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


jbante last won the day on May 16 2019

jbante had the most liked content!

Community Reputation

143 Excellent

1 Follower

About jbante

  • Rank

Profile Information

  • Gender
    Not Telling
  • Location

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification

Recent Profile Visitors

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

  1. Many people use "developer" and "programmer" interchangeably. Many other people distinguish between "developer" and "programmer" different ways. One way to distinguish between them that is somewhat unique to the FileMaker community is that a "programmer" just does programming logic (data schema, scripts, calculations), whereas a "developer" is also skilled at user interface design. The US Bureau of Labor Statistics (BLS) does make a distinction in it's Standard Occupational Classification (SOC): In short, according to the BLS, a "computer programmer" implements a specification wri
  2. FileMaker has used fixed-point arithmetic for a long time.
  3. For folks with a background emphasizing data analysis, there are examples of folks pulling FileMaker data into R and Python by hosting a FileMaker database through an ODBC connection. There isn't much training to be had on this except the documentation for FileMaker, R, and Python on how to use ODBC connections. For folks with a background emphasizing software development, there are examples of folks using a plugin to crunch numbers using Java (with the 360Works plugin) or JavaScript (with the BaseElements plugin) libraries. For the price of more labor setting things up, there are also ex
  4. I realized the potential confusion with that this morning and re-named the parameters to "radius1" and "radius2". You should be passing ( width / 2 ) and ( length / 2 ) as the parameters (the order doesn't matter): EllipseCircumference ( width / 2 ; length / 2 )
  5. So you're asking about how to copy my calculation into your file as a custom function? FileMaker's help documents how to make custom functions in general. Copy the calculation code for the EllipseCircumference custom function from GitHub. Open your file in FileMaker Pro Advanced. Open File > Manage > Custom Functions... In the "Manage Custom Functions" dialog, click the "New..." button in the bottom-left corner. In the "Edit Custom Function" dialog, paste the function code into the function calculation box. Set the "Function Name" and "Function Parame
  6. I believe the moderators of this forum prefer that transactional conversations happen in private messages. Aside from that, I'm not sure exactly what you mean by "teach me the function". Do you want to understand how the math works? I think that's much more than a 1-2 hour conversation, and there's plenty of other information linked to from the Wikipedia page for ellipses that can steer you in the right direction. Do you want a script version of the same thing? That could be done pretty easily, but this is a use where I think a custom function is a less clumsy solution to use. (I'll grant
  7. Try this custom function for a reasonably exact calculation.
  8. It looks like the calculation you found is approximating the circumference of an ellipse as the circumference of a circle with radius half-way between the circles that inscribe and circumscribe the ellipse. You could calculate upper and lower bounds as the circumferences of those 2 circles. The Wikipedia page includes some more bounds. Combining them in FileMaker might look like: lowerBound = Max ( Pi * ( width + height ) ; 4 * Sqrt ( width^2 + height^2 ) ) upperBound = Min ( 2 * Pi * Max ( width ; height ) ; 4 * ( width + height ) ; Pi * Sqrt ( 2 * ( width^2 + height^2 ) ) ) If
  9. Calculating the circumference of an ellipse is complicated. Any simple formula you find is likely to be an approximation, so it's natural to expect that they won't all get the same answer. How close is close enough for your app?
  10. What you're describing is the knapsack problem. The Wikipedia pages includes descriptions of several approaches to solving it for you to consider.
  11. I made a solution once that works in the other direction: given a point, find which polygons in the database contain it. There are a couple ways to do this, but the way that executed fastest was to decompose each polygon into geohashes covering the same region in advance, then calculate the geohash for the point of interest and perform an exact match find on the geohash. (When it's important to keep the database small, you can decompose regions into different-precision geohashes depending on what's necessary to cover the shape of the region, then finding a region for a point consists of attemp
  12. While you're editing the custom function, you need to set what the parameters are before the calculation will recognize the "bytes" and "precision" tokens, which would be undefined otherwise.
  13. Then use stored number fields instead of calculation fields, and set each quartile field in a script that does separate sorts before setting each quartile field. A script also potentially makes it easier to handle ties, to address LaRetta's point.
  • Create New...

Important Information

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