I have an issue. A custom text field is created to store survey score number. Now I have to setup a flow rule when score is less than 5. A case should be created and assign to account owner.
My problem is when I tried put criteria survey score less than 5, I am not getting less than greater than option because it’s a text field. I tried to change data type but this field is using on account page as roll up summary and also use in multiple calculation.
So if I changed all data wipe out and I have to upload it again. It may be possible that I can loss the data.
Please help me to put less than or greater than criteria in text field so I can use it is process builder. I don’t want to change data type.