Search and Replace Data in a Checkbox Field

Imagine that you use Quickbase to manage your company's production of glass hippo figurines. You've produced your quota of hippos for the week, so you open your Quickbase application and mark all your figurine records "completed" by turning on a "completed" checkbox for each one. Then, a clumsy colleague of yours knocks over the shelving that held all your glass hippos, smashing them to pieces. To make sure your boss doesn't promise delivery of the hippos, you must return to the application and remove all the "completed" checkmarks you added before the accident.

Must you go to all the trouble of editing each record individually? Of course not. To solve this problem efficiently, you'd create a report containing all the relevant records, and then conduct a simple find and replace operation on your checkbox field.

To conduct a simple find and replace operation on your checkbox field:
  1. Create (or open) a table report that contains the checkbox field and all the records you want to modify.

  2. At the top of the report in the blue header, click More, then select Search and Replace in this report.

  3. From the In the field dropdown, select the name of the checkbox field that you want to search.

  4. Do one of the following:

    • To change "checked" to "unchecked," type Yes in the Change box and type No in the To box.

    • To change "unchecked" to "checked," type No in the Change box and type Yes in the To box.

  5. Click OK, and then click Replace to confirm the changes.

    To see the results of this action, you must refresh or reload the page in your browser window.

Note: Do not select the Match Whole Field Only or Match Case checkboxes.