I’m trying to create a field (Bulletins) that will return one of three values, based on the presence of one of three phrases in a record’s long text field. Basically:
If Comments contains Advance Notice, then populate Bulletins field with Advance Notice
If Comments contains Time Sensitive, then populate Bulletins with Time Sensitive
If Comments contains Update, then populate Bulletins with Update
I’ve tried a couple configurations to get it to work and can’t quite get there. Any help would be much appreciated!