gareth | review system for git , using a controlled fetch methodology

I am not able to get the inputRef.current.focus() to fire without using setTimeout. This seems like a bug, but I'm not sure if it is in React or MaterialUI.

See a demo here: https://codesandbox.io/s/goofy-gareth-lkmq3?file=/src/App.js

I'm trying to extract ref name from hash and pass it to scrollIntoView without case/switch.

Suggestions how achieve this simple/best way?

Full working code with comments here.

Stupid but works

I am using selectionStart and selectionEnd in order to get the starting and ending point of a text selection.

Code: https://codesandbox.io/s/busy-gareth-mr04o

However, I am struggling to defined the type of the event on which they can be called on. If I use any, the code works properly but I would prefer to know the right event.

I tried with these types: Element React.SyntheticEvent with no luck

I'm writing a job planner and the following is an sqlite3 query result. What I'm wanting is to group the data by engineer (e.g. 'Dan') and whether they have any jobs (the last column) or are on holiday (the 2nd to last column).

So ideally I'd probably want a dict with a key for each engineer, and a key for each day, and either:

• a list of jobs for that day
• that they are on holiday
• they have no jobs that day

I've tried the following

I'm trying to get the url of the final destination of a specific website, but all the templates I've found to use as a function in my spreadsheet, only return the initial link:

https://stackoverflow.com/a/50733029

Attempt

After reading a large json file and capturing only the 'text' column, I would like to add a column to dataframe and set all rows to a specific value:

I cannot figure out why this code does not "detect" the activex button (created with Siddarth's help in here: How to rename a newly created ActiveX button?). I see the button in front of me and its properties window looks like this.

I even tried to delete just one button with ActiveSheet.Shapes("CommandButton1").Delete, but that line results in an error window with a text saying something like "An item with that name wasn't found.". => Apparently I am not using the right name to address the button.

The code I am using is based on used Gareth's code in Word vba delete button not working

I added an if-condition to exclude "good" buttons with names set in snake case (hence "_"), i. e. the names were defined by me.

I am creating a page that is a slideshow with several images and a parallax scrolling effect. The scrolling is working fine, however I want to have the buttons for the music control fixed on the top, however the buttons will not stay fixed no matter what I do.
my images are set up like this:

I am trying to take a random name from a list and then once it has been printed, I want to remove it from that list so that it isn't used ever again. I want to use the pop method but I'm not sure how to take a random name from the list since the pop method (to my knowledge) only accepts integers.

Here is my code: