subcontractor | rvm aware process launcher for foreman

I'm currently trying to develop a spreadsheet that helps me write down malfunctioned convectors/windows inside my building (im working in the facility-management-business). Because each Floor has nearly 140 Windows and 80 convectors and we dont have a standardised way of writing down the problems/defects i wanna create a excel-sheet in Excel 2016.

Now because i have a touchscreen-laptop i wanna do me a favor and just press on the different cells in each category if there is a problem (A = broken motor, B = leakage in the pipe-system, ect.) and change its color.

If there is no problem, the Index-Color is green, if there is a problem, its red (darkred).

Now, i have the following VBA-script running, which adds a Cells-Value of 1 to each Cell and via Data-format ";;;" i hide it from being visible + switch the colors:

I have a vertical timeline where I need the circular markers to be on the center line. My issue is that the markers for the block-items on the right appear centered on the timeline, however the ones on the left do not. Instead they are to the left of the timeline date of the block items on the left. This is probably a simple fix, but I am spent on ideas at this point. Below is my ReactJS code for my Experience.js file and my App.Css file.

Timeline issue photo

Experience.JS

Im trying to get some specific data from a website my workplace uses, however, I cannot figure out on how to get that specific data. Here is a snippet of the code from the website:

Im trying to get some specific data from a website my workplace uses, however, I cannot figure out on how to get some specific data to be written to a worksheet. I have written a code, which successfully opens the webpage and loops through the data on that page, I just need help with the last part of the code.

I have a view called black_screen that contains an activity indicator . I made the UIView Hidden on the start of viewDidLoad() function. Now I want to set the Hidden attribute to false once I press on a button to call a function called Submitt_TouchUpInside. My problem is that the code for showing the UIView does not work until my submit() function is done executing and I am not sure why.

Regarding the MainWindow screen below, that I want to insert, update, and delete data with DataGrid. I've made insert and delete options for data but I have a problem with the update option when i run it an error has occurred. And the SubID(primary key) in the GridData, I want it to automatically count the number of rows (1,2,3, ...) when i insert new value or when delete a value because as shown below that the mainwindow display the when i insert a new value the the row=35 which is not in order way. Note: I have linked the combobox(Subcontractor) with the database that on each selection will display the data in textboxes.

The MainWindow Display

The MainWindow.cs.xaml

With this database I used and linking it to a combobox, I don't know what the problem is with non-organized combobox content(some value in line and the others with enter) so how can this be fixed? And I linked the combobox value to textboxes, so when I select the database value from combobox to display the information related to that value in the textboxs, an error message occur (specified cast is not valid). In another word, the information doesn't appear in the textboxs when I run the mainwindow.

The Database I used.

The combobox looks like this when I try to select a value(non-organized).

The MainWindow desktop app Display.

The MainWindow.xaml.cs Code

I have a Google Sheet that is capturing Google Form responses with, of course, each response recorded on its own row. Quick blurb on the form itself: it's capturing a daily log for a construction project that can have up to 6 subcontractors working on it on any given day.
Assuming it would be impossible to format the data as it comes in on the Form Responses tab, I created a second tab in the sheet to pull data from the Form Responses tab, thus allowing me to adjust the format.
Ideally, I want the data to fit in the "viewable window" so that the user doesn't have to scroll all the way over every time, and so I want to put the 'Sub' responses into a mini-grid format. The sheet currently looks like this:

I want the form to auto populate the sheet to look like this (the timestamp of the form response being the unique identifier):

Is there a formula that can essentially query the data from the Form Responses tab and transpose a section of it? Many many thanks in advance for any help.

I have 2 tables, subcontractors and users.

Each table has a column named "district".

I have a question in my form in which I want the user to select a district. I want the form to show the dropdown options of "district" based on the "district" of the user that is logged in.

When I code my model with my "$this->session->userdata" code the dropdown options just show up blank.

When I put in the code to specify the "district" then the dropdown box works correctly and only shows the district options from the subcontractors table.

My objective is for the form dropdown to only show the options that match the same district as the user that is logged in.

FOR EXAMPLE: When "James" is logged in, when he's filling out the form, I want every "sub_name" that has the same "district" as james to show up in a dropdown box.

There will be about 30 different users using the system so each user that logs in will need to see a different set of district variables when they log in.

Your help is greatly appreciated.

--

MODEL (does not work - dropdown options show up blank)