Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Fitch last won the day on March 19

Fitch had the most liked content!

Community Reputation

169 Excellent


About Fitch

  • Rank
    Imaginary friend

Profile Information

  • Title
  • Industry
    Public health
  • Gender
  • Location
    Portland, Oregon

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra and Win 10

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet

Recent Profile Visitors

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

  1. Just browsing the chapter headings Dan linked should give you a good idea: https://fmhelp.filemaker.com/help/18/fmp/en/ I'd agree platform is important: WebDirect, Custom Web Publishing (CWP), Data API, FileMaker Go. Security is on the radar of most companies these days. Get familiar with FileMaker's security model, including all the options of the Security dialog, encryption at rest (EAR), and field-level encryption. You should be aware of developer tools that are out there, such as BaseElements, FMPerception, plugins, etc. I still recommend the FileMaker Training Series book -- even though it hasn't been updated since version 15, most of it is still applicable: https://community.filemaker.com/en/s/article/free-filemaker-training-series--advanced-for-filemaker-15 and then you can supplement with what's new, e.g. Card Windows: https://www.filemaker.com/products/filemaker-pro-advanced/version-comparison.html#fm16 Welcome to the forums!
  2. "Importing/exporting directly to and from another FileMaker Pro file is not supported via a FileMaker Server scheduled script." https://support.filemaker.com/s/article/Import-Export-script-on-FileMaker-Server-1503692951014?language=en_US
  3. I split this topic off from a 10-year old thread. If a file needs recovery then you're always safer to go to a backup or start fresh. Doesn't mean you can't proceed with a recovered file, but you're taking a risk.
  4. FileMaker 10 is a 10 year old product. It isn't supported on Mojave, or current versions of Windows. https://support.filemaker.com/s/article/FileMaker-Pro-operating-system-requirements-all-versions-1503692917754?language=en_US Also, FileMaker isn't an Apple product. The company (now Claris) is owned by Apple but that's not the same thing. Welcome to the forums.
  5. I see this was cross-posted here: https://community.filemaker.com/en/s/question/0D50H000075EFdbSAG/can-the-script-below-be-converted-to-filemaker-function Please be respectful of people's time and let us know in future if you're doing that.
  6. https://fmhelp.filemaker.com/help/18/fmp/en/#page/FMP_Help%2Fmathematical-operators.html%23ww1029353 https://fmhelp.filemaker.com/help/18/fmp/en/#page/FMP_Help%2Flogical-operators.html https://fmhelp.filemaker.com/help/18/fmp/en/#page/FMP_Help%2Fsqrt.html%23 https://fmhelp.filemaker.com/help/18/fmp/en/#page/FMP_Help%2Flet.html%23
  7. The most common reason for this type of portal problem is that the button is not entirely inside the portal. The next thing to check is as @comment mentioned, your button does something other than Go to Related Record (such as Go to Layout or a script you're not telling us about). Please update your profile with your FileMaker version etc. It makes it easier for us to advise you if we know what we're dealing with.
  8. I had a similar experience, not quite so drastic, where a file was growing something like 100 MB/day. But it was an interface file where no data was being added. To troubleshoot, I took a copy of the file and since, as you discovered, cloning doesn't fix it, and deleting fields didn't fix it, I started deleting tables, then closing the file to see the effect on file size. If you have a lot of tables you can hone in on the culprit by deleting half of them, check size, if no change, delete half of remaining, etc. It turned out deleting one particular table made a difference. Even though it supposedly had no data. Then I had a thought -- what about the truncate script step? It worked! Whatever was lurking in that table -- presumably something in a container -- was flushed out by truncate. Good luck and welcome to FM Forums.
  9. That's a good example. The number of questions and the reporting requirements of course would factor in to which approach to take. How would you display the min/max/averages in your scenario?
  10. All I suggested was that you could have multiple fields in a table. Attributes of an entity. Like I said earlier, I've built questionnaire/survey systems. Sometimes it makes sense to store the answers as individual records. But then to analyze the data I would say does require a fair amount of effort, e.g. to build a pivot table. Other times it makes sense to store the answers as fields. E.g., we use a Case Log database in my office (public health) to gather data for certain types of outbreaks. Each symptom (cough, headache, fever) is a checkbox on a case record. From this we can produce epidemic curves and other analyses, with relatively little effort.
  11. Including multiple data points in a record does not preclude meaningful analysis. Just sayin'.
  12. Haven't looked at your file yet. But the type of structure you described above is typical of a system that is used for building surveys. I.e., it's made to be flexible so that questions can be added on the fly without adding new fields. I have built such systems. But is that really what's needed here? I'd consider a drastically simpler model where you simply add questions as fields to the Survey table and get rid of all those other tables.
  13. First thing to check is that the fields are actually in the portal. They may look like they are but the way to tell for sure is to click the portal so it's selected -- don't select the fields, just the portal -- and then nudge it up or down with the arrow key. Did the fields move? If not, that's your problem.
  • Create New...

Important Information

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