Skip to main content
Question

Results of Formula Fields that we want to copy into field I can edit.

  • January 16, 2023
  • 0 replies
  • 45 views
I have a commission field that is calculated.  My boss wants to be able to change the amount.  How can I copy the values in that field into a field that can be edited?
Thanks,
Lori

------------------------------
Lori Pelzel
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    This is a typical problem and no different from Excel.
    You will need three fields.
    You already have the calculated field.  Rename it to [Calculated Commission]

    Then make a new field called [Commission Override].   Be sure it is not checkboxed to treat null as zero.
    Then make a new formula numeric field called either [Commission] or perhaps [Commission (final)]

    IF(not IsNull([Commission Override], [Commission Override], [Calculated Commission])



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement