janet K

Never mind...I got this working. Not sure what I was doing wrong yesterday but it is working today.

I am looking for some help. I am looking to do a nested if within a calculation. I am looking to change the email based on the arrival and departure dates and whether they are the same. The two different sentences would read: Greetings! This email is confirmation your upcoming visit to John's College on April 2, 2010. or if they are viting for more then one day it would read: Greetings! This email is confirmation your upcoming visit to John's College on April 2, 2000 through, April 3, 2010. Can I do this? When I try to add this the "through, April 3, 2010." it gives me errors and trys to make "through" a field. Any information or links to as to how to put a nested if inside a calculation field in the send mail cript I would appreciate it. Thanks, Janet

I have a file that I download every morning, that is only "reset" or "cleaned out" every couple weeks. Which means every morning I get the new records in addition to what I downloaded have already downloaded yesterday. Right now I open yesterdays file and find the last record that I imported yesterday. Then I open my new file and delete yesterdays records out of the file before bringing it into filemaker. Because after I import this data some of it changes I dont want to import and have it update the records putting the records back to what they were when they sent in the original request on the web. My file contains a serial number I would like to have it match on the serial number and only import the new records, is there a plug in out there for this?

Thanks, that worked

sorry may was a bad example. It is not a 3 character month is is the whole word spelled out so the length will vary. The day also changes because they are giving me one character days for 1-9. I will look more closely at what you sent me and see if I can modify it.

I have a file that I am trying to import into filemaker. The date is set up as follows: May 1, 2009 How do I convert those dates to something that filemaker recognizes as a date. I want to be able to sort and find on all these dates. Right now I am importing them into a field that is defined as a date but it displays a question mark. I feel like this is one of those things that should be so simple, but I cant find any solutions. Do I have to write a custom function for this?

I have created a PDF in Filemaker 8.0v3 and when I open this PDF in Adobe 9 and try to print it it gives me an error of: "unable to start print job" "A drawing error occurred" The margins look good. I have even changed the paper size to 11X17 to make sure the margins are not the problem Any suggestions? Everything that I am finding when I google says it is not adobe it is the program that created the PDF...of course!

:tigger: Thanks...that worked. Janet

Hi Everyone, The datafile that I was given to work with has returns in it that are showing up in filemaker as ~}crlf} I know I can do a find and replace and take that data out but is there a symbol in filemaker that I can use that will put a return in so the data in this text field will show up properly. This is what it looks like: choral groups 9-12~}crlf}drama productions 9-12~}crlf}stu gov 9-12 class rep~}crlf}NHS 11, 12 VP~}crlf}special olympics 11, 12 This is what it should look like: choral groups 9-12 drama productions 9-12 stu gov 9-12 class rep NHS 11, 12 VP special olympics 11, 12 Suggestions?

Yes, I could do everything else that was network related. This morning I have another users machine having the same issue. Interestingly enough they pushed Service Pack 3 onto her machine over the weekend. I am wondering if it is related to Service Pack 3 in any way, although I have other machines that are running fine with service pack 3.

Thanks for the suggestion, unfortunately it didnt work. Our computing department has sent my computer to the shop to be reimaged. Thanks anyway

I have a machine running windows XP and every time I try to launch FM8 and go into the databases that are on the server it locks my active directory account. All of my databases use active directory for authentication. If I take a different computer and log in with the same cridentials it lets me in fine. I had changed my active directory password and I have had trouble ever since. It is acting like my computer is still trying to pass the old password to the server in some way. I have: -Removed filemaker and reinstalled it -Moved my data and deleted the profile off the computer and started fresh with a new profile. -Restarted the filemaker server a few times -It doesnt even let me log in with a master username and password for the databases Still no luck....any suggestions?

I am working on making a database for events that we get invited to. Some of them only happen once for one date, others are 3 or 4 days in a row, while others are all the weekends in october. What is the best way to store this if someone wants to go in and put in a date or date range and find out all of the events that are happening for those dates. Now that I am typing this I am thinking that the date and time should be in its own table? While the other event information is in anohter table. Any suggestions would be greatly appreciated.

Vaughan..thank you for the response. I have searched for lock record but I only want to lock certain fields not the entire record.

