October 7, 200817 yr how do you get a text field to read a repeating field with text....i cant get a result of 1 or 2 Example: I have a text field-A with text in it "M-01" Then i have Repeating field with text in it "S-01", "W-01", "M-01" I need a calculation that says that Text field A has something in common with the Repeating field...the "M-01 is in both fields"....need a number result of 1...meaning yes If the Text field A does not match the repeating field then i need a number of 0...meaning no
Create an account or sign in to comment