Checkbox formula that stays checked

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hello,

Is there a way to make a checkbox formula field to stay checked after being checked the first time?

For example, if a status field has a value "A" when created and a checkbox gets checked, but then changes to status "B" but i would like to keep the box checked. I know this can easily be done manually, but i am dealing with a lot of constantly changing records that are being imported from other apps so manual is not an option.  

Photo of Igor

Igor

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
When you say "and a checkbox gets checked", how is it getting checked now?  Also what is the real meaning when it gets checked.
Photo of Igor

Igor

  • 0 Points
Ok so it looks like this now If (([Consolidated Site Status] = "Carryover"), true) Now this status will change to Completed or Canceled but then we won't be able to track if the status was at any point in "Carryover". Logs will not help because we can't report metrics on those. The idea is to show how many were "Completed" and out of those completed, how many were carryovers. I would like to keep this checkbox checked if at any point it was flagged a carryover.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
I would suggest that during the import process  and by using a form rule that you also populate a field to be called [Consolidated Site Status log changes] field which is a text field set to Log Changes.(that is a field property setting)  So during import and also when the ([Consolidated Site Status] field is changes, then also change the value of that field.

Then your checkbox field can be changed to

IF(Contains([Consolidated Site Status log changes],"Carryover"),true)
Photo of Igor

Igor

  • 0 Points
Sounds like a plan, i will give this a try. Thank you!
Photo of Igor

Igor

  • 0 Points
Hi Mark, the form rules will not apply when i am importing from another app using the Import/Export option.