Skip to main content
Question

Add Inactive Field

  • November 28, 2023
  • 0 replies
  • 63 views

I have a table with many programs with checkboxes to indicate if each company in the listing participates.  I am adding a check box field for inactive.  Once checked I would like this account to still show up but be grayed out and not show up in the totals at the bottom.  Is this possible and if so, how do I make it happen?



------------------------------
John Butler
------------------------------
    This topic has been closed for replies.

    • ShaneMiller1
    • Quickbase Alumni
    • November 28, 2023

    Hey John, 

    A real quick fix is it have an additional field named [Inactive Total]. You could then setup either a form rule or pipeline that says: When [Inactive] is true, change [Total] to 0 and change [Inactive Total] to the value that [Total] was/ is (this part will take some experimentation to see if you can accomplish both at the same time on a form rule, or if you have to do it in steps via pipelines. 

    This would then allow you to see the record on the report whilst the total doesn't record any additional values since the [total] field is now zero



    ------------------------------
    Shane Miller
    ------------------------------
    Terms & ConditionsAccessibility statement