Jump to content

Fitch

Moderators
  • Content Count

    4,728
  • Joined

  • Last visited

  • Days Won

    59

Fitch last won the day on March 19

Fitch had the most liked content!

Community Reputation

169 Excellent

2 Followers

About Fitch

  • Rank
    Imaginary friend

Profile Information

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

Contact Methods

  • Website URL
    http://www.fitchandfitch.com

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    18

Platform Environment

  • OS Platform
    X-Platform
  • OS Version
    High Sierra and Win 10

FileMaker Partner

  • Certification
    7
    8
    9
    10
    12
    13
    16
  • Membership
    FileMaker TechNet

Recent Profile Visitors

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

  1. 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.
  2. 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.
  3. 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.
  4. 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
  5. 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.
  6. 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.
  7. 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?
  8. 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.
  9. Including multiple data points in a record does not preclude meaningful analysis. Just sayin'.
  10. 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.
  11. 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.
  12. https://community.filemaker.com/en/s/feed/0D50H00006ezLwLSAU
  13. It's a Windows bug and there have been reports about it for years. It's super annoying. Sometimes you can get to the selection you want by using the arrow keys. Only other option is to restart the app.
  14. Double-check the 8.1 updates? Windows 8.1 Standard Edition Windows 8.1 Pro Edition System updates 2919355 and 2999226
  15. This can be done with some extra work using script triggers. Something like this: https://www.filemakermagazine.com/videos/endless-picture-sliders
×
×
  • Create New...

Important Information

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