I've read this tutorial http://bigprof.com/appgini/tips-and-tut ... eld-values
I have this situation:
Table with 2 fields
First field "word_keywords" contains cells with words (between 1 and 10 words)
Second field "key_key" I want to add 1(one) if "word_keywords" contains one of 20 one word terms, and 0 (zero) if it doesn't.
For example:
"word_keywords" contains:
cell1 = blue basket
cell2 = green shirt
cell3 = blue shirt
cell4 = white shoe
cell4 = black jeans
"key_key" should add 1(one) to all cells equivalent to that contain word 'white" OR "shirt" OR 'green"
"key_key" field will contains:
cell1 = 0
cell2 = 1
cell3 = 1
cell4 = 1
cell4 = 0
Any suggestions?