hartmut77

Sure I have a database which I have to automate text answers but sometimes there is more than one answer. So I wanted to write a script that would respond to whatever I put in a field called (codes). If I put the number 1 in the (codes) field then the field colors would say "RED" If I put the number 2 in the (codes) field then the field colors would say "Blue" If I put the number 3 in the (codes) field then the field colors would say "yellow" But if I have the numbers 1 and 3 in the field codes , the field colors should say RED, YELLOW or if I have the numbers 1,2, 3, in the field (Codes) , then in the field colors it should display RED, BLUE , YELLOW I also wanted the words to be the colors they were naming. So the word RED would be RED and the word Blue would be blue and yellow would be yellow, But Black would be bold. I would those things to happen from a script. Thanks DAVE

Hello I have a calc field called. (colors) and there is a list of codes. 1=red , 2 =blue , 3+ yellow etc. what happens when I want to use 2 or more colors. what would then be the calculation if the answer which triggers the calc were as follows' 1, 3 and the colors then would be red and yellow or 1 would just be "red" and 1&2 would just be red and blue I am not sure how to write this and furthermore I would like the colors bold and the actual color I am naming. Is that possible. Thanks DAVE

I have a few phrases that have to be in Bold only when they are being uses in a a certain sentence. In other worlds. If the "mary had a little lamb" comes up it should be bold. but if the phrase comes up "the dish ran away with the spoon" that should be plain text. Is there a way to make the style change to bold when having a certain phrase or answer and having it return to plain text style when that answer is not being used?

Hello I have a field with is called priority code. "PC" I have another calculation field which is called "TEXTCODE" the numbers are sequential from 1 to 7 and then they are ranges like 13-15 I have statements to be calculated to the field "TEXTCODE" and I need help writing them because they are lot. The table is this 1= "RED" 2= "GREEN" but 7-10 = "BLUE" So if the user enters in 8 it would be " Blue " in the text field I have to write this formula and i need help Thanks Dave

Hello I have three fields "pipeage" which is a date field "today "which is a date field and "yearsold" which is a calculation field I am trying to calculate the number of years the pipe has been there. So I am trying to get today field to display the year 2005 which I can't get it to do and then subtract for example 1950 from 2005 as 1950 would be in the "pipeage" field. and the answer would be 55 years. But I just can't get it to work. Could someone please guide me here Thanks Dave

I fixed it as soon as I used the same type file In the relationship. Thanks for your help

Hi I need a calc to give me the week number preceeded by the last 2 digits of the year ( 2004 =04 or 2010 =10 but the catch is that I need the week to be from each Wednesday through Tuesday and change dynamically. The field for this is called Weeknum Not sure how to do this? Any and all your thoughts and expertise very appreciated Dave

Hello I have a database with a few tables. I drew a relationship between the two tables in the graph window to the fields that could have a match. In the second database there are lots of possible words to match in its field. But when I do a find for the match word , I get an instant answer. In define fields , I do a lookup based on that relationship and it never works. Is there anything I can do. Any suggestions. Thanks

Hello I would like to lock out the possibility of others changing the number of records I have in a table is that easily possible somehow. Thanks

Hi I have three tables in my database. I would like to duplicate a table 2 more times and rename it . Is that possible?

I also will be using this solution on a network with 10 users. So I wanted to mention that.

I am working on a database which had about 20 files in earlier versions. I am wanting to put it all in one database as 20 tables. Is there any reason not to?

I would like to know if the old filemaker solutions can become a table in Filemaker 7 and two or three files could be combined in the one database?

Hi I have a text field called "temp" it has 2 lines or pne paragraph return How can I remove the second line only in the field "temp" Thanks FileMaker Version: 7 Platform: Mac OS X Panther

I have a large field with many chunks of text in it. Some of the chunks are 2 lines and some are three and some are four lines I am trying to find out if there is anyway that I could write a script or a calculation to select the very next group of text. ( There are thousands in this one field ) The distance of blank space between the chunks of text are different. I just wanted to put this out to the group to see if there is a way to do this thanks all It would look something like this skdjfalkjsdf;lakjsdf;kj ljsdf asdfasdf asdfkjaksdf asdfasdf asdflkja; asdfasdf jkljd;lakjsdf; asdfasdf asdfasdf j;kjl;kjkljaja asdfkasdfa;lsdfkj asdlfjalksdjf;alksdjf;ja;jkljaasdf asldkfja;lskdjf;lakjsdfa asdlfkjalskdjklajd;lkjg;lkjg asldkfjalksdjglaksjgalksdj aslkdjglkasjdglakdsjglkadjg; asdfjakljsdf;klajsdf;ajds asdlkfja;ksdfj;alksdjf;alksdd If I can select the next chunk of text , I can continue with another script. thanks again FileMaker Version: 7 Platform: Mac OS X Panther

Yes it does - and thanks very much

Hi I have a text field 'Par" with 5 carriage returns in each record. Sometimes there are only 4 lines. So I would like to have a calculation that would send the last line to a field called "five" when it occurs. So it would normally have 4 lines in the field "par" and when there is a five line exception I would a calc to send the 5th line to field "five" I would like your help please Thanks Dave FileMaker Version: 7 Platform: Mac OS X Panther

Hello I am using a script in a related file to do a find. I was wondering if there is a way to set a script to bypass the "no matching records found dialog box" and just place that very text " No records found" in a field by itself without having to go through the "okay" proceedure of the dialog box which is what I am trying to avoid. Thanks Hart

I need help with this .... PLEASE Sorry Ugo , I just got home. I am looking for people who have attended in the past but now have a greater than 4 week absence. That is what I am somehow trying to flag. Thanks I am not sure the best way to go about doing this. I usually end up with over the top solutions and you guys usually point out something a whole lot easier. Thanks again

Hello I am new to filemaker but i have to make a database with it. I am interested in making a file that will keep track of people who attend our classes ( they are free) and I am trying to figure out how to locate the people who don't come for 4 weeks. There are like 400 possible people but most don't come. That's where I am having the problem. I am staring at 4 fields. "eventDate" , "name" , "attending" "30days" - People who have attended once but are not there for 30 days. How can I track those people? Please suggest to me. I am all ears. Thanks Cindy

Hi My friend has an event which he gives out nametags to. He wants to give everyone a unique nametag in a range from 001 to999 and at that time it needs to reset back to 001 again. How can this be done in the specify calculation area of the options in define fields? Thanks

thanks for the answer I have a whole bunch of scripts to write about 1500 that are the same that will deal with little buttons. The only differ in what result they produce as far as the text each holds in their script. So I was wondering if there was a way to insert calculations ( text) calculations somehow remotely. Thanks Dave

Hi I know this is an unusual question. But since a script is really somewhat of a macro, I just wondered if there is any way to script the creation of scripts that only change certain text characteristics in their steps. I know this could be a complicated answer. I am just trying to find out if there is some way to automate script creation and the naming of scripts.

Hi This is truly amazing. Is there however a way to add these fields ( the automatic creation) to an already existing file? I have a file already that has all the other information I need. I would like to add all those fields to a file I have already worked on. I am not sure it that is doable. Thanks

Scratch That. It is solved already from the response of Jim McKee Thanks Again I am a little thick sometimes Dave