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 am struggling to do something simple, which is to define a field that will display the filename of files stored ion a container field called 'Document'. I am using the GetContainerAttribute(sourceField;attributeName) function, but I can't seem to get the engine to recognize the field, which I'm entering by double-clicking it in the field list! I've tried using different attribute names, and tried doing it on other container fields in different files, but there's something I'm just not getting here . . . can anyone spot my problem in this image of my attempt?
  2. AHA! Mystery solved -- I'm doing a little work adding a few reports on a database just recently converted to .fmp12, and so it is in the 'Classic' theme. When I change to a proper theme, the problem goes away, so this is just an artifact of that obsolete layout style. It's not a huge issue, we can live with the gaps for this report.
  3. comment, thanks for the file. So, in your file, when I go to the layout with no grand summary, it looks fine. When I go to the layout with one it also looks fine -- if I change the grand summary to the same blue color, it previews just like the other one. . . . but in my file, I've tried it both ways, and I still get that white gap above the footer.
  4. Hmmm.... not having any effect. All my parts have solid fills -- black for the Headers and grey for everything else. Can you spot anything here? I'm trying to open up all sorts of old file trying to find how I did this before, with no luck.... The sub-summary text and horizontal rule are set to slide up . . .
  5. Hmmm . . . not sure I follow you. Not managing to get it to work . . .
  6. I know I've solved this before but can for the life of me recall how. I'm printing a sub-summary report, all good, but between the final record on a page and the Footer is a blank band of whitespace that goes unfilled because it's not large enough to fit the next record. I just want it to be the same color as the footer section. Can someone remind me how?
  7. 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?
  8. 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...
  9. 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?
  10. 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 . . .
  11. 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!
  12. 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 . . .
  13. 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.
  14. 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?
  • Create New...

Important Information

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