Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Fitch

  1. I wrote an article last year showing how to do what Steve's talking about: https://www.fitchandfitch.com/2020/05/modern-commitment/ (My site has an expired SSL certificate right now, so you may get an ominous security warning, but I assure you it's perfectly safe.) I agree with Steve, no reason to change your globals. But if I'm creating something new I'll most likely use the script trigger method.
  2. You may want to use the PatternCount or Position functions. Can you give an example of what you mean?
  3. You can download a trial version of FileMaker 11 here: https://support.claris.com/s/answerview?anum=000024703&language=en_US That will convert your files to the .fp7 format that you need.
  4. Maybe start with this: https://www.briandunning.com/cf/378
  5. It's been suggested but you could certainly suggest it again. https://community.claris.com/en/s/idea/0870H000000fy1nQAA/detail Welcome to FM Forums.
  6. Top nav also doesn't print or zoom. It's a feature unless you're not expecting it.
  7. You might consider using a pick list in a popover portal, or a list in a card window. In some ways that can be less overhead than a conditional value list, but if that's what you're set on here you go: https://support.claris.com/s/article/Creating-conditional-Value-Lists-1503692929150?language=en_US
  8. You might want to start with the invoicing example that comes with FileMaker, or other example files from the Claris site. This is more a scripting question than a layout question -- e.g., a script that takes you to your product layout, perhaps in Find mode, and then... various things depending on your particular vision.
  9. Sorry you're not getting replies. Probably not too many folks here running version 13. A quick google turned up a few hits. Looks like it may be workable, and some have had issues with the web server. For example: https://fmforums.com/topic/94010-filemaker-server-13-installation-issues-on-windows-2012-r2/ https://kbase.io/installation-of-filemaker-13-or-14-on-windows-server/
  10. I see what you're saying -- I hadn't considered that the whole path had to be space-free. I'll take your word for it and of course completely agree that Claris should fix it, especially since this isn't the first version to have this issue.
  11. I'm saying they should extract it to a folder with no spaces.
  12. Good job and thanks for posting the solution. Just had this experience today -- luckily we remembered having this issue with some past installers. Why don't they just name the installer folder with no spaces to begin with?
  13. You're right to enter Find mode before switching layouts. However, if you don't actually need to find specific records, I'd recommend creating a blank layout for each table as needed for your scripted processes. A layout with no fields will not fetch any data from the server. This should be faster than performing a Find. You might also consider opening a new window for the blank layout and then closing it -- switching layouts might have a performance cost. However, I would not recommend opening a whole lot of new windows, say in a looping script. That can slow things down. Welcome to the forums. You might be interested in this:
  14. It sorts when you change views -- that would indicate a script trigger is active on that layout. You can deal with that in the Layout Setup dialog.
  15. I'm using FileMaker 18 on High Sierra and was able to add new records with no issue.
  16. Remove the script trigger from the popover, and instead add this to the top of the popover open script: If[ FOODS::__pk_FOODS = FOODS::highlightGlobal ] Set Field[ FOODS::highlightGlobal ; "" ] Exit Script End If
  17. I've found it generally useful to create a single-line script for each Print Setup that I might need -- landscape single, landscape all, portrait single, portrait all, etc. -- and then call those scripts as needed, such as within your If/Else steps. That way you only have to set them up once and never think about it again.
  18. Tableau conference starts tomorrow and is FREE this year https://www.tableau.com/community/events/conference We're moving more and more of our FileMaker data viz to Tableau -- there's bound to be some interesting stuff here even if you've never tried it.
  19. That said, this is no substitute for proper security. Each user should have an account, either in the file or, better, external authentication. Also - welcome to the forums, please add your FileMaker version and OS to your profile so we can better answer your questions.
  20. For each file: Go to File > Sharing > Configure for WebDirect and select the 'don't display' checkbox. Then send everyone the direct links to the files you want them to access.
  21. No. One table. One layout. Each part is a RECORD in that table.
  22. Oh my. You have a mess here with 'Inspection item 1', 'Inspection item 2', etc. That's generally a terrible design. Each of those should be a single record with a field 'Inspection item'. You could then use a portal or list to display all the inspection items for a give inspection. You could make a button on each item that runs a script that brings up your pass/fail portal in a card window. Or, the script could put the inspection item ID in a global field, and you could display a portal on the inspection layout based on a relationship from the global to the pass/fail table.
  23. It sounds like what you should build is a 'Sample' table that is related to your inspection item. It would just have a single field where you mark it pass or fail (or possibly two fields). It's pretty simple to generate as many records as needed via script. Or, you could make the relationship 'allow create' and go to a layout based on the item with a portal to the sample -- then the user would just enter as many rows as needed. Welcome to the forums.
  24. It's common practice to create a Preferences table that stores a single record. You can work with that data in various ways - through a relationship, via SQL, via script, or load the data into global fields or variables at startup.
  • Create New...

Important Information

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