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 that contains the check box field and all the records you want to modify.

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

  3. From the In the field drop-down list, select the name of the check box field that you want to search.

  4. Do one of the following:

  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 check boxes.

 

This page refers to an older version of QuickBase. Online help is now located at http://www.quickbase.com/user-assistance/default.html.

 

Return to top   

© 1999-2013 Intuit Inc. All rights reserved. Legal Notices.