wolfe

Bump...I'd like an answer to this one myself!

Working on a work schedule. Using FM8A I've got this to work the way I want, but the cost in fields seems a bit much so I was hoping someone could look at what I have and see if there's an easier way. I've seen it time and time again so to avoid misunderstandings due to my ignorance, I'll just attach the file I'm working on so you can get your hands on the issue. You will notice all the fields used to count shift coverages. I'm wondering if the same result can be achieved using fewer fields. You will also notice the summary and calculation fields only work as intended when the last record in the set is active. I'm not that concerned about that because I plan on removing all menu commands and keeping the user on the last record once a new schedule is created. (Unless there's an easier way!) Feel free to "talk down" to me since I am not very experienced, ill trained, and a little slow on the pick up! Days.zip

Not exactly what I wanted to hear, but thanks for the reply Ender.

Hey FM addicts, I'm tossing around the idea of building a forum style solution for my work. Was wondering if anyone out there had an idea where I might find a good template? I've looked around the FM site and in here, but haven't seen anything. I'm wanting something to run from FM server 8 on a private business network with about 12 computers or so.

Try this old file to get you started. I used a variation of this to create autoenter serials that begin anew at the beginning of each year. SerCat.zip

Okay, I've spent several hours trying to figure this thing out. I don't get it. The "Jan1" field works fine, but I can't reproduce it. I even tried creating a new file and using the same field names, copy and paste didn't work and duplicating didn't work. I even tried to copy and paste from the layout and then rename the copied field....Nada!

Hold the presses! Now it seems the only field to work is Jan1. It appears Jan2, Jan3, etc... do not work. All the options are identical, I've even tried duplication and copy n paste, but I can't reproduce the working field, any ideas???

Well I guess I just had to step away from the tail pipe of my car for a while??? I think I've solved this by not even addressing the fact that the day fields, "Jan1", "Jan2" etc... fields are repeating fields. I tried this and the calc works with all the occurances in the repeating field; If ( Jan1 = GetRepetition ( Codes; 1); TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 2); TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 3); TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 3) ; TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 4) ; TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 5) ; TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 6) ; TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 7) ; TextColor ( Jan1 ; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 8) ; TextColor ( Jan1; RGB ( 0; 0; 255) ); If ( Jan1 = GetRepetition ( Codes; 9) ; TextColor ( Jan1; RGB ( 0; 0; 255) ); TextColor ( Jan1; RGB ( 255; 0; 0) ))))))))))) I did look at the information posted and appreciate the responses you guys gave. Using the above calc will allow me to address my colored text for any number of repetitions. Ender, you had a very good point and since the above calc works (so far) seamlessly, I'm changing the repeating fields to 50 or so to allow for expansion. I will still only show 20, but this way if expansion is needed, it won't be a problem Thanks for the input!!!

You guys always seem to come through when my brain starts to freeze up like my computer so here goes. I am working on a simple (?) work schedule for up to 20 employees. I have a file with 13 layouts, 1 admin and 12 months to show the calendar months. I've created 366 fields showing the day of the month, ( M, T, W, T, F, S, S ) which autopopulate after the first day of the year is chosen. I have a script to add Feb.29th for leap years and recalculate the days. So far so good. Next I want to create a display of work shifts for my 20 employees. What I had in mind is a repeating field named "Jan1" with 20 reps. This way I set this field below the "Day1of366" field on the layout and I can set different work shifts and off days for each of the twenty employees using the repeating field. Still so far so good. The problem is greed...I want to show schedule shortages by turning the text red when a person uses a sick day or takes overtime or for some unforseen reason takes off work. I also want the text to be blue when the person takes off for a scheduled event, like their regular off days or a scheduled vacation, so anything that is listed in the "codes" field will show either black or blue, any other entry will be red. What I have so far is on the admin layout I have a repeating field that stores the schedule "codes", like 1 for first shift, 2 for second P for a personal day and such and soforth. This is a repeating field My autoenter calc is a "get repetition" calculation which looks something like this, If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 1); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 2); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 3); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 4); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 5); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 6); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 7); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 8); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 255) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 9); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 255) ); TextColor ( GetRepetition ( Jan1; 1); RGB ( 255; 0; 0)))))))))) This works fine for the first repetition, but how in the world do I address the remaining 19 reps?

