keydash

Yes, thank you both. I tried both to see which would better meet my needs. Thank you Matthew for setting up Comments suggestion, this is exactly what I needed.

Hello All, This is probably one of those easy ones that I cannot get past. I have imported time data in the form of "01h:09m". I need to parse the two digit hours into one field and minutes into another. I can isolate the right three values, in this case "09m" but how do I remove the "m". Thanks Al

This is a late response. Thank you for your insight. You seem to have grasped exactly what I need. At this point I am unclear as to how I can designate the amount of gravel to be transferred to three rail cars from a single Truck. Making three deposits with the same LoadID and different RailCarID’s did not work as I had expected.

Yes, a single load can be divided among many rail cars. The rail cars are not reused, I was trying to indicate that new rail cars are continually cycled in. Oops! No, using 13.

I seem to have brain lock on this problem, I keep going round and round and can’t get a handle on it. Given: A dump truck is given a ticket number for each load of gravel. Each load will be deposited in up to six numbered rail cars (usually not reused). Each rail car will contain gravel from one to three dump trucks. Problem: Track which rail cars a truck load went into and the cubic yards from the truck. Track which trucks delivered to a rail car and the cubic yards of gravel in the rail car. Help! Thanks, Al

I am using FMServer 7 and have the same problem. The script step works correctly in stand alone, but breaks when used on the server. The Export file cannot be created in the specified folder. As a test, I set a script with a single step "Export Records". Still cannot create the Export file when running on the FMServer. I am open to suggestions. Al

The script runs prior to the file closing. It no longer functions reliably in FMP 7. I have stripped out all of the steps leaving only the basic "Save a Copy as" step. The file location is set as relative. Yet when I run it manually I get the following message: <

Same problem here. However I got a successful update when I bypassed the setup file and went straight to <FileMaker Developer 7 v3 Updater / Files / FileMakerDeveloper7v3Updater> Al

Could someone assist me in creating a script that does a loop with a create account step in it, that generates a random account name. Also an assist on attaching a privilege set. Thanks

Yes, this does show the divisions and the records within each. I failed to mentioned that it is the actual record count of each division that I need. And these record count numbers need to be placed within their appropriate

I have a summary problem: Each record belongs to one of 14 main areas. Each of these areas has 9 more subdivisions, and each of these is further subdivided into 7. Let's name one of the 14 as AI, the next divisions are named 1 through 9 and the last subdivisions are named A through G. I need to produce a summary of each of the respective combinations. Such as AI 1 A......AI 2 A......AI 3 A......AI 4 A......AI 5 A AI 1 B.....AI 2 B......AI 3 B......AI 4 A......AI 5 A......and so on. I can accomplish this by using a Find based on the 3 divisions, Status (CurrentFoundCount), and setField. However there are about 882 combinations. Surely there is a better way than doing 882 find scripts. As usual any and all help is appreciated. Al

Russ Thanks so much for both examples. These were exactly what I needed. Al

I am stumped over a probably simple calculation. How do I structure a formula to show if the Current Date is equal to or larger than the date of Modification plus 3 years? I have calculated the length of time since modification, but how do I add 3 years and compare to the current date? Thanks...