Workflow: Check if one field value is contained in another field
Apr 4, 2020 6:46 PM
We have a lot of Companies with identical names, but different cities--for instance, First Baptist Church (city = Huntsville) and First Baptist church (city = Tyler). I would like to append " of ", followed by the City to each record, but sometimes the city is already there so I want to check to see if the City is contained in the Company Name before update. Is there a way to check if one dynamic field value is contained in another dynamic field on the same record before updating the record?