Formulas – Google sheets, creating a drop-down list based on user input

I'm working on a planning system for a very specific process. I will send shifts to my employees and, depending on the outcome of their contributions, I want to create a drop-down menu for employees who have declared being able to work in a is what i'm talking about

G2: The E2 are examples of employees, and assuming that only fred and test said they could work on June 10th, the drop-down menu for this shift should show only fred and test. At the present time, it is set to display them all, but I want to create a custom formula that will allow me to check if the cell under their name, next to the corresponding extension, is empty. If this is not the case, add their name to the drop-down list. . If no one can take it, the drop-down menu should be empty. The reason why I check if it is empty, is because I do not want to impose restrictions at the entrance of the cell, because I have a lot of employees and they have them. forget or do not respect them.

How could I get ONLY the employees who said that they could work to appear in the drop-down menu, so that I can easily see who wants to work on each shift.

usability – drop-down list with advanced search

I create a control to allow users to select an item from a list. The number of items can vary enormously – from a handful to a millions.

A drop-down menu with autocompletion the functionality seemed like a wise choice. If there are few items, a user can click on the arrow and select the appropriate one. if there are many, she can quickly find the right one by typing the article's name.

However, sometimes that is not enough. With many thousands of items, a user may need more advanced search criteria to find what she is looking for. Currently, this is implemented as a search button following the field that opens a dialog box with additional search criteria:

Model of the current dropdown control

The user enters criteria and clicks on the Search! the drop-down menu is filled with the results of the search.

Unfortunately, this approach is problematic. Some that I can think of are:

  • There is no visual indication that drop-down menus and filters are linked
  • The search results are not immediately visible
  • The drop-down list remains filtered after closing the dialog box, without any indication to the user

So, I'm looking for suggestions. Is there a common way of doing this that I have missed? Should I rethink advanced filters? Can this be remedied simply by adding visual cues?

css – Ng-Bootstrap active pills to add without displaying the drop-down menu

I used my Angular-6 project for the ng-bootstrap and I used the ngbootstrap pills, I tried to add active pills to the drop-down icon with the Button removal option, but it does not work, everyone knows how to do it correctly.

here with stack blitz code

it's my .css code

.nav-pills,> .nav-link {
    color: #fff;
    background-color: #262262;

a:after {
  content: url('');
  height: 0;
  width: 0;
  border-left: 6px solid transparent;
  border-right: 6px solid transparent;
  border-bottom: 6px solid #fff;
  position: absolute;
  bottom: -1px;
  left: 50%;
  margin: 0 0 0 -3px;
  z-index: 100;

I tried to do like this picture

I tried to do like this picture

Thank you

How to remove unnecessary productions when converting dropdown controllers to grammar without context

Here is the half-resolved example of the problem.

View SharePoint 2010 Subsite Links drop-down link

enter the description of the image here

I have a main site (Schedule) that has the option "Show subsites" enabled in the navigation settings. All links work properly, except for one of the sub-sites containing a "Web site not found", "http 404". However, if I click on the parent site and select all the content of the site, the link under the sites and workspaces works perfectly. I notice that the link in the drop-down menu has /sitepages/home.aspx after the name of the subsite, while the link under sites and workspaces ends with the only name of the subsite. Is it possible to manually modify the link from the drop-down menu so that it matches the link of sites and workspaces? I have gone through all the parameters and I still can not find anything that allows this. Thanks in advance!

html – How to feed 2 dropdwon dropdown lists with jquery and two json lists

  $.getJSON('SIGPLAM2/javaScript/lista-regiao-programas.json', function(data){
	var items = ();
	var options = '';

    $.each(data, function(key, val){
	  options += '';

	  var options_programas = '';
	  var str = "";

	  $("#regioes option:selected").each(function(){
		str += $(this).text();

	  $.each(data, function(key, val){
		if(val.nome == str){
		  $.each(val.cidades, function(key_city, val_city){
			options_programas += '';


Create a drop-down menu

Hello everyone, I have this page
and I want the "Solutions" section to contain a drop-down menu that includes "Dental Billing" "Services" "Etc"
how could I do it?

I wanted something like how the drop-down menu is in "Solutions"

Best practice in Global Dropdown Placeholder

In general I recommend double labeling for selectors, with a fixed and permanent category prefix outside the form itself – in your example, it would be "Fee Option" – and a dynamic status label within the form to indicate its current status. Think of this as a call and answer or question and answer scheme; "Fee option?" – "Monthly | Annual | Lump Sum" (or whatever the choice of your application). Only omit the point of unnecessary inquiry. Punctuation in the labeling of entries is not usually recommended.

This system of call response labeling gives your user an instant overview of the completion status of a series of input fields, that it's acting on drop-down selectors, date selectors, or forms / text entry fields. Avoid duplication, however: do not use identical text for prefix and substitution text. Make sure the labeling semantics comply with the schema (category prefix) – (editable current state) consistently.

Once you have established this labeling scheme, with significant prefix titles, design a consistent indicator for the indeterminate states of your selectors.

For date or combo selectors (anything that has a finite choice constrained and constrained), see what your global user interface looks like when an indeterminate state of all input fields indicates "Select"; this should usually be understandable a selection has not been made yet. If input is required, use stronger rules. Google Material will offer suggestions combining visual and verbal cues to indicate when a selection is critical. In addition, prevent your user from continuing or completing the installation routine (which seems to be what you are describing).

To return to your example, the landing state of the input field would be …

Fee Option (Select)

… where the bracketed text looks like a label on the form itself and the text preceding the category label. Do not use prefix duplicates like "Fee Option" – "(Fee Option)". You see what I mean by call and answer? Undetermined states are marked with a name as a category prefix and followed by a verb as an action call label (CTA) on the field. entrance itself. Use the same thing for the date or time selectors; "Start Date" – "Select".

Once your user makes a selection, the input field changes to its finished state …

Fee option (monthly payment)

… or something like that. If the selection is critical, remove all markers of this criticality such as the red frame of the field, the addition of asterisks to the category label, the explicit labeling "Required" – and the complete unlock (for example, "Submit").

With text input or combo boxes, that is, input fields with theoretically infinite choices for input such as user name or address, use a sample text from index inside the form …

Address (for example. 123 Hamilton Street)

… rather than repeating "Address" as an index, which is useless. I hope it helped you!

configurable product – Can not change the type of hint attribute to magento2.2 dropdown list

I'm using magento 2.2, I've created a configurable product, but on my product page, it continues to display samples although I've set a drop-down menu in it. ;attribute.

set of attributes = the most expensive,
attribute = shoes3

Steps to reproduce

    Create new configurable product based attribute from precondition
    Check this product on frontend - options displays as visual swatches
    Go to attribute and change "Catalog Input Type for Store Owner" = Dropdown
    Clear Cache
    Check product page on frontend

Expected result
Options still displays as visual swatches
Actual result
Options is shown as dropdown

enter the description of the image here


enter the description of the image here

enter the description of the image here

usability – The View option is both mandatory and used previously in the drop-down list

I realize that this is probably not the best way to deal with the problem, but I need to advance in a solution to an existing model – and a drop-down list has been used.

In this situation, the user must add multiple fields to a table. Some are mandatory fields, others are not … each can only be used once.

The request consists of indicating the required elements in the drop-down list and indicating if they have already been added.

What is the best option for this?

My first thought is to use a red asterisk next to the required item and replace it with a checkmark when adding the previous one as such:

| dropdown ▼ |
| * option 1 |
| * option 2 |
| ✓ option 3 |
|   option 4 |
| ✓ option 5 |
| * option 6 |