Checkbox Search and Replace

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I want to change the value on all checkboxes in a table (from "not selected" to "selected").

What value do I use for Search and Replace?
Photo of Dirk Ruana

Dirk Ruana

  • 902 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 5,436 Points 5k badge 2x thumb
Build a report of all the records that are going to be affected by this change.  Use the Search & Replace feature.  Choose the checkbox field from the drop-down selection; and set the from: value to FALSE and the to: value to TRUE.  Then click OK twice to update all the records.  The first OK will tell you how many records will be updated by the change; and the second will action the update and it will then tell you how many records were updated in the modal before you close it manually.
Photo of Dirk Ruana

Dirk Ruana

  • 902 Points 500 badge 2x thumb
Worked like a charm!

Thank you,

Dirk