Skip to main content
Question

Can I set up a formula field so that a user can overwrite the information when in edit mode?

  • March 1, 2017
  • 0 replies
  • 142 views
Can I set up a formula field so that a user can overwrite the information when in edit mode? Another approach would be to set the default value for one field to equal the value of another field.  Is that possible?
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • March 1, 2017
      Yes.  A good use case for this, and the example I'm going to use, is when you have an Item price, but want to have the option to override the list price.

      [My List Price] is a field coming from a parent table, or an items table.
      [Price Override] is a field that can change the value
      [Price] will be the formula field that takes the list price, or take the override price.

      [Price] formula would be:

      If( IsNull( [Price Override] ), [My List Price], [Price Override])

      If you are using text fields, the similar, but use the sign ="" rather than the null:

      If( [My Override Text]="", [My Default Text], [My Override Text])
      .. just a tip.  If you are checking a numeric field to be blank with IsNull, be sure to set that numeric field to not treat blank as null.  There is a field property checkbox for that.
      • MaryMary
      • Author
      • Registered
      • March 1, 2017
      Thanks.  That is the way I have been doing it.  Was just wondering if there was a way using only one field.
      Terms & ConditionsAccessibility statement