Wiz Bang Computers

Has anyone heard if an update will be needed to accomodiate the changes to Daylight Savings Time that are coming next month? I know MS has updates coming for XP and Server 20003, but I was woundering if FM Server 8 Advanced needs an update also. Thanks, Scott

I have tried FM Advanced 8 with VISTA and things worked fine until in layout mode and then the screen goes black when ever you want to move anything.

In case any of you were scratching your heads trying to figure this out, with the help of FM Tech Support I think I have solved the issue. Even though I did not have any validation rules set in the table FM Tech suggested that I check in the script for COMMIT RECORD the box for SKIP VALIDATION RULES. I did this and so far I have not seen the issue come back. Hope this helps others. Scott

I am not sure if this is an IWP or a scripting issue that I am having. I have a form that contains a script that is supposed to automatically put in a date to be processed. Hit and miss I am having CSR's who fill out the form and submit it and the screen goes blank on IWP and the date does not get entered into the record. I have checked my log file and not found any IWP errors associated with this table. I did find an error code 500 at the time near one of these records. This code is "date does not meet validation entry options". My problem is that this table has no validation set for the date or any other item in the table. I have two scripts running to set the date, they are below. Has anyone heard of this happening or can you see something in my script that may be causing this. I have not been able to track it down to a specific time or person, and like I said it does not happen all the time. Thanks, Scott SCRIPT [310] PAYMENT DATE IF cDAY OF WEEK = 2 PERFORM SCIRPT ["[311] PAYMENT DATE M-W" ELSE IF cDAY OF WEEK = 3 PERFORM SCIRPT ["[311] PAYMENT DATE M-W" ELSE IF cDAY OF WEEK = 4 PERFORM SCIRPT ["[311] PAYMENT DATE M-W" #Thursday ELSE IF cDAY OF WEEK = 5 PERFORM SCIRPT ["[312] PAYMENT DATE TH" #Friday ELSE IF cDAY OF WEEK = 6 PERFORM SCIRPT ["[313] PAYMENT DATE F" #Saturday ELSE IF cDAY OF WEEK = 7 PERFORM SCIRPT ["[314] PAYMENT DATE sa" END IF SCRIPT [311] PAYMENT DATE M-W #Monday, Tuesday or Wednesday IF CREATION TIEM < 54000 SET FIELD PAYMENT DATE; CREATION DATE + 1 COMMIT RECORDS/REQUESTS [NO DIALOG] GO TO LAYOUT CSR PAYMENT VALIDATION ELSE IF CREATION TIEM < 54000 SET FIELD PAYMENT DATE; CREATION DATE + 2 COMMIT RECORDS/REQUESTS [NO DIALOG] GO TO LAYOUT CSR PAYMENT VALIDATION END IF

For organizing the claims I was wanting to use the Julian Date and a sequential number for the claim submitted that day. We are just starting so we have no claims form prior millimumns.

I have a database that I am keeping track on contributions to various programs. Multiple people can contribute to a program. I want a report that will list the debits and credits and the balance by contributor for the program. I have a set of entry fields that contain: DATE CONTRIBUTOR MEMO DEBIT CREDIT Then I have Summary fields for DEBIT and Credit. Next I have a calculation field BALANCE which is sDEBIT-sCREDIT. Finally there is a summary field for BALANCE. I set up GetSummary(sDEBIT;CONTRIBUTOR) and similar for CREDIT and BALANCE. I have a column report grouping by CONTRIBUTOR and the gsBALANCE field listed but it shows the total balance for the program not the balance by CONTRIBUTOR. What am I doing wrong? Thanks, Scott

I have a table to hold claim data. Each claim I want to assign a claim number to. I would like it to be the Julian Date plus a sequential number. Can FileMaker calculate the julian date? If it can not do the specific julian date is there a date function that gives the day of the year. If that can be done I can create a julian date. Thanks, Scott

I want to set up a list of each person who modifies a record and the timestamp that they modified the record. I currently have a field that show the account name and one that shows the timestamp of the modification the last time it was modified but I want a historical display. If I can also have the script record what was modified that would be great. Can I get some direction on how to set this up? Thanks, Scott

The field contents are set for text

I have imported data into my database though XML and the data shows on client but when I go to IWP the data does not show in the database. I have IWP turned on for data sharing. Does anyone know why the data imported by XML would not be visable though IWP but is on client? Thanks, Scott

Thank you all for your help Scott

I do not see how to delete the body section. Could someone please advise how best to do this? Thanks, Scott

I am trying to create a column/list report that summarized data by department. The problem is report has spaces where the body is for each record under the department. I have shrunk the body down all the way, but when you have 450 records the space is still large. Is there a way to build the report without the body so I just have the summary data showing? Thanks, Scott

Is there a way that I can script to have a user interface to enter the find parmaters. For example, say I want to find data entered between two dates, but I want to user to set the dates each time they run the script. Is there a way to have say a box pops up that the user can enter the start date (START), and click enter and the another box pops up and the user enters the end date (END) and then the scripts finds START..END? I come from using MS Access and could do this in that program, looking to see if there is a similar function here? Thanks, Scott

Raz, Thanks, this did the trick! Scott

