lilwolfpro

Okay, I am going to attach a demo version of the file. The fields in orange are the ones I am trying to compare. I was initially trying to change them to numbers to evaluate, but let's see if you can figure this out to work without that extra step. What I want to do is have the field "Dog 1 Grade Jump" to result in "SAME" if the field "grade" is equal to the field "Dog 1 LRG". If the field "Grade" reflects an "A" and "Dog 1 LRG" is a "B", I want the result to be "DOWN" in field Dog 1 Grade Jump. If the field "Grade" reflects an "B" and "Dog 1 LRG" is a "A", I want the result to be "UP". If the field "Grade" reflects an "C" and "Dog 1 LRG" is a "A" or "B", I want the result to be "UP". This will of course continue for all grades. Dog 1 LRG is the field I did the cut and paste script, it is however equal to the 1st portal row, field PP_Grade, if that helps. Keep in mind there are 7 other portals in the original file for dogs 2-8. Thank you so much for taking the time to help me expand my knowledge of Filemaker Pro. Julie dogzip.ZIP

Thanks for all your help. I think you are way more knowledgeable than I am. I'm not familiar with the SetField command. I ran the first script on over 2000 records so I didn't want to re-run the script if not necessary. Each record in the main database is set up with an inequitable date relationship with the stat table(where the grades are stored) so no values from the other records are included after the date of the record. So since I did not know how to get the grade out of the portal, I wrote a script to go find the grade in the first stat record that predates the main database record date, cut that grade and pasted it in the main database. Now I want evaluate those fields and convert them to numbers. However since filemaker pro will not see the pasted results (they show up on my screen but apparently not valid for calculation), I can't figure out a work around.

Okay see if this helps. I initially ran a script that goes back into another database and copies data from a certain date. So, it goes back and copies the grade, then in my main data base, pastes the letter into the grade field. On main database, main layout where grade was pasted, I have field is supposed to be a calculation field that gives me points for an A,B,C,D grade EX. Case ( GRADE = "A" ; 4 ; GRADE = "B" ;3 ; GRADE = "C" ;2 ; GRADE = "D" ;1 ; GRADE = "F" ;0 ) The Grade field is the one that results were pasted into via an earlier script. I think you are right, it sees the field as empty instead of evaluating the pasted value.

Yes I know, it is an example, the rest reads... If ((Grade="A"; 5; If (Grade="B"; 4; If ((Grade="C"; 3...etc. I have tried the commit record and it isn't working. I have looked at the way the info is stored and haven't been able to make the formula work : It should be easy, can't figure out what I am doing wrong.

I have a field that via a script, pastes a value into a field on my main layout. When using the "If" function, Filemaker will not read the value. EX If ((Grade="A"); "1"; "0"). The field contents are equal to "A", yet the formula still returns "0". Any idea's how to fix this? I have made sure the calculation results match the output. It seems to think the pasted contents are empty or something...Thanks-Julie

How do I the results from the portal so I can restrict results limited only to portal records shown? I am building a greyhound racing analysis software for fun and want to limit results. EX. Main layout is Raceform, List 8 dogs in a race Dog 1 Portal pulls in his average speed from Dog Stats database. (matched by dog name) I have an inequitable relationship so the records pulled in the portal show his average speed of races run before the race date, sorted by date, most recent race first. I have 9 portal rows showing, however my field in main layout (average calc formula )averages all his past races. I want the average only to reflect his last 9 races. Any suggestions would be helpful-thanks.