In Google Sheets how can I view which cells are protected?

In my Google Sheets spreadsheet I set the Protection for some of the cells so that “Only You” can edit (only myself can edit, but the dialog text reads “only you”). Other cells do not have any protection. I would like to be able to run a script which adds a thick red border around each cell that has protection, or if that is not possible, add the border on every cell that is does not have any protection. I have tried various scripts but I have only found how to set the protection not determine whether or not the cell is protected because if I (myself) can edit, then since I can edit all the cells in the spreadsheet, the script cannot differentiate cells that have no protection from cells that have protection but I can edit.

D8: Embedding View in custom form with exposed filters causes custom submit not to fire

I am trying to embed a View into a custom form which has exposed filters. However when I add the field, it causes my custom submit button not to fire at all. It doesn’t even try to reload the page.

This is my View element:

    $  form['view'] = [       '#title' => 'Select Assets',         'view'   => [           '#type'                    => 'view',           '#name'                    => 'media',           '#display_id'              => 'asset_selection',           '#embed'                   => TRUE,         ],     ]; 

And my submit function:

    $  form['asset_select_submit'] = [       '#type'                    => 'submit',       '#name'                    => 'form_submit_custom',       '#value'                   => $  this->t('Submit'),       '#submit'                  => ['_mymodule_submitForm'],       '#limit_validation_errors' => [], ]; 

I have tried adding the View both this way and using views_embed_view() with no success.

Is this possible, and if so, could someone point out where I am going wrong please?

How to use a template to replace the field of a view?

I created a Drupal 8 view with a “User ID” field and a “Custom Text” field.

The machine name of my view is :

menu_page_utilisateur 

The “Custom Text” field uses tokens to display user IDs.

I created a TWIG to replace the “Custom Text” field :

views-view-fields--menu_page_utilisateur.html.twig 

It works, but User IDs do not appear.

<ul class="nav nav-pills">   <li class="nav-item dropdown">     <a class="nav-link dropdown-toggle" data-toggle="dropdown" href="#" role="button" aria-haspopup="true" aria-expanded="false"><i class="fas fa-plus-circle fa-lg"></i> Gérer votre compte</a>     <div class="dropdown-menu">       <a class="dropdown-item" href="/user/{{ uid }}/tasks" data-drupal-link-system-path="/user/{{ uid }}/tasks"><i class="fas fa-tasks fa-lg"></i> <b>Liste des tâches</b></a>       <a class="dropdown-item" href="/user/{{ uid }}" data-drupal-link-system-path="/user/{{ uid }}"><i class="fas fa-eye  fa-lg"></i> Voir</a>       <a class="dropdown-item" href="/user/{{ uid }}/edit" data-drupal-link-system-path="/user/{{ uid }}/edit"><i class="fas fa-feather-alt fa-lg"></i> Modifier</a>       <a class="dropdown-item" href="/user/{{ uid }}/cancel" data-drupal-link-system-path="/user/{{ uid }}/cancel"><i class="fas fa-trash-alt fa-lg"></i> Supprimer</a>       <a class="dropdown-item" href="/user/{{ uid }}/subscription" data-drupal-link-system-path="/user/{{ uid }}/subscription"><i class="fas fa-certificate fa-lg"></i> Abonnements</a>       <a class="dropdown-item" href="/user/{{ uid }}/orders" data-drupal-link-system-path="/user/{{ uid }}/orders"><i class="fas fa-shopping-cart fa-lg"></i> Commandes</a>       <a class="dropdown-item" href="/user/{{ uid }}/payment-methods" data-drupal-link-system-path="/user/{{ uid }}/payment-methods"><i class="fas fa-credit-card fa-lg"></i> Modes de paiement</a>       <a class="dropdown-item" href="/user/{{ uid }}/customer" data-drupal-link-system-path="/user/{{ uid }}/customer"><i class="fas fa-address-book fa-lg"></i> Carnet d'adresses</a>       <a class="dropdown-item" href="/user/{{ uid }}/groupes" data-drupal-link-system-path="/user/{{ uid }}/groupes"><i class="fas fa-users fa-lg"></i> Groupes</a>       <a class="dropdown-item" href="/user/{{ uid }}/stores" data-drupal-link-system-path="/user/{{ uid }}/stores"><i class="fas fa-shopping-bag fa-lg"></i> Boutiques</a>       <a class="dropdown-item" href="/user/{{ uid }}/profils" data-drupal-link-system-path="/user/{{ uid }}/profiles"><i class="fas fa-address-card fa-lg"></i> Profils</a>       <a class="dropdown-item" href="/user/{{ uid }}/like" data-drupal-link-system-path="/user/{{ uid }}/like"><i class="fas fa-heart fa-lg"></i> j'aimes</a>       <a class="dropdown-item" href="/user/{{ uid }}/invitations" data-drupal-link-system-path="/user/{{ uid }}/invitations"><i class="fas fa-envelope-open fa-lg"></i> Invitations</a>     </div>   </li> </ul> 

