The Ultimate Windows Utility

The Ultimate Windows Utility link

irm christitus.com/win | iex

Windows Problem Steps Recorder

Windows Problem Steps Recorder (PSR) is a built-in Windows utility that automatically captures screenshots and annotates steps to help troubleshoot issues or document processes.

Google Search Hack

linux -mint +ubuntu "best"

• - exclude phrase
• + include phrase
• "" find exact match

Generate QR Code in MS Word

• Press CTRL + F9
• Inside the braces, type: {displaybarcode”your-website.domain”qr\q3}
• Press ALT + F9 to generate the QR code

Google Form using App Script

• Create a Google Sheet with the following headers: First Name, Last Name, DoB
• Create a Google Form with the exact headers as Google Sheet headers:  First Name, Last Name, DoB
• In Google Form, create an App Script Trigger as follows - this code will link the data in the Form to the created Google Sheet:

function onFormSubmit(event)

{

record_array = []

var form = FormApp.openById('Form Id in Edit Mode'); // Form ID

var formResponses = form.getResponses();

var formCount = formResponses.length;

// get the latest form response

var formResponse = formResponses[formCount - 1];

var itemResponses = formResponse.getItemResponses();

for (var j = 0; j < itemResponses.length; j++) {

var itemResponse = itemResponses[j];

var title = itemResponse.getItem().getTitle();

var answer = itemResponse.getResponse();

Logger.log(title);

Logger.log(answer);

record_array.push(answer);

}

AddRecord(record_array[0], record_array[1], record_array[2]);

}

function AddRecord(first_name, last_name, dob) {

var url = 'https://'; //URL OF GOOGLE SHEET;

var ss= SpreadsheetApp.openByUrl(url);

var dataSheet = ss.getSheetByName("Sheet1");

dataSheet.appendRow([first_name, last_name, dob, new Date()]);

}

 

Using JS in GoogleSheets

function func() 
{

    // sheet initial
    var app= SpreadsheetApp;
    var activeSheet = app.getActiveSpreadsheet().getActiveSheet();

    // get value
    var cell = activeSheet.getRange(row, col).getValue();

    // set value
    activeSheet.getRange(row, col).setValue(cell);

    // console log
    Logger.log (cell);
}

NU1101 Errors in Blazor Projects

These NU1101 errors in your Blazor project suggest that the required NuGet packages aren't being found in the configured sources. To resolve this, Update NuGet Package Sources in Visual Studio:

• Go to Tools > Options > NuGet Package Manager > Package Sources
• Add or enable the official NuGet source:
• Name:   nuget.org
• Source: https://api.nuget.org/v3/index.json