Can I have a calculated field based on record state?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
So that a formula field reads "False" in edit mode but "True" when adding a record?
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Ammar

Ammar

  • 312 Points 250 badge 2x thumb
Can you please elaborate on the issue itself, you might have better luck finding a solution through Form Rules rather than a Formula!
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb
Actually, the whole point of this field is so that I can form rules trigger when adding a record and not when editing one. I did end up with a solution using form rules, though another solution I thought of was having a field, that say something like "yes" or "no" for if a record was in the add state. So thats why I wonder if it was possible to have a field detect record state in a formula.
(Edited)
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
If(IsNull(Record ID#), true, false)