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

Connect PowerBI to SQL Server - TrustServerCertificate

Under the server that Power BI installed, 

• Go to System Properties -> Advanced -> Environment Variables 
• Add this Variable Name PBI_SQL_TRUSTED_SERVERS
• Set the Variable Value to the servers that are trying to reach out to this Power BI box
• Restart the machine

Setup Windows Local Account without the Internet

During the Windows setup, 

• On the WiFi screen, press SHIFT + F10 or FN + SHIFT + F10 
• This will open the command prompt window with administrator rights 
• Type: start ms-cxh:localonly and hit Enter 

Analysis Service in Power BI Report Server

 We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly... link

Setup PowerShell Universal Dashboard

# Run PowerShell as Administrator
Install-Module -Name UniversalDashboard.Community

# Check PowerShellGet version
Get-Module -Name PowerShellGet -ListAvailable

# If you do not have PowerShellGet version 2.0 or higher
Install-Module -Name PowerShellGet -Force

# Check PowerShellGet version
Get-Module -Name PowerShellGet -ListAvailable

# Delete old version of PowerShellGet
    # for x64
    Get-ChildItem -Path 'C:\Program Files\WindowsPowerShell\Modules\PowerShellGet'
    Remove-Item -Path 'C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1' -Recurse -Force

    # for x86
    Get-ChildItem -Path 'C:\Program Files (x86)\WindowsPowerShell\Modules\PowerShellGet'
    Remove-Item -Path 'C:\Program Files (x86)\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1' -Recurse -Force

# Copy new version from x64 to x86
Copy-Item -Path 'C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\' -Destination 'C:\Program Files (x86)\WindowsPowerShell\Modules\PowerShellGet\'

# Copy new version from x86 to x64
Copy-Item -Path 'C:\Program Files (x86)\WindowsPowerShell\Modules\PowerShellGet\' -Destination 'C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\'

# Close the PowerShell session and reopen it
# Install the universal dashboard community module
# If you run into a command already available error, explicitly allow the new module to override the existing commands by using the -AllowClobber
Install-Module -Name UniversalDashboard.Community -AllowClobber

# Check
Get-Module UniversalDashboard.Community

Activate Office Permanently

• Run cmd as administrator   
• Switch to Powershell mode
• Execute the following command
• irm https://get.activated.win | iex