surveyor | A simple survey tool for Cb Response and Cb Threat Hunter

I've developed a survey web app. The app collects data from a survey in a html form, and the user has to upload several photos. The form is posted to a php script that stores the photos on the server and the rest of the form is stored in a MySQL database. Everything is working, but sometimes the surveyors don't have the best internet connection, and we experience a connection loss. Since the survey is time consuming, losing data due to a bad internet connection would be pretty bad. Is there someway to store all the data locally in case of losing the internet connection?

/Carl

The first part of the program is to retrieve the employee user ID (or signature) from an API URL once the name has been entered. (Which I have done)

The second part, the user will enter a specific "to" and "from" date.

Using the signature obtained from the first part and the dates that the user enters, the program should pass this information to an API address and obtain information accordingly.

My question is that I am not sure how to pass the obtained signature to the new API address + the "to" and "from" date.

The first part of the program to retrieve the signature (works perfectly):

I would like to get the result in the table, where the data comes from my userform.

Column H comprises the sum of column G from my active worksheet and column AD from my external worksheet, which is "Formulas".

I have the userform, to fill my whole row in the table as I input some data in this userform.

Column H won't be input directly from the Userform, because it includes the formula mentioned above.

I want to auto-populate column H, when making input to adjacent column G and also column L.

This auto-population must be based on the formula described above, where the column AD from the "Formulas" sheet is based on the IF statement as shown in the picture below. This IF statement is related to column L from my active worksheet, determining the integer value ranges.

For this purpose, I used the following code for making the input from my userform. Modifying it further by inserting the potential solution for the aforementioned column H auto-population.

When communicating with a serial-over-USB device (a GNS FM9 receiver for getting road traffic alerts) by using libserial's SerialStream object, I found out that not all characters coming from the device are in fact being read. This is what I always get served:

Good afternoon,

I have been struggling with synchronization with the Outlook calendar with MS Excel. I want exactly to have my cells with date appeared in this calendar as the events.

The best code, which I found for this purpose comes from here:

Excel Create an Outlook calendar event

However, the question is closed, as the code is incomplete.

Trying this code on my example

I've made select query which populates the following output -

If we see at the rows above we can see 3 sections here (separated by the dashed line). Each row is unique by 3 attributes (dpt, qn and option_choice.id) If we look at the votes column for each section we can see -

section 1: (3+62+1)=66
section 2: (9+1+28+25)=63
section 3: (20+29+1+2+8)=60

That means questions 1,2 and 3 got 66, 63 and 60 votes respectively. I want to add a 5th column say total_votes just right after the votes which will represent the total votes of each group like this -

I've already tried with the cumulative sum technique Can anyone help how can I do this? Here is my working query (that produced the result of the first image) -

I'm trying to clean up job title data using the formula below:

i want to know if regex is able to extract the email from the following strings ?

the following condition is .*@.*match with all string. to some strings, my pattern is worked, but the rest of them are not.

i want to match all strings match with email pattern include all domain like (some-url.com) or (some-url.co.id)

I have a database similar to the following. I'm looking to count the appointed, emergency and surveyor job types that occured in working hours. Also counting the No Access and Follow On Event Summary.

The criteria is that the jobs we are looking for are ArrivedDAY NOT IN ('Saturday','Sunday) and if its a monday to friday job that the ArrTime is betweeen 08:00:00 - 16:30:00

I've managed to get the count part down but excluding the data i don't need is proving to be difficult, a point in the right direction would be appreciated.

This is on the SQL Server Studio

Cheers Matt