How to replace only the “Custom Text” field without overwriting the tokens that have been used ?

enter image description here

Can I link Trello boards to create a ‘global view’ of my boards

Is there a way to view cards from all my Trello boards on one summary board.

The reason to do this: I’d like to give different team members access to different boards, however I’d like to have a single board from which I can access all of them – giving me a global view of what is happening.

I can ensure all boards have the same list names, to make it work. Is this possible directly, or is there a way to get a similar result.

How can students view highlighted comments on their assignments in Google Classroom?

Students have been submitting PDFs of their math homework in Google Classroom. I’ve been then clicking the “Add a comment” button to drag a highlight area over the section of the document I want to comment on. I might drag it over an equation and then write a little comment like “what happens if you move x to the other side?”

Unfortunately, it’s just been made aware to me that students only see the yellow highlights over their PDFs when they view their assignment in Google Classroom :(. There’s no obvious way for them to view all the notes I’ve been spending time writing!

Is there a way at all for students to view my notes? Is this a temporary bug in Google Classroom or an unimplemented feature? I was only able to find this help page on providing feedback on assignments.

Here is an example of some feedback I provided. I dragged my mouse cursor to highlight “Therefore x would be a subset of A” and provided the comment shown.

Example of feedback

Aligning Text View with constraint Layout

I am trying to align my textview in the constraint layout without using margins so the layout can be responsive in all the devices but so far I am stuck in positioning. Here is my code and expected output attached in the image. I just want to make the amount align slightly with currency text.

    [![<?xml version="1.0" encoding="utf-8"?> <android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"     xmlns:app="http://schemas.android.com/apk/res-auto"     xmlns:tools="http://schemas.android.com/tools"     android:layout_width="match_parent"     android:layout_height="match_parent"     android:orientation="vertical"     tools:context=".MainActivity">        <TextView          android:id="@+id/year_bar_chart_total"          android:layout_width="wrap_content"          android:layout_height="wrap_content"          android:text="Total"          app:layout_constraintStart_toStartOf="parent"          app:layout_constraintTop_toTopOf="parent"          />      <TextView          android:id="@+id/yearBarChartCurrency"          android:layout_width="wrap_content"          android:layout_height="wrap_content"          android:text="RM"          app:layout_constraintEnd_toEndOf="@+id/yearBarChartAmount"          app:layout_constraintHorizontal_bias="0.17"          app:layout_constraintStart_toStartOf="@id/year_bar_chart_total"          app:layout_constraintTop_toBottomOf="@id/year_bar_chart_total"          tools:text="RM"/>      <TextView          android:id="@+id/yearBarChartAmount"          android:layout_width="wrap_content"          android:layout_height="wrap_content"          android:text="tOTAL"          app:layout_constraintHorizontal_bias="0.17"          app:layout_constraintStart_toEndOf="@id/yearBarChartCurrency"          app:layout_constraintTop_toBottomOf="@id/year_bar_chart_total"          tools:text="233.34"/>  </android.support.constraint.ConstraintLayout>][1]][1] 

Display current filters from view

We have a landing page that has a search block that has exposed filters for category and content type. We are using facets to add the exposed filters to the page. The exposed filters are displayed to the left of the result set in a two column layout. We would like to display the currently applied filters in the right column above the result set.

How would we display the currently applied filter right above the results set?

We are trying to replicate a search functionality similar to this Product Finder page. The currently applied filters are added right below the total number of results, but above the result set. I could not find any contrib modules that provide this.