checkboxes – How to indicate the ternary options for turning a feature on, turning it off, or leaving it as it was?

There is a remotely operated device / toy / drone, which has a number of “functions”: various lights, sound effects and so on. There is a remote control with a number of physical buttons. This remote control can be configured with a GUI so the user can set which button operates which functions. By the press of a button, the remote control sends a command containing the states of all the functions.

It seems simple at first: if we have 4 functions to be controlled for a specific button, we could just have a list of checkboxes:


download bmml source – Wireframes created with Balsamiq Mockups

This will turn functions 2 and 3 on, and functions 1 and 4 off, on the press of the button.

However, we would like to have a possibility to not touch a specific function. For example, we want the user to be able to specify the following: “turn on function 1, turn off function 2, and leave the others as they were” (because they might have been activated by another button and we don’t want to undo that).

I fear that an undetermined (tri-state) checkbox won’t be clear enough:

enter image description here

We want to clearly indicate that it’s a “turn on” command, a “turn off” command, or there is no command.

Another straightforward way would be to use drop-down lists:

enter image description here

The problem with this is that the vast majority of the userbase is not computer-savvy at all, and might get confused. Checkboxes in the first example were so simple…

But having two checkboxes per row (one for “affect this function?” and the next for the actual command, which is greyed out if the first is unchecked), would be even more confusing.

google sheets – “Complicated” Conditional formatting with checkboxes and matches

First of all I apologize that I am failing to come up with a specific title about what exactly I am trying to achieve, so I made this picture as an example result.

enter image description here

If a recipe is checked, I want the formula for the conditional formatting to be looking for a recipe match (of all of the recipes checked (for which rows column C is True)) in D3:G7 and highlight certain cells if a match occurs.

The highlighted cells should be:

  • The cell in the row where the match was found in column A.
  • The cells where the match was found.

I have tried for hours and got familiar with a lot of new functions while working on my sheet but I just keep getting overwhelmed and find myself at a dead end on this specific task.

Would very much appreciate your help!

8 – #states required in datetime and checkboxes doesn’t work

I have this code in a form class:

// ...

 * {@inheritdoc}
public function buildForm(array $form, FormStateInterface $form_state) {
  $form('check') = (
    '#type' => 'checkbox',
    '#title' => $this->t('Checkbox'),

  $form('datetime') = (
    '#type' => 'datetime',
    '#title' => $this->t('Datetime'),
    '#states' => (
      'required' => (
        ':input(name="check")' => ('checked' => TRUE),

  $form('checkboxes') = (
    '#type' => 'checkboxes',
    '#options' => (
      0 => 0,
      1 => 1,
    '#title' => $this->t('Checkboxes'),
    '#states' => (
      'required' => (
        ':input(name="check")' => ('checked' => TRUE),

  $form('actions') = ('#type' => 'actions');
  $form('actions')('submit') = (
    '#type' => 'submit',
    '#value' => $this->t('Save'),
    '#button_type' => 'primary',

  return $form;

// ...

But when I check the field Checkbox the field Datetime and Checkboxes don’t get the required state.

What did I do wrong?

sharepoint online – adding a missing permission level "restricted view" – which checkboxes should be activated

I have 3 websites in Sharepoint for classes that I have. On the site of a class, I was able to successfully create a new group that allowed users to read but not download files with the "Restricted View" permission available. However, when I tried to replicate this on the other two websites for some reason, the pre-filled permission level "Restricted View" was missing. So now I'm trying to add a new layer to these other websites with the same name (& # 39; Restricted View & # 39;) that behaves the same way. I'm now looking at the long list of check boxes that should be selected to mimic this permission level. I would like to ask if anyone knows which boxes have to be activated for this authorization level. The description of this level is:

Restricted view – Can display pages, list items and documents. Documents can be viewed in the browser but not downloaded.

Checkboxes – How should I see overwriting a checkbox field?

Within our software we need the ability to overwrite fields. Our standard is as follows:

  • The original field must be read-only and have a "Overwrite" check box next to it
  • If you activate the "Overwrite" option, a dependent field should be displayed in which the user can enter the overwrite
  • If the override cannot be left blank, it should be marked as required


Enter the image description here

This standard works well with all field types except check boxes, as it only seems a little confusing with them.

As a reference, this standard for check boxes looks like this:

Enter the image description here

An idea we have is this:

Enter the image description here

Is the idea that we have the right path or are there better ways to override check boxes?

ajax – Search without filtering the values ​​for user meta checkboxes created by ACF

I'm working on a custom search filter that filters users by user meta. All user fields were created using the "User defined in advance" field.

I'm trying to filter users by checkbox values ​​that users select from their profile. but some like not filtering data. I even tried custom PHP queries to get the data by checkbox values ​​but it didn't work. I think the problem is in the checkbox value format that is stored in the database.


And below is my code for filtering the data by Ajax.

Search form

('50'), 'fields' => ('category', 'type_of_session', 'wheelchair_access', 'telephone_life_coaching', 'face_to_face_life_coaching', 'home_visits', 'sign_language', ), 'form' => false )) ?>