Create a dynamic change rule for numeric formula field

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am trying to create a dynamic rule that changes a numeric formula field to "0" if an option is chosen in a drop down field. However the numeric formula fields seem to disappear when trying to pick a 'change' command. Any options for workaround?
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
You cannot manually edit the result of a formula numeric field either by hand editing or a form rule.  You would need to have an override field or check a box and then change your formula to use that other field in its calculation
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb
Thanks! That idea worked!