---
title: "Search and replace data in a check box field"
slug: "searching-and-replacing-data-in-a-check-box-field"
updated: 2026-04-30T22:45:36Z
published: 2026-04-30T22:45:36Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.quickbase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Search and replace data in a check box 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](/v1/docs/what-is-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, select **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. Select **OK**, and then select **Replace** to confirm the changes.

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

> [!NOTE]
> Note: Do not select the **Match Whole Field Only** or **Match Case** checkboxes.