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, 200817 yr by Guest

Try;

RepeatingField[2]

Or use the GetRepetition() function.

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

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.

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.

sorry about the double post

7.0 filemaker pro

OS 10.4.11

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.

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

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

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

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

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

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.

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

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

so call me maybe i can explain it better

917-797-6787

please.....

I've sent you a private message.

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

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

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

what box?

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.

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