Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mandu

  • Rank
  1. What is the easiest way to compute the highest serial number in a column, in FM10? The serial numbers are of the form P-000002 - that is, fixed-width integer with alpha prefix (thus unusable by the max() function). If sort / goto record is the only way, so be it - just thought there might be a better way. Thanks, Chap
  2. Cool! Thanks for the feedback.
  3. Thanks - it looks like EZxslt would be the easiest route. My only concern is that the documentation at chapsoft.com appears to be from 6 to 8 years old, with references mostly to FMP6, no mention of Intel Macs, etc. Are others in the forum using EZxslt on current releases of MacOSX, Windows, and Filemaker?
  4. Hi, A customer wants a script to generate a "mail merge" from a small found set of People, creating a separate document for each letter. He wants to be able to open them in MS Word for additional editing, before printing them. I can define a layout with merge fields, no problem, but I have no idea how to write it (preserving the text stylings) to a file that can be read by Word. A long time ago I tried doing this the other way around, getting MS Word to do a mail-merge by accessing Filemaker, but it flopped horribly - finally turned out there were some known bugs in Word's abil
  5. I have a data-entry layout that includes a button for toggling a boolean field (Number, 0 or 1). Superimposed on the button is an Unstored Calculation that evaluates to a Container with either an image of a checkmark, if the boolean is 1, or nothing otherwise. Clicking the button XOR's the boolean with 1. In Browse mode this triggers the Unstored Calc to show or hide the checkmark. But in Find mode, while the button still works and sets the boolean, the UC apparently isn't being triggered - at any rate, no checkmark appears. Do UC's in fact not recalculate in Find mode? Is there
  6. I'm curious, Ashton: what's going on in this line of code? If [Let([$rec=Get(RecordNumber);$$RecID=If($rec≠$$Rec ID;Get(RecordNumber))];not $$RecID)] (I assume that $$RecID has nothing to do with the result of Get(RecordID)?)
  7. It's going to take me a day or two to absorb all this, but I wanted to gratefully acknowledge your contribution. You've definitely given me some useful ideas, like subscripting global variables and using the Evaluate function. Will post more to this thread later, but thank you for taking the time to share your ideas.
  8. Interesting article, thanks. It contains the following statement: I don't understand the final condition, "and the layout has no connection to the originating layout." What does it mean for one layout to be "connected" to another?
  9. Yes, that makes sense, although in my example I didn't mean to imply that I had a "LineItems 2". To use your TO names, I was simply using LineItems (the same TO being used to display the portal) as the target TO for my GTRR. I do get that Found Sets are "connected to" the TO that was being when the FS was created - say, via GTRR. You've been very helpful in my effort to grok this. Do you know of ANY published docs that address these intricacies with this kind of rigor and precision? I've never found any. Thanks, Chap
  10. Not sure of the distinction you're making - but I think I'm okay on this point. I think it was GTRR that started clouding my understanding in the first place.... If the underlying table is t_Orders, and I want to GTRR to a record in a portal of LineItems, I think I can go to a related record from t_LineItems and display it using any layout that belongs to a TO whose underlying table is t_LineItems (call it "L_LineItems_from_Orders"). And the resulting FS of LineItems then belongs to L_LineItems_from_Orders. Is that what you said? -)
  11. This helps.... So it sounds, from that, like a single window can have multiple FS's, by virtue of having gone to different layouts during the "lifetime" of the window.... And from that I would guess that reverting to a previous layout "brings back" its most recent FS...? So is an individual layout inextricably "bound" to a particular TO? Or is it possible to somehow bind it to other TO's with the same underlying table? Thanks!
  12. Sorry to seem dense, but do you mean that when a windows closes, the FS disappears? Or that a FS persists when you open a different layout in the same window? A script can run without opening a window. Can it create a FS without opening a window? I'm having trouble visualizing the relationships between these various entities.
  13. Basic question: what is a found set associated with (or, "what does a found set belong to")? A window? A layout? A portal? A script step? A table occurrence? Same question about a "current record". Thanks Chap
  14. So, I have a nice layout (let's call it Person_Details) that contains all the fields in a People record. And I have a script (let's call it Open_Person_Detail_Window) that creates a new window containing this layout. Encapsulated here, like the contents of a black box, are the things I want to always happen when displaying this window: Zoom=100%, View=Form, Hide Status Area, Resize To Fit, and Moving the window to the center of the screen. It's nice having one script to encapsulate these invariant details. This layout is so nice, however, that it's awfully tempting to want to use
  15. Okay - I think I know what I wasn't initially seeing: I'm converting an old MS-Access database, which had a "layout" showing various positions (and the people holding them) for a group. These were entirely static: Contact1 Contact2 Contact3 Treasurer Secretary Chairperson etc. and I was attempting to mimic this setup, with separate fields in the Group record for Contact1_PersonID, Contact2_PersonID, Contact3_PersonID, etc. Hence the proliferation of relationships. If I understand your approach, it's to present all the positions for a group in a list (a portal
  • Create New...

Important Information

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