Automate Find and Replace All

Question

Level 1

0 points

Automate Find and Replace All

Hi,

I'm hoping there's a way to have a button or something to automate Finding all "true" cells to "false" throughout the whole worksheet. Is that possible, too much to ask?

A little more info:

I've made a worksheet to take attendance. The basic premise is that when the checkboxes are ticked Numbers changes the cell from "false" to "true" and the results are tallied and averaged. When the next month starts the Month is changed from a dropdown menu A1, Numbers changes all the days and dates throughout the Worksheet. The people using these have little to no experience, so I need to find a way to refresh all the checkboxes throughout the worksheet by changing all the "true" back to "false". Any ideas will be very appreciated.

Thanks in advance.

Numbers-OTHER

Posted on Jul 1, 2015 11:04 PM

Reply

Answer 1

Best reply

Yellowbox

Level 7

20,347 points

Jul 2, 2015 5:43 AM in response to banidos

Hi Banidos,

You can't force a checkbox to become false (except maybe by AppleScript).

Manually change (click) all checkboxes to false, then Save as Template.

Each month, open the template and change the month. Ready to go!

Regards,

Ian.

Reply

Answer 2

SGIII

Level 8

35,264 points

Jul 2, 2015 7:41 AM in response to banidos

banidos wrote:

I'm hoping there's a way to have a button or something to automate Finding all "true" cells to "false" throughout the whole worksheet.

This will set all checkboxes to false in a table.

Copy-paste into Script Editor.
Click in a table's cell to select the table.
Click the triangle 'run' button.

For inexperienced users this can be placed in an Automator Service that can be installed with a double-click and then accessed from the Numbers > Services menu or via a keyboard shortcut. It can also be expanded to look throughout an entire document rather than just one table.

SG

tell application "Numbers"

tell document 1 to tell active sheet

set t to first table whose selection range's class is range

repeat with c in t's cells

if c's value is true then set c's value to false

end repeat

end tell

Reply