pspafford

Hey kids, I've been playing around with a two-file system: one multi-table data file, and one interface file. Putting all scripts, layouts and value lists in the interface file is very easy; the final piece is the calc fields. While this is also easy enough, a problem arises when you want to show a calc field in a list or portal view. For example, when viewing a single invoice by way of the interface file, the total can be shown with a Sum ( lineItem::amount ) calc field. However, if you're looking at a list or portal view of invoices, how do you show the total for each invoice? The answer is probably "The data file will still need some calcs". I was just wondering if anyone had come up with anything brilliant. Thanks, Paul FileMaker Version: Dev 7 Platform: Windows XP

Got it! Someone on FMWebtalk noticed that there was no hyphen in front of "Token.1" in my generated URL. That's one of those silly little typos that just deserves a good slap. Thanks, Paul

Hey Garry, I just tried it -- no joy: I don't even get the slash. Thanks, Paul

Hey everyone, I'm using CDML tokens for the first time. An initial page has the employee entering the date, and selecting an href link of their name. That link has an onClick event that uses JavaScript to go to the following link: http://127.0.0.1:591/FMPro?-DB=gTime.fp5&-Format=timeEnter.html&-Token.2=5&Token.1=04/14/2004&-View The format file is where they enter the details of their timesheet. There are fields in the format file like this: <input type="text" name="date" value=[FMP-CurrentToken: 1] /> <input type="text" name="staffId" value=[FMP-CurrentToken: 2] /> Token.2 goes to staffId all okay, but Token.1 only sends a single slash character("/") to date. I had thought the slashes in the date might be the problem, but even when I changed the date to a single number ("4"), I had the same problem. Can you offer any advice? Thanks, Paul FileMaker Version: Dev 6 Platform: Windows 95/98

I finally remembered the "trick", and thought I'd post it here in case anyone else has this problem. Here's what you do: 1. Turn off the FMS service. 2. On the FMS computer, use a regular copy of FMP to open the file. 3. Set up the IWP. 4. Close FMP. 5. Restart the FMS service. 6. Open the file on your FMU computer.

Hey kids, FMServer5.0 on Win2000 FMU5.0 on NT There's some little trick to this, and I can't remember it for the life of me. I set up IWP on the FMU box, opened the file (by way of FMS), and then did the Web companion settings for the file in File Sharing. I had to shut down FMU, and FMS to poke at the files again. When I restarted everything, I had to reset the file settings for IWP. How do I get it to remember how to share the file? Thanks, Paul

Hey Fenton, It sounds like no matter what I do, I'll be driving out to my clients office. I think she will have all the functionality she wants if I just enable the print dialogs. But I'll keep that snippet of AppleScript in my archives for future use. One of these days I'll learn that stuff. Thanks, Paul

Okay, I'm a TOTAL Applescript virgin ... be gentle. I have a client who wants to be able to switch between printing to her default printer, and printing to a pdf. The print dialog is disabled in all of her print scripts On the PC, I can change FM's default printer by changing it in the Print Setup dialog. I've tried to do this in Panther, but the pdf-writer isn't available as a selection. Is there an applescript I could send her that would toggle between the two, or do I have to go out to her office and enable all of the print dialogs? Thanks for any help you can provide. Paul Version: v6.x Platform: Mac OS X Panther

Did you see the character qualifier for calculations? No more counting if you need quotations in a calc field. just put a backslash in front of it. e.g. "She said, "" & textField & "", and left the room." If you've ever generated html from field values, that's worth the price of admission. Paul

Hey Bruce, With the SendEvent script step, you can send DOS commands. Create a plain-text file called toDo.txt. Move it to the same directory as your solution. Then use this SendEvent: cmd /c ren toDo.txt toDo.DOC The "cmd /c" starts the command line interpreter. "ren" is the command to rename. "toDo.txt" is the original filename and "toDo.DOC" is what you want to rename it to. If you will be doing this in a directory other than the one your solution is in, you will have to specify paths for the filenames, using quotes. Something like: cmd /c ren "c:windowsdesktoptoDo.txt" "c:windowsdesktoptoDo.DOC" ... and of course, you can use calculations to build this. Do a search in the help file for "operators" to see how to treat backslashes. Paul

Never mind everyone. I figured it out. I parsed ValueListItems() into 26 globals. Thanks, Paul

That won't work, unfortunately. They need the ability to type over the names of any of these services (e.g. to change "Consulting" to "Professional services", when they decide that that would "sound better" even though it's the same service), and there are also other fields in each record for the service, that we will need to reference. The table will always show all 26 services. Thanks, Vaughan. Paul

I'm developing a solution with a one-record viewer file. There is a twenty-six-record file called Service.fp5 which lists 26 different categories, with serial numbers 1 through 26. These services need to be field labels in the viewer file. Is there any way that I can do this without setting up 26 different relationships? I tried calc fields of GetRepetition(Service__constant1::serviceName, 1) all the way up to 26, but that only works on repeating fields, not related fields. The client wants a static multi-columned table to be shown at the bottom of several layouts, that uses these labels, so I can't do it in a related file or a portal. I would really like to have the labels dynamic because the clients are known to change their mind frequently about semantics; they need to be able to change the labels themselves. Any ideas? Thanks. Paul

Hey kids, FMServer 5.0 on Windows NT. I haven't done anything in the FMServer Console in months. Just tried to now, and I can't access anything. The console comes up, but when I click on one of the icons (e.g. Database hosting), nothing happens. Any ideas? Thanks, Paul

Umm ... let's see. The "tower" is about 6 inches tall by 14 inches wide; it says Power Macintosh 7600/132 on the front; beside the floppy drive, it says PowerPC; and it's running OS 8.6 That probably sounds like I'm trying to be a smart-arse, but I swear, it's just plain old naked ignorance. Thanks. I'll check out the Apple site. Paul