If this is in the wrong place I appolgize. I am trying to set up a calculated field using the CASE fucntion. My goal is to automate the calculation of the payment date. Payments received after 3pm go two business days out, prior to 3pm they go 1 business day. I am running into problems with the issue of the weekend. Here is what I tried to put together, but it is not working: Case ( cDAY OF WEEK = "7" and CREATION TIME ≤ "3:00:00 PM" ; CREATION DATE + 3; cPAYMENT DATE = "7" and CREATION TIME ≥ "3:00:00 PM";CREATION DATE + 3) or Case ( cDAY OF WEEK = "2" or "3" or "4" and CREATION TIME ≤ "3:00:00 PM" ;CREATION DATE + 1; cDAY OF WEEK = "1" or "2" or "3" and CREATION TIME ≥ "3:00:00 PM";CREATION DATE + 2) or Case ( cDAY OF WEEK = "4" and CREATION TIME ≤ "3:00:00 PM" ;CREATION DATE + 1; cDAY OF WEEK = "4" and CREATION TIME ≥ "3:00:00 PM";CREATION DATE + 4) or Case ( cDAY OF WEEK = "5" and CREATION TIME ≤ "3:00:00 PM" ;CREATION DATE + 3; cDAY OF WEEK = "5" and CREATION TIME ≥ "3:00:00 PM";CREATION DATE + 4) Can anyone provide some guideance? Thank you, Scott

Is there a way to disable the security management for a database? I am running FileMaker Server 8 and want to disable security managment for a database that people will access though IWP. As a back up, my web guy has our intranet written in php, can he script to have when a link is clicked on the intranet the person go to iwp and automatically be loged in as guest? Yes, I know this is crazy but the boss wants to know. Scott

I have two databases linked on account number. Table 1 stores payments and Table 2 stores address information for the customer. I am having a problem with some of the fields being deleted in Table 2 when a payment record is entered into Table 1. Some Table 2 data should appear on Table 1 once the record is committed though iwp, but I am only getting the customers name to appear and the rest of the data is deleted that I am wanting to appear on the form for Table 1. Any ideas why this is happending? Thanks, Scott

I have a need to have a shared access account in a FileMaker database. Our IT department does not want to set up a shared ID and password in Active Directory because if violates established policy. Since the policy says no sharing of pw I also can not set up a FM account that would have a shared password either. One idea we had was using a smart card reader. The card would contain the ID and PW so no one would know it and the department manager would control the card and hand it out when needed. Is there a way with Server 8 that it can authenticate to the card reader that is hooked up on the machine the person is on? Along similar lines, has anyone tried using bio-metrics to authenticate yet? Thanks for the Help, Scott

My IT Department was too cheap to buy Pro Advanced, I just have pro, no debugger.

I am not sure if this belongs here or in scripting, please advise if it should be moved. I am using Active Directory to externally authenticate. I have two employees in the same Active Directory group that one is able to successfully run a script allowed for the group and one the script does somthing completely different then written. The group is set to allow all executiable scripts. Has anyone run into a situation like this before and do you have any other suggestions? Thanks, Scott

I just got a book "FileMaker 8 Funcations and Scripts" and it show the SET FIELD function for scripts in a find. I have tried using this with ScriptWriter but have not been able to duplicate the format. If there a way I can write a script free hand in FM or do I have to use the script writer? When using the script writer I specify the field but can not include the action to take. I go to calculations and can not get it to do what I want there because it is wanting () and the book shows brackets [] around the set. I am trying to find items with a date and time. This is an example of what I am trying to do #Find payments entered prior to 15:00 hrs on the current day with a payment date of the next day ENTER FIND MODE SET FIELD [CURRENT DATE;">// 15:00:**"] SET FIELD [PAYMENT DATE;"=//+1"] PERFORM FIND ENTER BROWSE MODE ENTER PREVIEW MODE [PAUSE] Any help would be greatly appreciated Scott

We have figured out the issue and so I am posting the solution for you all. Basically people were timed out of IWP and the Server and still trying to submit a record. When they did this it caused error 13, then as others who were logged in submitted after error 13 the IWP publisher got confused with all the submission and shut down the publisher. We have increased the time out setting and instucted staff using IWP to log out if they need to go do somthing else and then come back to IWP, do not leave it up and running unless they are working the items. Scott

We have been getting error code 20603 every day at about the same time of day. When this happens IWP publisher looses communication with the server. Reseting the IWP publisher from the console does not work. Most of the time I can not communite with the server though the admin console also. I have not been able to find anything that gives what this error code means. Does anyone know what the error code means and/or what is happending to cause this. I am suspecting that the time on the server is off by 13 hours because this is happening about 13 hours before the scheduled back-up time of the server. My IT Support office has not been able to track down the issue, but they set up the server and are a hour behind us, so it there is a 12 hrs difference then the 13 is logical. Any help you can offer would be greatly appreciated. Scott

Could I please ask for some help with a script issue. I have a DB to hold copies of records like liability insurnace certificates for clients. These need to be updated on a regular basis. I would like to write a script to review the records and everyone with a Date of Next Update that is greater then current date plus 60 an email message is sent as a reminder. This is what I am trying: Show All Records IF: DATE OF NEXT UPDATE > (Get(CURRENT DATE)+ 60) SEND EMAIL END IF This is not working for me. Any suggestions or help? Thanks, Scott