Activate or Deactivate all records in a "Yes/No" field

How can activate or deactivate all records in a "Yes/No" field.

The Table is 'Control Deliverables' and the name 'Yes/No' field is Protect.

- Ninox partner
- RoSoft_Steven.1
- 3 mths ago
- Reported - view
Did you try the "Bulk edit..." ?
- Alan_Cooke
- 3 mths ago
- Reported - view
I have this script to lock all records in the Projects table.
Under a button to unlock.
do as server
   for i in (select PROJECTS)[LOCKED = true or LOCKED = null] do
       i.(LOCKED := false)
   end
end;
alert("All records unlocked")

Under a button to lock
do as server
   for i in (select PROJECTS)[LOCKED = false or LOCKED = null] do
       i.(LOCKED := true)
   end
end;
alert("All records locked")

I have also set 'display as' so that each button is only displayed based on the locked/unlocked condition. That way when locked the locked button is hidden and the unlock button is displayed and vice versa. The Yes/No field is always on display so that I can unlock/lock an individual record.

Hope that helps.
- Rafael Sanchis
  
  Rafael_Sanchis
  
  3 mths ago
  
  Reported - view
  Thanks Alan
- Alan_Cooke
  
  3 mths ago
  
  Reported - view
  You are welcome. I use these icons for the button
  
  , - How? If you have a Windows OS then Windows Key + ; does the trick.
- John_Halls
- 3 mths ago
- Reported - view
Another approach would be to set the Binding of your Protect field to 'Global variable in memory (browser)'. It then has a single value for all your records. Its initial state is set by the 'Default value'. To set this with a script, its just

let a := record('Control Deliverables',1); a.Protect := true

Regards John

Content aside