Hi there -
I'm trying to create a script such that if certain text is in field 1, a particular text will be inserted into field 2. To select the text in field 1, I've come up with the below; although, the line just generates an error message - "the specified table cannot be found." I selected the table from the list, and I cant find anything wrong with that table (misspelling not withstanding.) I can't figure out for the life of me why I'm getting the error.
If [ Not is Empty ( Filtervalues ( Identification::Diangostic Entity; "thyroid" ) ) ]
So my questions would be: will this function retrieve records containing the word "thyroid" from the field specified, and do I have the command written correctly?
Many thanks in advance for any insight. My knowledge of coding is very low, so very basic answers will be much appreciated.
Cheers - Sarah