I am sorry if I am not using the correct terminology here. I have a database that we use in our admissions office to track events school visits and information sessions. Once an event has been marked as "display on web" I don't want anyone to be able to change any of the location or date and time information. Can I lock a field so it is read only based on the value of another field? Would I do that with scripts? Thanks for your time. Janet

It can be both the originating and arrival if it is a direct flight with no connections. I think I just need to make Originating, Arrival and departure as three different fields. Not the cleanest way to do it but it will work.

I have a database that contains people and a related table that has their flight information in it. There are reports that need to be run where I pull information regarding their originating, arrival or departure flight information. I have created a field which tells us what type of field it is. It contains words originating, arrival or departure, with direct flights the field could contain both originating and arrival. This is the calculation I am using to pull the name of the airline for the arrival flight. If the field contains both originating and arrival it doesn't work. Is there a different operator or calculation that I can use to evaluate the entire field for a particular word? Case ( type_of_flight ="Arrival";airline;"" ) The other option is to make arrival, departure, and originating all their own fields. Any suggestions?

Thanks Stanley, I will double check these things. Not everyone is loosing their connection at the same time. One person gets the error and everyone else is still in. Some people are in for 4 or 5 hours and fine and others get booted out 4 times a day, but not the same people. It wasnt happening on the client side until we got a new XP machine to put the server on so I am feeling like it is more and more like it is something on that machine that I am missing. Thanks Janet

I am hosting about 45 filemaker databases on a filemaker server version 5. Ever since I set up the new server people are getting disconnected. The error they are getting is as follows: Communication with the host has been interrupted and could not be re-established (-20) Any idea what could be causing this error? I have it set up so that it doesnt disconnect them if they are idle. It is now doing it more often even when people are in the middle of entering a record. Any help would be greatly appreciated. Thanks Janet

Thank you!!! That worked Great!

Hi Everyone. I am stuck on something and I have been working on this all morning and I am not able to solve my problem so I thought I would throw it out there to a few others that use filemaker. I am looking to import a .dat file that has been given to me into filemaker. I have a few fields that have a valuelist. I want it to check off mulitiple values in a valuelist. The only way to do that is to have a data field that checks off all of the items it needs to is to have a return after each item which makes your data look like this: 04 Fall 05 Spring My Data file looks like this, all in one field: 04 Fall, 05 Spring I cant replace my comma's within that field either before I import them because it messes up the import. I would do it after I imported but I cant seem to do a find on a comma in that field I am getting the error "There is no valid criteria in this request. Type a valid request." Has anyone else had success importing into a field with a value list where you want it to check off more then one value? If so how did you do it? Suggestions? Does this make sense to anyone...it is driving me nuts. Thanks Janet

I am looking to import a dat file that has been given to me into filemaker. I have a few fields that have a valuelist. I want to check off mulitiple values in a valuelist. The only way to do that is to have a data field that looks like this: 04 Fall 05 Spring My Data file looks like this: 04 Fall, 05 Spring How do I replace my comma's within that field either before I import without it messing up the import. I would do it after I imported but I cant seem to do a find on a comma in that field because it is not a member of the value list Suggestions? Thanks Janet

I have Filemaker server running on an older mac and our office moved to windows machines last year. I am trying to move my filemaker server 5.0 to a windows 2000 machine and I have installed it but when I click on the icons in the control console nothing happens!!! I have created a folder in the filemaker server folder and put a database in it but I am not able to open that file on the server. Any ideas? Please help!!

I have a script that is very simple that when the user clicks on a button it adds their username, date and time to a comment field, the next person that comes into this record it adds their comment to the bottom of the field and so on...I would like this text to be in a particular color can I automate that? I dont want all the text in this field to be that color just the text they are adding by performing this script. Any ideas?

Is it possible to export data from a file in a fixed Position Format? I dont believe I can do this in an export. Maybe I can do it in a script, putting all the data into one field and just exporting that one field. What I want to do is take a tab deliminated file that I get import it into filemaker and take it out in a fixed position format. So that the Gender is Position 1-2 First Name is Positions 3-10 Last Name is in Position 11-15 and so on. Any Ideas as to how to do this? Thanks, Janet