I am using CR 11
I am trying to create formula that will flag a field if it has uppercase GS in the field name
Ie. the formula reads as follows: If {Intake.Intake_Name) like "*GS*" then "Y"
This works if the field name is (GS)Smith, but it also works if the field name is Stallings(because of the last 2 letters in the name).
I would like the formula to flag the field only if the "GS" is capitalized.
I've experimented by modifying with If {Intake.Intake_Name} like UPPERCASE("*GS*"), but
it still flagged field with the name Stallings in it.
I am trying to create formula that will flag a field if it has uppercase GS in the field name
Ie. the formula reads as follows: If {Intake.Intake_Name) like "*GS*" then "Y"
This works if the field name is (GS)Smith, but it also works if the field name is Stallings(because of the last 2 letters in the name).
I would like the formula to flag the field only if the "GS" is capitalized.
I've experimented by modifying with If {Intake.Intake_Name} like UPPERCASE("*GS*"), but
it still flagged field with the name Stallings in it.