Jump to content

Mandu

Members
  • Content Count

    388
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mandu

  • Rank
    member
  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 ability to talk to FM. :-/ Is there any way to get FM10 to convert an all-text layout to some sort of Word-readable rich-text file format ? Thanks for any suggestions, simple or convoluted ;-) Chap
  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 a way of accomplishing what I'm after? (I'm really hoping to avoid having separate layouts for Data Entry vs. Find.) Thanks, Chap
  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 it, not only for editing an existing record, but for adding a brand-new record and even for entering Find criteria. The way layouts have always been intended in FM. And of course there are a wide variety of places throughout the user interface that I might want to pop up this lovely window. For instance, I have a layout that shows a list of People - and I want to allow the user to click an Edit button next to one of the names, and have that drive Open_Person_Detail_Window to pop up the detail window. Or, there's a Script Menu item called "Add Person", and I'd like for that to somehow dovetail into Open_Person_Detail_Window, only this time with a freshly-created record. Or, a "Find Person" command that, again, leverages Open_Person_Detail_Window to handle the invariant issues of displaying the Lovely Window, but this time with a Find request. Or, suppose I have a Club Details layout, with a portal to various People who hold administrative positions at the club. From that layout, I might like to be able to click on a name in the portal and - bang - get the Person Details window. Let me try asking my question this way: assuming that other people have grappled with trying to write well-factored, reusable, modular scripts in FM, how would you design Open_People_Details_Window (the in/out parameters, its internal functionality, and how to use it)? Are there any "rules of thumb"? I've worked on this posting for an hour and a half, and I hope it's not complete gibberish. Thanks for any thoughts you have, or requests for clarification. Chap
  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 would be simplest), rather than as a static set of independent fields.
×
×
  • Create New...

Important Information

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