Discussions

Expand all | Collapse all

Can I have a calculated field based on record state?

  • 1.  Can I have a calculated field based on record state?

    Posted 07-18-2017 19:14
    So that a formula field reads "False" in edit mode but "True" when adding a record?


  • 2.  RE: Can I have a calculated field based on record state?

    Posted 07-18-2017 19:39
    Can you please elaborate on the issue itself, you might have better luck finding a solution through Form Rules rather than a Formula!


  • 3.  RE: Can I have a calculated field based on record state?

    Posted 07-18-2017 19:54
    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.


  • 4.  RE: Can I have a calculated field based on record state?

    Posted 07-18-2017 21:16
    If(IsNull(Record ID#), true, false)