Foxzpuffin

I have been writing a file to run my office and need help with a routine to count down the number of authorized session for a given patient. I have had no trouble assigning a value of 1 to each session and then subtracting that from the number of sessions allowed. The problem arises when the allowed sessions are used up and a new authorization is granted for the same patient. I have tried linking the calculations to a serial number I have given the authorization grant but no matter how I do the calculations the prior sessions end up subtracting from the new set, whereas the process has to start over. I do not want to erase the old data as it can be important to retrieve at times. I know I am close to the answer but can’t quite get it. Can anyone point me in a direction?

The time start field is a field in which the time start is entered. Then the appointment title is chosen, let us say, Indiv. Ther. w Med One can see these as I note in my first post by selecting the 5th, tomorrow in the initial screen, the daily layout, then one of the people. This brings up the edit appointment mini screen. If Indiv. Ther. w Med is chosen the field next to it is a related field, the default time from the psych appointments types table. It is in that table, reached from the daily layout via the green text at the bottom. The fudge field is immediately below the related default time field in the previously mentioned edit appointments mini screen. It accepts time in the standard filemaker format, or at least it should. That part of the calculation seems to work. If I add time to that field it works fine. If I subract time it also works. But the calculation seems to ignore the related field. As I mentioned in the post which includes the file, in the original of this file which has about a thousand entries and the full names of the patients, and in that file several of the calculations work, but three do not. I don't know why changing the names of the patients effected the calculation at all.

The second file is not needed. Hit cancel. The CC Cal file is comercial but the calculation is mine, the file originally came with the field ApptTimeEnd as a simple time field allowing an ending time to be entered and I tried to link the end time to the field ApptTitle which is the one linked to the field Psych Appointment Titles in the table of the same name. The calculation is ApptTimeStart + Psych Appointment Titles::Default Appointment Time + Fudge and is the calculation associated with the field ApptTimeEnd. It just occured to me that the CCCalendar file makes use of a field ApptTimeEndCalc which is a calc making use of the field ApptTimeEnd depending if it is empty. I wonder if that is getting in the way?

Well, no I'm really lost. I deleted all but tomorrow's appointments (12-5-05) and changed the full names of the people (my patients) to initials only. After I did that all the calculations didn't work any more. Initially only 3 of them didn't. The End Time field is in the table CCCalAppts and is related to the table Psych Appointment Titles via the field Psych Appointment Titles. Default time provides the length of the appointment.

I am having weird results in what should be a simple calculation. I have a start time field which is a simple edit box time field. The end time field is a calculation the result of start time + default appointment time (a related time field based on the name of the appointment in another table) + adjust time, a field to allow for appointments which are different from the default. Some records calculate properly and some do not. It seems independent of the appointment selected, for instance tomorrow I have a 3 to 3:45 appointment which properly calculates. But the 4 to 4:45 appointment calculates as 4 to 5. Some 20 minute appointments calculate as an hour also. A 2.5 hour long appointment calculates as 0 time, end time same as start. I have entered all the default appointment times as 00:45 for 45 minutes or 02:30 for the 2 and a half hour appointment and so on. Helllllp please?

I am attempting to use an auto enter replace existing values calculation to make entering data into a time field more efficient. I am trying to be able to enter numbers only without the and without am or pm in military time. I can enter in military time but have to use to and I am trying to skip that. So, I have develolped the following calculation but it doesn't seem to return the correct results. Can anyone find my error? Case ( ApptTimeStart Calc ≥ 959 and ApptTimeStart Calc < 1200 ; Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 2) & ":" & Right(Digits; 2) & " am" ; ApptTimeStart Calc ≥ 1200 and ApptTimeStart Calc ≤ 1259 ; Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 2) & ":" & Right(Digits; 2) & " pm" ; ApptTimeStart Calc ≥ 1300; Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 2) & ":" & Right(Digits; 2) & " pm" ;Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 1) & ":" & Right(Digits; 2) & " am")) Paul

I've had no troubel with either pasting or adding de novo, but an important point is that the field and for that matter anything on the tab must be entirely contained on the tab or it will spill over and mess up the other tab(s.) However, a problem I am having is being able to go to a particular tab on a layout. There seems to be no way to go to a tab other than the tab that was last accessed. How can one script to go to a particular tab so that the fields on that tab can be utilized in reports?

I am a psychiatrist and have written a file to manage my office. I have nearly brought my office management project to the point where I can use and depend on it except that a couple decisions I have made resulted in a problem I have not been able to solve. In short I have split the transactions into current transactions and previous (prior months) in order to make picking up the prior balance easier. However, this has complicated a script which runs through all the patients (a loop) and prints only those statements for patients with a positive balance. The script does strange things when it does not find a record in the current transactions table, specifically it winds up at the very last record (about #100) even though there are some in between that have positive balances and some between that have 0 balance but have transaction records, and I have been unable to write anything that successfully gets around this. I have tried using the Get (found set) calculation to go to the next record or to loop back (and essentially do the same thing) without success. My efforts at fixing the problem either result in no apparent change or in a endless loop which can only be ended by an escape command or dumps me out to one of the layouts exiting the script but does not go to the next record where there is in fact a record. Any advice?

I am trying to develop my own billing software and a script I have written checks to see if a trasaction already exists for a given person on a given day and if found gives a custom message allowing the user to create a second transaction or more commonly back out and not do so. However, most of the time no transaction will be found and the standard message that no records match is displayed. Pressing continue then properly creates the transaction. However, I am trying to avoid seeing this message if no record exists and have not been able to do so. Is there a way?? Thanks. Paul

I am working on an office management file for myself (and maybe others) and find that I am gathering too many buttons to launch scripts. Some of the scripts are somewhat related. Some time ago I read about using a pull down menu to do this but I can not find the information again. Anyone have any advise or directions either on how to do it or to the information. TIA

I have been unable to find the post aluded to by dykstrl. I need help to find the help. FileMaker Version: 7 Platform: Mac OS X Panther