June 7, 200520 yr simple question here... if i want to set an "if a field contains this word, then set another field with this word," how do i make the script understand "contains"?
June 7, 200520 yr The position() function works well for this. case ( position ( Field; "text"; 1; 1) ; "text" )
June 7, 200520 yr Try something like this: Set Field [TargetTable::TargetField; If(patternCount(SourceTable::SourceField; "bananas") = 1; "Fruit"; "Not Fruit"] This will make the target field say "Fruit" if the source field says "bananas" otherwise it will say "Not Fruit". The PatternCount function searches the text for an occurances of the sequence of letters that spell "banana". If it finds only 1 occurance then it validates true. Anything other than 1 will validate false.
June 7, 200520 yr Author I'm working with countries and regions, the former being a pop up list and the latter a radio button set. I want to build it so that if a user selects argentina, then the region latin america is automatically filled in the radio button set.
Create an account or sign in to comment