I need to run an agent on a bunch of selected records that will do the following:
1) Check to see if the Categories field contains "Competitive Agents" and the SubCategories field contains the substring "Reboxetine -- "
If the above is false
2) Do nothing
3) Overwrite the contents of the Categories field with the string "Reboxetine" and remove the substring "Reboxetine -- " from the SubCategories field and capitalize the first letter of the remaining SubCategories field contents.
We start with
Categories = "Competitive Agents"
SubCategories = "Reboxetine -- adverse effects"
we end up with
Categories = "Reboxetine"
SubCategories = "Adverse effects"
I haven't done any Notes work in a gazillion years and would prefer to find a way to do the above using formula rather than script, but will be VERY HAPPY to get anything that does the trick. Please provide as much detail as possible