Auto-toggle boolean field across documents in Sanity schema

import { useCallback } from 'react'
import { set, unset } from 'sanity'
import { Switch, Stack, Text } from '@sanity/ui'
import { useClient } from 'sanity'

export function FeaturedToggle(props) {
  const { value, onChange } = props
  const client = useClient({ apiVersion: '2024-01-01' })

  const handleToggle = useCallback(async () => {
    if (!value) {
      // User is turning this one ON, so turn off all others
      try {
        // Find all other documents with isFeatured: true
        const query = `*[_type == "myType" && isFeatured == true && _id != $currentId]`
        const otherFeatured = await client.fetch(query, { 
          currentId: props.document._id 
        })

        // Create a transaction to update all at once
        let transaction = client.transaction()
        
        // Unset isFeatured on all other documents
        otherFeatured.forEach(doc => {
          transaction = transaction.patch(doc._id, { unset: ['isFeatured'] })
        })

        // Execute the transaction
        await transaction.commit()

        // Now set this one to true
        onChange(set(true))
      } catch (error) {
        console.error('Error updating featured status:', error)
      }
    } else {
      // User is turning this one OFF
      onChange(unset())
    }
  }, [value, onChange, client, props.document._id])

  return (
    <Stack space={2}>
      <Switch 
        checked={value || false} 
        onChange={handleToggle}
      />
      {value && (
        <Text size={1} muted>
          This is the featured item. Toggling another will unset this one.
        </Text>
      )}
    </Stack>
  )
}

export default {
  name: 'myType',
  type: 'object',
  title: 'My Type',
  fields: [
    // ... other fields
    {
      title: 'Is featured',
      name: 'isFeatured',
      type: 'boolean',
      components: {
        input: FeaturedToggle
      }
    },
  ],
  initialValue: {
    isFeatured: false,
  },
}