gels | use koa2 , mysql , graphql & typescript , to build micro | Application Framework library

I believe your situation and goal as follows.

• As the search values, there are the cells "R7:S7".
• There are the data range in the cells "B2:O".
  • Row 2 is the header row.
  • Row 3 is the empty row.
  • From row 4, it the data range.
• You want to achieve the following flow using Google Apps Script.
  1. Search the column from the cell "S7".
  2. Split the value of "R7" for each character.
  3. Retrieve the rows from the retrieved column, which was retrieved by "S7", using the splitted values of "R7"
  4. Reduce 1 from the value of the right side of the retrieved column.

In order to achieve this, I would like to propose the following sample script. The flow of this script is as follows.

1. Retrieve the values from the cells "R7:S7".
2. Retrieve the values from the cells "B2:O".
3. Retrieve the header row.
4. Create an object for searching each character from the cell "R7".
5. Reduce 1 from the the value of the right side of the retrieved column.
6. Put the calculated values to the column.

Please copy and paste the following script to the script editor of the container-bound script of Spreadsheet, and set the cells "R7:S7" and run the function of StockUpdate().

Here is the solution. add below CSS and JS to achieve your goal.

CSS

It's just because of position: relative.

EXPLAINATION

added position: relative CSS to the .dropdown-item class because your ::after CSS not works without position: relative.

Removed position: relative CSS from the .dropdown-submenu class because Its calculate top from its height.

Use either of these two methods: Both worked in vs 2019.

My reasons for using Colab

• Work from any computers. All notebooks are saved in Google Drive.
• Don't need to worry that conda create env will clutter your directories
• Share to someone, or everyone easily. Just like a Google Doc.
• Automatic history and versioning
• Free GPU (and TPU as of 2018-09-29)
• Form widgets are simple and easier to use
• Good defaults
  • %matplotlib inline not needed
  • collapsible outline (no need to install)
  • Cleaner interface (I prefer it than vanilla Jupyter)

Your idea is good. One realization of it then would be

gels is actually a function from LAPACK (Linear Algebra Package) and stands for GEneralalized Least Squares meaning that it works on general matrices:

General matrix

A general real or complex m by n matrix is represented by a real or complex matrix of size (m, n).

IIUC, this is what you're looking for. dict comprehension with enumerate. This will also reduce the amount of manual labor required so long as your list is in the order you want.

You are passing a list here, uClient = uReq(my_urls) as my_urls where a string is required.
You need to pass the individual element of the list i.e. the strings.

Here is the edited code that works for multiple urls.

UPDATED CODE (to get all items):