KurtW

I think that's what Soren was trying to tell me, also. I think I see the logic and am going to try and break it down. Thanks, Queue.

Okay, here

Thanks Soren: I think you hit the nail on the head with the 'adding apples to bananas' thing. I can see that is definitely the error in at least part of this. I think I am close, but can probably adapt some of what you said if I fail. Thanks for the help. Kurt

Transpower - why would I drop the division by 60? Isn't that what's giving me my minutes? After I removed the division I got some seriously weird results. Not sure if this is the way to go. Lee - I must admit I'm still trying to figure out what your equation does, but I'll keep knocking on it. Thanks

Hi all: I want to increment the duration of a trip in .15 min blocks for billing. I am currently using this equation: Hour(TripTimeCalc) + ( Case ( Minute(TripTimeCalc)/60 >= 0 and Minute(TripTimeCalc)/60 <= 14 ; 0 ; Minute(TripTimeCalc)/60 >= 15 and Minute(TripTimeCalc)/60 <= 29 ; 15 ; Minute(TripTimeCalc)/60 >= 30 and Minute(TripTimeCalc)/60 <= 44 ; 30 ; Minute(TripTimeCalc)/60 >= 45 and Minute(TripTimeCalc)/60 <= 59 ; 45 ; ) ) ... but it returns 0 mins no matter what is fed in. (I should also mention that the field TripTimeCalc is derived using: If ( DayBreak = "No" ; ActReturnOrig - ActDepartOrig ; ( (GetAsTime ( "11:59:59 PM" ) - ActDepartOrig) + ActReturnOrig - GetAsTime ( "12:00 AM" ) ) ) ... FWIW Can anyone see what I may have done wrong? Can you use 'AND' to add an argument to a Case() function? Thanks Kurt

We recently built a solution that relies on two windows: a main body window and a right-side menu that is there through 90% of the app. What I found that worked was creating a new table just to hold dimensions of the windows. I reference this table and its data whenever I open a new window or reset/resize. I manually calculated the pixel dimensions for each (trial and error) based on the monitor resolution I knew we would force the client to use. It's pretty handy. Kurt

Thanks for the data. Kurt

Thanks gents. I had been considering developer a while back. Is it true that the executable that are generated are really, really large? I had heard this was an issue with Developer. Thanks Sorry for the slow reply. Been nasty sick. Kurt

Hey all: Is there any way to keep Debugs in your scripts but comment them or render them deactivated until you need them? I am trying to meticulously debug and, once a script is working, I HATE the idea of having to delete 40 debugs I may need later if a simple change is made to the script. And is there any way (plugin, maybe?) to place line numbers in a FM script? TRhe lack of these two features (or my lack of knowing how to implement them) is killing me. Thanks Kurt

Actually, a better idea would be to place the global fields directly on a layout with only text colons between them for display. Then the use would be entering the data directly into first an hour field, then a minutes field, then seconds and finally the frames. You will have to be very careful to increment your calculaions based on the frames, too. I haven't thought about what formula you would use but I will try. The frames count is definietly where you may trip up.

Well, a simple way would be to demand that your users enter ALL characters of the desired timecode. IOW, don't leave off any zeros. Now you can pull apart the passed timecode based on the position of the text. (I would place the separated pieces into global fields and calculate that way.)Any number at positions 1 or 2 is an hour part. Any numbers at positions 4 & 5 are minutes, 7 & 8 are seconds and 10 & 11 are frames. Take a look at the text functions list, particularly ValueCount(), MiddleWords() and Length(). Is that what you were looking for? Kurt

AH! I had it backward. The monthName is now just a display tool but the monthNum is entered into the field. I get it. That should do it for me. Thanks for the help. Kurt

Thanks Ralph - I actually did exactly that but found I was seeing both values in the dropdown but FM told me it was passing only the 1st value. I guess I screwed it up, then. I will try that again from the start. Kurt

Hey all: I want to allow a user to select a month, day and year from popup-menus to create a search date for a find. I want to display the month name as the selection choice, but want to pass the month number as the actual data entered into a global field for my calculation. I know how to display a second value in the list, but that

That makes a lot of sense, I am going to give it a try. Thanks for the help, Queue.

AH - was beginning to see that. Can you explain more about the calculated sum you mention?

No, the field is a summary field inside the 'Trips' table. And it DOES summarize correctly on a similar layout based on the 'Trips' table. But once I try to do something like it off of the 'Invoices' table, it wonks out. MUST you base a layout off of the table upon which you want a summary field to act? Or should the relationships allow summary fields to work in layouts based off different tables? Thanks

THIS POST WAS A REPLY TO MY OWN AS A FOLLOW-UP QUESTION, AND NOT AN ANSWER TO ANOTHER POSTER. Have been trying various combinations of base-tables and sorts, and I get the farthest when I use 'Invoices' as the base table, but still cannot get the sub-summary to work. Is it absolutely necessary for me to have to do some calculations in the creation of the Invoices themselves that will carry a summary amount from the 'Trips' table into the 'Invoices' table? I REALLY want to avoid that if possible. Thanks

Hi all: I have a table,

Hello again and thanks, Fenton. Yeah, I forgot to include the clientID in my exampl, but do carry it over in reality. To be direct, I know this is a stupid way to do this. But I am modifying a solution that already exists and this was the best way I could see to create invoices from already existing job data that had never been invoiced. I don't know if it matters, but at any given time there should only be up to 12 records per client, so I don't think a loop should be too dangerous, but I am looking at your import idea. Thanks Kurt

Hey all: Is it possible to insert new records into table_A from inside a loop of a found set of table_B, using data from the found set of table_B to populate fields in table_A? Example: I want to loop through a found set (table_: of clients to whom invoices should be sent. For each distinct client I want to create records in an Invoices table (table_A) that contains the current invoice number and the IDs of all line items for that distinct client. So my Invoices table would look like: Inv_ID | InvNum | LI_ID 1 1001 719 2 1001 721 3 1001 725 4 1001 726 5 1002 122 6 1002 124 ... etc. But if I am looping the clients table in the script, and I need to shift to the Invoices table inside the loop, will I lose my position in the Clients table when I transfer back to that table for the next pass through the outer loop? I hope that makes sense? Thanks Kurt

Worked great. Thanks.

Thanks to you all for your replys. I am indeed copying from one layout before moving to, and pasting into, another, so that is covered. I didn't know about the 'Freeze Window' command but know I will be using it now! I normally use Set Field in my scripts but was under the impression that it wouldn't work in Find Mode. I don't know why I thought that but will certainly give it a go. Thanks Kurt

Hi all: I am using Copy() and Paste() script steps to copy data from one global field to another. For a short while the Paste step would paste whatever old data I had lying around on my clipboard, regardless of what field was Copied. Now it appears to be pasting nothing at all. I have debug statements placed to show the value inside the global to be copied, and it shows correct data, but how can I (if at all) debug/output what FM has placed on the clipboard with the Copy step while inside a script? Thanks Kurt

Well, as far as structure goes, check out the thread: 'Relationship Model' in this forum. Fenton may be able to shed some light on all this for you, and there's even examples to downlaod. As far as the typing a partial name goes, that feature is called 'Type Ahead' and FM7 does not include it, natively. There are, however, at least two plugins available to do it. I have them at home but am at work so can't give you more info. Try a Google search for 'Filemaker plugin type ahead' and see what you get. They both cost a bit of $ (around $20 if I recall), and one seems to be much better than the other (per the demo), but honestly I have not loaded either one yet. Been too busy. Kurt