Skip to main content
Topics#FormulasPaul Pham 的问题
Paul Pham (paul@paulcorp.com) 提问于 #Formulas
2021年2月17日 02:08

validation rule - Compare 4 Fields

Hi, I'm new to validation rules. I'm wondering if there was a way to compare if any of the 4 fields have the same value. These 4 fields are user object fields. If not, would workflow be better for this?
1 个回答
  1. Rakesh Allam (Maersk Line UK Ltd)
    2021年3月18日 10:59
    Hi Paul,

    Case 1: if you know all 4 fields u can use valdiation rule as F1 == F2 & F2==F3 & F3==F4.

    Case 2: if you dont mention fields and you want check any 4 fields out off all fields in the object. Then you have to write a trigger before insert, before update. I suggest to use schema class to play with all fields with in your logic as part of comparision.

    Thanks.
撰写回答...
0/9000