help - cant get a calculation to work

[David Waxtel]

how do you get a text field to read a repeating field with text....i cant get a result of 1 or 2

Example: I have a text field-A with text in it "M-01"

Then i have Repeating field with text in it "S-01", "W-01", "M-01"

I need a calculation that says that Text field A has something in common with the Repeating field...the "M-01 is in both fields"....need a number result of 1...meaning yes

If the Text field A does not match the repeating field then i need a number of 0...meaning no

Edited October 6, 2008 by Guest

[comment]

Try;

RepeatingField[2]

Or use the GetRepetition() function.

[David Waxtel]

But i have 20 Repetitions

should it read

Extend(text field) = GetRepetition(textfield,1) &

Extend(text field) = GetRepetition(textfield,2) &

Extend(text field) = GetRepetition(textfield,3) ...etc

[comment]

I am not sure what your intended result is. If you want all the repetitions of a repeating field, try:

GetRepetition ( RepeatingField ; 1 ) &

GetRepetition ( RepeatingField ; 2 ) &

GetRepetition ( RepeatingField ; 3 ) &

...

GetRepetition ( RepeatingField ; 20 )

(You would probably want to include some separator in-between the repetitions, too.)

This is much simpler in version 8.5, with its List() function - or, if you had the Developer version, you could a use a custom function instead of having to enumerate the repetitions.

The Extend() function is meant to be used with a NON-repeating field in a repeating calculation field. IIUC, your situation is exactly the opposite.

[comment]

Please do not edit your posts AFTER they have been answered - it makes us look stupid. If you have a clarification or a follow-up question, add a new post.

I will answer your (new) question shortly, but first you need to clarify for which version of Filemaker this is intended. You indicate version 7 and Mac OS 9 (this is not possible) AND Server 5.

[David Waxtel]

sorry about the double post

7.0 filemaker pro

OS 10.4.11

[comment]

Try:

Let ( listOfValues =

GetRepetition ( RepeatingField ; 1 ) &

GetRepetition ( RepeatingField ; 2 ) &

GetRepetition ( RepeatingField ; 3 ) &

...

GetRepetition ( RepeatingField ; 20 )

;

not IsEmpty ( FilterValues ( FieldA ; listOfValues ) )

)

This will return 1 if the value in FieldA is included in one (or more) of the repetitions of RepeatingField, 0 otherwise.

[David Waxtel]

i have two file i need to send to someone to look at, so i can talk to them and see if this problem of mine can be done.

im just brain dead on this

[comment]

You can post your files here. If that's not suitable, you can contact someone privately with an offer of gainful employment. :

[David Waxtel]

ok...how do you attach a file....?

the files are .fp7....what am i doing wrong

better yet how do i find a person to do this i will have to pay ....its ok

[comment]

You need to zip your files before attaching. Read the forum's Help for more details.

[David Waxtel]

lets see if this could be done - two test files

file xxxxxx is a list of classes (Code), and cof class(Conflicting Classes) are other classes that cannot be taken because the Class (Code) is at the same time.

a student registers for a class he/she is given a reg #, a record in made (the first record shows he registered for M-01). The second record shows he/she registered M-02). M-02 conflicts....i need to show that there is a "CONFLICT" and cannot take the class.

two_files.zip

[comment]

I am sorry, your files are too cryptic for me to follow.

In general, given a core structure of:

Students -< Enrollments > - Classes

conflicts would be managed by defining a self-join of Enrollments (joining all OTHER enrollments of a specific student), and testing for a conflict there.

If each class has a list of conflicting classes, then the test for a conflict would be: my class cannot appear in a concatenated list of my siblings' classes list of conflicting classes. Or, same thing: a list of my sibling's classes cannot contain any class that's listed in my class as conflicting.

BTW, I would use a related TO instead of repeating fields for the conflicting classes.

[David Waxtel]

now im totally lost

i use a mac...so the files are mac files

where do i go to find someone to just do this for me. Or a person to recommend.

my e-mail is [email protected]

give me a phone number i will call

[comment]

I'm afraid you misunderstood me. My computer opens and reads your files just fine. It's my brain that's having a problem.

[David Waxtel]

so call me maybe i can explain it better

917-797-6787

please.....

[comment]

I've sent you a private message.

[David Waxtel]

I got a message but no e-mail address

here is what it has to do:

its very simple i have two files as suppied

file: xxxxxx Each record is a Class..... the code (Class number) "M-01" .....and cof class (Conflict classes you cannot take) M-02, W-01, sf-1, M-05

File: xxx2 If a student registers for a class Example Reg (Registration student number) "1" picked Code "M-01" creating the first record .....then he picks "M-02" the second record...this should be a conflict because on file xxxxxx cof class "m-02" has a conflict with M-01 the sudent cannot pick this class...the word "CONFLICT" should appear...this is the same for the fifth record "M-05" is a CONFLICT

dave

[comment]

This is rather embarrassing... If you want a private consultation, then please respond to the private message - in private. If not, then say so.

[David Waxtel]

i dont understand....where is this private message?

what box?

[comment]

At the top of this page there's a menu. Click My Profile > View Private Topics. There should also be a flashing indicator at the right of the menu, which will take you to the same place.

[David Waxtel]

The repeating field is filled in by the school they deside what classes overlap