Create Search Script with a Checkbox field

[jkonnyck]

I am trying to create a script to segregate a group of records using a checkbox.  In fig 1  I have a group of record.  In fig 2  I have selected 4 records by clicking the checkbox field (symbol X).  If i go to the top of the page and click find, then manually click the checkbox (which enters the X) then click on Perform Find, it works!  But I cannot seem to create a script to perform the same function.  Any ideas?

 

[AHunter3]

Enter Find Mode [] <—— don't restore, don't pause

Set Field [YourTable::CheckBoxField; "103 Parkfront Ln"]

New Record/Request

Set Field [YourTable::CheckBoxField; "19928 Casa Verde"]

New Record/Request

Set Field [YourTable::CheckBoxField; "9948 Cherry Hills"]

New Record/Request

Set Field [YourTable::CheckBoxField; "10393 Yorkstone Dr"]

Perform Find [] <—— do not restore requests here either

 

 

[AHunter3]

(You didn't say how your attempt was structured but most likely you were telling FileMaker to find records that had all those values in the same record)

[jkonnyck]

My apologies.  I should have explained that the addresses are each a separate record and the pis I posted was a list view layout.  I'm simply trying to create a find to show only records I selected using the checkbox.

 

[AHunter3]

I assumed that.  My answer assumes that as well.  Each address is a separate record.  That's what I was saying:  that *most likely* your attempt at scripting would result (wrongly) in a Find that would look for a single record containing ALL of those addresses... and would fail, because none of them do.

 

[jkonnyck]

But if I manually click on the "Find" button at the top, then click the checkbox and perform a find, it works perfectly.  I'm just wondering if there's a way for me to select the records manually and then use a script to perform the find. 

[AHunter3]

I don't understand.  If you're going to pick them manually in Find Mode, what "script" do you need?  

[jkonnyck]

It’s more of a nerdy thing. I was hoping to create a button action that would simply do the find after I ticked off the records I wanted to segregate. (Of course I’d probably want another button to clear the “x” out of the checkbox afterward to deselect those records!)

[AHunter3]

Attach the single script STEP "Perform Find" to the button.

And unless there's something unusual about your structure, the very act of performing the Find should, itself, deselect the "x" from the records, assuming you check the checkboxes while you're in Find Mode.

[jkonnyck]

First,

Thanks for all your help!  I tried assigning a single step to the button as shown and it worked! 

Now, when I try clearing the "X" value using "Clear Field" it only clears the "X" on the single highlighted record.  Is there a way to clear the "X" on all records?

[jkonnyck]

[AHunter3]

Write a script that does this, and attach this script to the button instead of the single script step Perform Find:

 

Perform Find [as above]

Replace Field Contents [no dialog, Budget::SELECT  ""]

[jkonnyck]

AHunter3.  Thanks again for all your help.  I added a zero in calculated result and it worked!  I appreciate all your time and knowledge. Stay well

[AHunter3]

Not "0"; blank!  ("")  <-- two quotation marks with nothing in between.  That's how you set your field to blank in Replace Field Contents.

The "0" will look empty in a checkbox-formatted field but it means you're leaving zeros in that field.

[jkonnyck]

Ohh. Got it!  I changed it to "" and all is well.  Again, thank you so much.