AnsweredAssumed Answered

Data Validation via Script; compare single field (many words)  to Multiple records.

Question asked by digitalemu on Sep 8, 2014
Latest reply on Sep 9, 2014 by philmodjunk

Title

Data Validation via Script; compare single field (many words)  to Multiple records.

Post

Hi guys. 
This is an interesting one and one I it may have come up before, however I am either searching the wrong terms or it hasn't been posted yet. 

Here is what I am trying to achieve; 

Table 1 : Activity Table. 
Field needing valiation : "Details" (text)
Example of Details : 
"Called the customer today and informed him of changes"

Table 2 : validation table. 
Multiple records in 2 fields : Entry and Relation
example of data in validation records;

                                                                                                                                                                                                                                                                                         
entryrelation
callPhone Contact
emailEmail Contact
attendAttended
bookBooked Attendance

What I want to do: 

I would like to run a script that compares the "Details" to all "entry" data in the validation table... 
I.E: If "Details" contains any of the records in "Entry", show dialogue box with options. 

In this case: 
"Details" contains "call" (called)
dialogue box "Mark this activity a Phone Contact?"

I realise I may be missing something very simple here, but I am at a loss. 

Cheers in advance for any advice. 

Jamie.

Outcomes