Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Wickerman last won the day on August 31 2018

Wickerman had the most liked content!

Community Reputation

3 Neutral

About Wickerman

  • Rank
  • Birthday 11/21/1963

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    10.13.2 High Sierra

Recent Profile Visitors

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

  1. I'm keeping track of tournament results for a backgammon club in which each player receives points for achievement in our monthly tournaments, leading to a season champion at the end of the year. So I have a PLAYERS table and an EVENTS table and then a join table in between, PERFORMANCE, that holds the results for a single player at a single tournament. So, I have a list view that shows each player's results with a sub-summary part totaling their cumulative point total defined as a Summary field in the Performance table set to = Total of Points. This all adds up and displays fine. . . . but after sorting the records by Player name to get the sub-summary, I would like to be able to sort them by Points total -- that's the point after all, to rank them from most to least points. But I can't sort on a Summary field, right? Am I modeling this wrong? Or is there a technique I'm not seeing that will enable me to sort the results by this summary value?
  2. You mean just before re-sizing? This doesn't seem to be making a difference . . . I've tried it a couple different places but not sure if I'm missing something...
  3. My head is spinning trying to grasp the implication of creating and installing various menu sets. I have a pretty simple situation, with a 'Staff' menu set that severely restricts menu accesss in all layouts. I have the Staff menu defined to display when Get(AccountPrivilegeSetName) = "Staff". That seems to work okay. All other logins enjoy "Full Access" privileges and the standard Filemaker menu set, which is set as the default for the file. This is all working okay. The thing is, I have two layouts a 'home page' and a 'preferences' settings page where i don't want to allow record creation or deletion. I thought I could create a custom menu set, called say "Restricted" where I include all the standard menus but edit the 'Records' menu to remove anything to do with record creation/deletion. Then on the 'Layout Setup' panel for those fields I specify that 'Restrict5ed' set as the "Menu Set." . . . but this doesn't seem to work -- I feel like my various settings are conflicting or pre-empting one another. Having made this change, the Staff menus no longer seem to apply. Once you visit the home page, it installs the 'Restricted' set and then those persist even in other layouts? There just seem to be too many variables -- between 'default' menu sets, the 'Set menus' login script command, the layout-specific setup . . . I feel like I'm just thrashing around trying this then that and messing up stuff that was already working and not understanding which option takes precedence in any given situation. Is there a resource anyplace for putting all this in perspective?
  4. I have a simple script that allows the user to re-login under a different username. if the user has 'Staff' privileges, the status area is hidden. Otherwise, it is on display. This works fine. But for some reason the 'Resize to Fit' step only seems to work intermittently. The *first* time I use the button and go to a Staff login, it works . . but if I go back and forth a second time, it doesn't, so there's about an inch of dead window space opened up on the bottom of the layout. Can anyone explain why this is happening? Thanks! Here's a picture of the script . . .
  5. I have a table that I want to use for preference settings and another I want to use as a 'Home' page. These should both be '1-record' layouts. Is there any simpler way of preventing record creation (and deletion) other than creating custom menus with the 'New Record' / Delete record commands turned off? I'd guess probably not, but sometimes I discover I do things the hard way, so would appreciate a little confirmation!
  6. Oh of course -- I knew that once, but it hasn't come up for long enough that I forgot. So would the approach be to create a new table to hold these 'boilerplate' fields create the first record, and then use an (X) relationship to connect it to the TO my main layout is based on? I have a button that summons a card window I would base on this boilerplate table and when the user edits the text it will be permanently storing it in the one related record? Is that the right approach? Oh wait . . . since the Card Window has its own context, it doesn't even have to be related to the table on the main layout, right? I think I've got it . . .
  7. Thank you -- but could you clarify what you mean by "single record table"? I haven't come across that before. . . I'm imagining maybe I create a table with these 'boilerplate' fields in it and related it to the table my layout is based on, so there is no occasion to create new records in it? Also, could you maybe elucidate why values in global fields wouldn't be saved just as data in 'normal' text fields is? I'd kind of like to know the mechanism by which this is failing. I really appreciate your responses. a.
  8. I've set up an email feature that allows the user to store 'boilerplate' text to be inserted at the beginning and end of a message when a Send email script is triggered. It's working fine on my desktop version of the file. However, my client is finding that when she changes the boilerplate text in those global fields and closes the file, when she reopens the file, the changes have not been retained. Simple text fields, global storage. My client is using the files via Filemaker Server 16. Can anyone suggest why this would be happening?
  9. I have a fairly simple privilege setup for a 'Staff' login that employs a custom Menu Set. I have simple script that runs on user log-in that installs the custom set if the user is a 'Staff' member. It works fine. But I have a 'Re-Login' button to make it easy for Staff and Supervisors to switch in and out depending who's on the machine. It does switch the privileges appropriately, but the menu set doesn't change. Can someone tell me what's wrong with this script? Here are both of them . . . Help!
  10. I have a file that sometimes behaves oddly when I open it. After I log in, the window opens, then immediately minimizes down into my Apple dock but bounces right back and is fine. I've got a very simple opening script (see below). I can't seem to make it happen consistently, so it's hard to nail down. Any ideas?
  11. Thanks for all the comments -- I took the card Window approach and it's working great. Not sure whether my client wants to use the SMTP option. If you use that approach, the email goes right out, when triggered, yes? Unlike the client method, where they get a chance to edit further in the Mail window.?
  12. I figured out the glitch - silly little thing. So this topic can go away
  13. I'm baffled by this one. I have a few logins set up with different privilege sets attached. I have a button on my main layout with the one-step "Re-Login [with dialogue:On]" script step attached. Next to the button I have a little merge field displaying the name of the current Log-in account. Logging in either way at the beginning is working fine, as expected. When I try the Re-Login button and enter a different account, the merge field displays the change appropriately . . . but the privileges aren't changing over accordingly!? This happens in either direction -- whichever account I start with, those privileges remain in force. (One of the accounts is all-access, the other has a very limited Privileges Set). I can't fathom what's amiss here -- any suggestions?
  14. I have a script that the user triggers to set up an email which they can then edit and send. After sending, I want the user to have an option to store a record of the email in a sub-table - because if the user cancels the email, there should be no record of having sent one. I'm thinking the way this should work is I use 'Pause Script' after the 'Send Mail' step, and then after the user finishes in the email window and returns to Filemaker and either cancels the rest of the script process or continues with it and the sub-record is created. This can be achieved by just having the user click "Continue" or "Cancel" on the window . . . but those buttons can be a little hard to notice if you don't already know to look for them. I'd think a Custom Dialogue offering the option would be better - - but is there a way to resume the script via a dialogue box - - or any way to get the script going again aside from using the timer option? - - or perhaps just a better way to approach this ?
  • Create New...

Important Information

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