Automatically calculated fields based on words

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
Saroma
Posts: 2
Joined: 2014-09-29 13:17

Automatically calculated fields based on words

Post by Saroma » 2014-09-29 16:22

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?

Post Reply