Calculation [if text field contains]

[John Harris]

I am trying to create a field which looks to a field in another file and asks if it contains certain data. The field in the external file contains names seperated by a carriage return. The fictional if statement I feel I want to use would be :

if(relationship::externalfield contains "JOHN","yes","no")

ANY IDEAS ?

What I have is a database of members and a database of events, I have a script to add a member to an event which copies the member name into a field in the events database for that event and does a carriage return. I then want a field in the members database which checks if that member is in the event.

I have tried to use repeating fields in the event database, however there are over 500 members in each event and I would need to check each repetition to see if it were valid. Also I would need to check each repetition to see if it contained data before adding a member to the next free repetition. I tried to automate this somewhat using a field that adds repetition +1, to use the getrepetition command and return a true/false result but you cannot specify paste +1 in this way.

Any advice much appreciated.

[andygaunt]

Hi,

Try to use the PatternCount function

if(PatternCount(relationship::externalfield,"JOHN"),"yes","no")

Now, if you are doing this in the member database, then you want to obviously check for their name, so change "JOHN" to the name field

if(PatternCount(relationship::externalfield,Your name field),"yes","no")

HTH