Darrell

I explained it to them after reading your post and they didn't like the figures so they have aggreed to just do the julian date plus the run number and resetting the run number. Can you explain the script step by step as how to do this? Thanks

I have developed a Dispatch program for a small Wheelchair van service. On each record an incident number or run number is assigned to that record. Right now the number goes in sequencel order. What they want is this the record number to reset to 0 at midnight everyday so they can start over with run number 1 unless a trip has been assigned to that day. Here is what I would like to do. Make the runnumber the Julian Date plus the next run number (example 256001...256002...etc). The only thing is they put in trips days ahead or even months (example 12/31/2005 for trip runnumber 365001) so I would need to match the Julain date to the date of service they put in plus the run number in sequencel number. But if the run number is reset everyday at midnight won't that wipe out the run number assigned to the wating call? Hopefully I explained this that everyone can understand.

I was just wondering if I have to have all the databases located under the filemaker server folder in order for them to run? I have limited space on the C drive but lots of space on the D drive. I tried to install Filemaker Server in the D drive but it installed on the C Drive. Can I tell Filemaker server to look for the databases in a folder on the D drive or Do I have to run them under the server folder in C? Thanks

I have tried this out and I have trouble with it. I have setup a test employee and looked at the password but when I try to sign in wiht th employee number and password, the pop up box says No employee matched your request. Can you advise what I am doing wrong here? Thanks

I have a database that I have developed for a small transport company. One of my portals shows runs that are pending waiting to be dispatched. I use a calc called IsEmpty=(Dispatch).It shows all runs that are pending no mater what date the run is assigned to. What I need is to only show runs for the current date not tommorow or next week just for todays date, Hope I haven't confused anyone. How can I do this? Thanks in advance.

I will look around for the Networking problem, I don't think it will be to much to figure out. I have attached a screen shot of the main page and you will see that I added a protal to show a list of all runs but I ran into problem. I use the relationship that was used to showing avaliable units (haven't put that on the main page yet but will) anyway when a run completes or is cancelled it is omited. As you can see by the Status field it shows the cancelled run, I don't want any of the completed runs to show in this portal or cancelled runs. Basiclly I just wnat pending runs or current runs that are dispatched to show. How would I go about this? Thanks main.pdf

Because sometimes there are multipal pcikups going to the same destination. Aslo in the mornng when a driver comes in there is a printout of a list of the days current calls that the dispatcher wnats this driver to take. Yea I did and I creataed a units file but I made the relationship with itself in the dispacth file, amybe I should make it within the units file. If Unit 317 is assigned to 1 call and that unit is dispatched it does disappear from the availability list. Oh yes please, you don't know how much this is helping me. I am getting more and more cofident in figuring out little things that improve the program. I do think I may run into one more problem so I will chew on tyour ear and see what you think. This program is goinig to run on Filemaker server 6 with 5 clients hitting the database at one time. What I am concerened about is this. Say one user dispatches a call, another user is looking at the wating list Now will the record update on that second useres screen to show the call has been dispatched? If it does show up and the second user goes into the record that the first user was looking at to put the unit on scene because the first user became busy or went to a different record, will the second user's screen show the dispatch time on there screen? I understand that the first user has to be out of the record because there cannot be 2 users in the same record. I hope I haven't confused you to much. Thanks once again for the download.

I sent the test DB back showing what happens to the available untis field. You will see that I assigned unit 317 to 3 different calls before dispatching one of the calls to unit 317. Unit 371 is still showing up as available even though they have been dispatched on another call. What my user wants is the list of waiting calls and assigns that unit to the next call even though the first call is not done. Hey thanks for the time fields script, they are better then mine. test.zip

Ran into a problem. My user assigns a single unit to a more then one run so. IN the avalibale field the unit is show up twice. How do I work around that? I have attached a screen shot. list.pdf

First of all I want to thank you Moonshadow for all the help that has been provided in getting this database up and running. I have one other thing I have run into. In the main page that all the users will be viewing I want to show all available Units that are not assigned to a call. A unit gets assigned to a call when the user clciks on the time field that says dispatch and assignes a unit. Do I need two fields One to show the unit and the other to show available or assigned? Thanks for the help in advance. I have attached tha screen shot of the main screen. main.pdf

First of all I want to thank Moonshadow for all the help that has been provided in getting this database up and running. I am devoleping a Dispatch database for a small ambulette company. What I want to accomplish is this. In the main page that all the users will be viewing I want to show all available Units that are not assigned to a call. A unit gets assigned to a call when the user clciks on the time field that says dispatch and assignes a unit. Do I need two fields One to show the unit and the other to show available or assigned? Thanks for the help in advance. I have attached tha screen shot of the main screen. main.pdf

First of all I want to thank Moonshadow for aal the help that has been provided in getting this databse up and running I have a couple of other smal issues that I need assistance on. I am devoleping a Dispatch database for a small ambulette company. I have a field that is a time field to cancel a call, When they click on the box to timestamp the field it omits the call but what I want to do is setup a Message script box. The box will say "Are you sure you want to cancel this call?" The user will have the option as "yes" continue on with he rest of the script to omit the record or "no" go back to the page you were on. What is each step to do this? Thanks for the help.

Yes I guess I did, very tired on this end trying to figure this out. Let me try again. I have fields that I time stamp (Dispatch,Enroute,OnScene, Departed, Arrival) I have setup buttons for each field that all I do is click on it and it time stamps the current time. What I also want is a Status field to show what is happening (I.E. When I click on the Dispatch button and timestamp the Dispatch Field I want to the status Field to show Dispatch Same thing for enroute, Onscene...etc. Hope that explains it better. Thanks once again for the help as the other item works now.

Thanks for the reply I am looking it right now and I know it will work. Now can I bother you for one more thing. I have a field called Status and I use the if calc (If(inservice = "","Pending","Completed") inservice is a time field that when I click on a button it closes out the call or when I create a new call it puts Pending in the Status field. I have other time fields like dispatch, enroute, onscene, transport, arrival. What I want to do is show (in the status field) what the unit is doing after the user clicks on one of the time fields. I think I have to use if then calcs but not sure. Can you show me an example? Thanks so much

I am still a liitle confused yet here. I will show the database I have; I have the main database and In it I made a field called Key, I made that file a constant with the number 1. I made the other databse called driver and made the following fields Key: made that a constant number 1 then the following fields with drop down list of the drivers name Unit 1 driver Unit 2 driver Unit 3 driver Unit 4 driver Unit 5 driver I based the relaiontship on each key field So would I recreate a relationship. And do the following like you have shown or something total different? Select File > Define Relationships. Select Dispatch Unit# in the left pane and Drivers Unit# in the right. Place your Drivers::DriverName field directly on the Dispatch layout next to the Dispatch Unit #. If it is necessary to store the Drivers Name along with the Unit# in your Dispatch table (sometimes necessary for history tracking if you change a unit's driver), then create a field in Dispatch for the name also. On this field, use Auto-Enter by Lookup Drivers::Name. And then just place this new DriverName field on your Dispatch form. I would tend to want to use the second method - or have an additional file of the Drivers with unique IDs, which would never change. Then assign the DriverID to each Unit. In this way, you can track which specific driver was handling each incident back through time without adding a redundant DriverName field in Dispatch, and yes there is only one driver per unit sao I think that makes it easyer to figure out. Driver.zip