I maintain a rather large db for my police department. We run 12 machines all with XP w/sp2. Our server is a desktop some guy put a mirror drive into, I don't know much about computer hardware so all I can tell you about it is that it has a large hard drive and 2 Ghz of ram and the processor is a 2.4 Ghz. I'm not sure what kind of hard drive it has, but it seems I read something a while back on the forums about having the right hard drive??? (I looked but couldn't find the post) Our problem is that when FMServer 8 performs a scheduled backup, it slows the entire network down where users end up getting the dreded coffee cup icon. As I stated previously, this is a police database and we are open 24-7 so it's hard to pick a convinient time to do this. Oh, and all clients run FM Pro8 with updates! My question is, does anyone have any advise on hardware (server end) which would help speed up or lessen the effect on clients during back up times? Thanks!

I was getting the same error, it was the firewall. Did you shut the wirewall off or go into the settings and allow the FM program? I've ran into firewall issues before and found that simply disabling the firewall does not always prevent the firewall from stopping connections through a network. If you haven't already tried it, go into the firewall settings and add FM to your application list.

Wow, now don't I feel like an idiot! I guess I haven't been using my brain enough lately. Gonna have to knock the dust off a little more often I think. lol Thanks guys!!!!

My thought was to keep my question short to avoid clouding what I thought was a simple question. Maybe I need to add a little more detail. It's been said I'm not always clear as glass. Here's my problem; I have a database which has a "location" field used to record the loction of an event. This is a regular edit box indexed text field. The problem I have is that we have about eight different people entering data into the field and if someone uses the "enter indexed value" (CTL + I) the index is full of the same locations spelled differently or abbreviated. To describe an intersection like "Main Street and Market Street" I see entries like "Main & Market" "Main St & Market St" and numerous other variations. Now what I want to do is create a drop down list with using the contents of the field. The problem with this is all the garbage and misspellings and different variations so I want to "clean" the index list up before I impliment the field as a drop down list. To do this, I was thinking I would need to either print the index list or be able to gather the list into a field where I can print it. Once printed, I can assign someone to modify the location field in all records so they have uniform descriptions for the locations listed.

Maybe someone else has had a need for this before but I can't find it anywhere. I'm needing to either print an index list from an indexed field (or) be able to import the contents from the indexed field from all records into a global field. Any ideas?

Additional diagnosis....... It seems that four different fields were affected by whatever caused this. The first was a standard text field, the second was a time field, the third was a text field with a drop down list, and the forth was a calculation "audit" field. I'm thinking this may have been some type of power surge or electrical problem but the system affected is on a UPS. Does this help shed any light on the problem?: HEEEEEELP!

I didn't believe it either! I made a db solution with several tables fields and all the standard stuff. One of the users recently complained that he had typed information into a standard text field, when he returned to the field later, the text was gone. "It just ate it" he said. lmao....sure it did! Well, I had to eat my own words, we run a spy program which takes screen shots every 15 seconds. I looked and sure enough he entered what he was suppose to, he left the record and created a new one and entered more information then closed the db went surfing on the web for about 45 minutes and when he returned, the text he entered in the text field was gone on one record but still there on the record he created after it!!! This db has aduit tracking so I checked the aduit field to see what was up. The record showed several changes correctly, but did not show any change made to the text field with the missing data. Not even that he changed it from null to whatever. This db is rather extensive, it has well over 50 tables and upwards of 500 fields and took forever to build. If your only answer is going to be rebuild the db, just save your breath. Drive over here and shoot me in the head and get it overwith!!! I'm running a network of ten computers for a small police department. All computers run Windows XP Corp. I'm running FMServer7 on the server and FMPro7 on all the clients. I used FMDeveloper 7 to build the db. Any ideas?

Okay

I have about 20 layouts using 10 tables with an average of 20 fields per table. What I'm wanting is the ability to go to a single layout, (search layout) and be able to perform a search for information from one or two fields. I have about eight different name fields, I have caller's name, victim's name, defendant's name and so on. I'm thinking I can make a calculation field that auto enters all the eight field contents into one field which I can search. My second field would be a more generic field and contain comment fields, narrative fields, and just about anything else with the exception of dates and times. The second field would operate the same but deal with much more information. I'm thinking we do much more searches for names than anything else, so limiting the name search will keep it more streamline and faster. (hoping) Now that I've bored you to tears with my rambling, here's the jucy part. Dealing with the name search, I want to be able to perform a find and from the find screen, go directly to the found name on the layout the name is located on, weather on a related table or not. Then be able to go to the next occurance of the found name on what ever layout it happens to be found on. And so on and so on. Any takers?

I've tested this thing every way possible to get a SSN into the text field and can't do it. I think this is fantastic! Very Clever! Tnx

Terence.......your a geneus! This works beautifully! You need to build one of those example files that have your name and contact info on this file and replace the one in this thread. This thing could be used to filter other numbers from generic text fields as well. Seems like it's too simple, but it sure gets the job done. What else can be said except FANTASTIC JOB!! Thank you VERY much! Wolfe

Tnx to all for your assistance. Murphy, I downloaded your file and tested a little. It works perfectly to catch a SSN but it sees other numbers as SSNs which aren't. For instance, if you enter an employee number 333 and type some random text and then have to enter the employee number again 333 type more text and enter the employee number again 333, this registers as a SSN. I haven't had a lot of time to play with the file, but soon as I do, I will post here so others might use the info. Tnx again to all responders!

Tnx for the posts LaRetta and Transpower, but I am working with FMPro. I am fairly new to this stuff and went with the less expensive FMPro over the Developer. Anywayzzz, I'm thinking of trying to work around the entire number issue like this. When someone types a "social security number" into a text field, they tend to abbreviate the qualifier with "SSN", "SOC" or "SS#". I'm thinking I will just look for these qualifiers in the text and act from there. It's not fool proof, but at least most of my users can't spell Microsoft. PS That's the reason they abbreviate "Social Security Number"! PSS I will still check back here and see if anyone does come up with anything that I can work with....I have until January 1st! Wolfe

I hate to drag this dead mouse back in the house but this simply isn't going to work. The text field I'm needing to filter is used pretty much as a comments type field and holds all kinds of information from phone numbers to employee numbers. Certain combinations of employee numbers are looking like social security numbers even if they aren't connected and seperated by several lines of text. Also.... the two dash method is being killed by these people who refuse to use something other than a dash to enter a phone number with an area code!!! So, I've got a text field which holds just about anything EXCEPT a social security number and I need the ability to prevent the user from leaving the entry if he puts a SSN in it. There must be a way to do this. I told my boss there was! Please HELP!!!!

I am working on a database to keep track of car maintenance for a fleet of 20 cars. If a car requires being towed in, I have to use a rotating list of three different wrecker services. Currently my dispatcher has to look on the current wrecker list to see which service was used last. Then he knows to use the next wrecker service on the list. Say I have three wrecker services, Service One, Service Two, and Service Three. I need to be able to create an unlimited number of records regarding car maintenance and if I need a wrecker for one of my cars, I want the dispatcher to be able to look at the screen and see the next service to be used automatically displayed.

Tnx Queue!