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. This can be done with some extra work using script triggers. Something like this: https://www.filemakermagazine.com/videos/endless-picture-sliders
  2. There was an under-the-hood session at a recent DevCon where the engineer from FileMaker stated that object visibility is the first thing evaluated when drawing a layout. If my understanding of this is correct, then Tony's conjecture above is incorrect. I.e., at least in terms of screen redraw you will not incur any performance penalty from hidden objects. However, each hide calculation must evaluate, so that will have a cost -- probably minimal from your example.
  3. You want to change the default style. So save the change to the Default style. Don't save it as a new style, and don't save it as a new theme. Make sure the field is set as Default style. Change the font. Save Changes to Current Style. Then Save Changes to Theme.
  4. Not sure what you're asking. You want to calculate the Opening Stock? Balance + Sold - Purchased
  5. Maybe I didn't explain it well, but if you save a change to the Default style, and you save that change to the theme, that will change the default for fields added to the layout. I tested it and it works.
  6. In Layout mode, hit ctrl-I or go to View > Inspectors > Inspector. Click on either the Styles or Appearance button (the 2nd and 3rd icons at the top of the Inspector). Select your field. Look at the Inspector, it will probably indicate you're using the Default style. Make a change to the field's style or font. Notice the triangle to the right of the field in the Inspector is now red, indicating you've overridden the saved style. Click the triangle and save the style. Notice the triangle to the right of the theme is now red. Click it to save the theme. You have now changed the default for this theme in this file. There's no built-in way to change this for all new files, but you can easily import your saved theme into a new file.
  7. Philip -- I "chickened out" of doing all your work for you? Wow. You're welcome. The reason you got the other email was that after I posted that formula, I realized it would fail if both Random calcs landed on zero, as you discovered. So I deleted the post.
  8. My take on it is that he didn't want any numbers that have 0 or 1. So maybe something like this: Let ( [ nums = List ( 2;3;4;5;6;7;8;9;22;23;24;25;26;27;28;29 ) ; // etc. vCount = ValueCount ( nums ) ; r = Int ( vCount * Random ) + 1 ; result = GetValue ( nums ; r ) ]; result )
  9. Another little trick I often use to verify portal objects is to to nudge the portal up or down with the arrow keys. Did the button move? If not, it's not in the portal.
  10. Regarding your aside, the "AS" is optional. Also, is all that "decimal" stuff really necessary for you? The point of that would be if you're concerned about your file being deployed in a country that uses a comma vs. a dot for decimal notation.
  11. As Michael said, your script logic isn't doing what you think it should do. I'll add that it doesn't make sense to have two separate error messages -- anyone who's not either "full" or "subpoena" fails BOTH tests, so which error message should they get? You might change it to something like: If[ Get ( CurrentPrivilegeSetName ) = "[Full Access]" or Get ( AccountGroupName ) = "CIENEW_Subpoena_RW" // authorized Else Show dialog Exit End If // proceed Etc. Note that it's often easier to understand when you frame your logic as a positive (equal) rather than a negative (not equal). I'll second what Michael pointed out about security -- if it really needs to be secure, it should be set up in the Security dialog. Lastly: instead of, or in addition to, your script -- you might consider simply hiding your button when the user is not authorized.
  12. You might try creating a new layout and pasting a copy of the portal there, or since it's a "simple" portal, re-creating it on a new layout. Does the portal have a sort or filter applied?
  13. Interesting roundup, Michael. Thank for taking the time to write this up.
  14. It's true, it doesn't make a lot of sense given that once in Manage Security, you could simply change the password of a full access account, or create a new full access account, and then authenticate with that when closing the dialog. All the more reason to not use EA for full access!
  15. It's not good practice to use EA for full access accounts. Use your local account for managing security.
  • Create New...

Important Information

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