Function Name | Syntax | Purpose |
---|---|---|
SUM | ||
SUMX | ||
DIVIDE | ||
ALL |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Javascript to show Warning, Info or Error messages depending on boolean field status | |
function ShowAlertMessage(executionContext) { | |
var formContext = executionContext.getFormContext(); | |
var warningId = "warningId001"; | |
var alertWarningField = formContext.getAttribute('XXX').getValue(); | |
var errorId = "errorId001"; |
Syntax | Explanation |
---|---|
var formContext = executionContext.getFormContext() |
Gets form's execution context |
var zip = formContext.getAttribute('gir_zipcode').getValue() |
Extracts fields value |
var countryTab = formContext.ui.tabs.get('country_tab') |
Gets Tabs reference |
countryTab.setVisible(false) |
Hides the tab |
Xrm.Navigation.openWebResource("new_girishhome.html") |
Opens Web resource |
var args = formContext.getEventArgs() |
Get event arguments |
formContext.getAttribute("to").setValue(null) |
Set field values null |
formContext.getControl("cities").removeOption(10001) |
Removes option from option set |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Hide Tab based on value selection in Choice column field */ | |
function HideTabBasedOnField(){ | |
// Replace choice field name with your value | |
if(Xrm.Page.getAttribute("...choicefieldname... ").getValue() !=1){ | |
// Replace tab name with your value | |
Xrm.Page.ui.tabs.get("...tabname...").setVisible(false); |
Title | Link |
---|---|
Northwind Database |
https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs |
Worldwide Importers Database |
https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 |
Adventure Works Database |
https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks |
Power BI Desktop Samples |
https://github.com/microsoft/powerbi-desktop-samples/tree/main |
Adventure Works Sample Excel |
https://github.com/microsoft/powerbi-desktop-samples/tree/main/AdventureWorks%20Sales%20Sample |
Technology | Shortcut | Purpose |
---|---|---|
Excel |
Ctrl - |
Delete row from Table |
Excel |
Ctrl Shift + |
Add row in Table |
Word PowerPoint Outlook OneNote |
Alt Shift Up/Down |
Select item and seamlessly move up and down in a table content |
Power Toys - Always on Top |
Win Ctrl T |
Pin a Window |
Power Toys - Text Extractor |
Win Shift T |
Extracts text from Image |
Power Toys - Color Picker |
Win Shift C |
Opens Color Picker |
Power Toys - Mouse Highlighter |
Win Shift H |
Opens Mouse Highlighter. Click of mouse generates a visual effect on mouse pointer |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- | |
doe: "a deer, a female deer" | |
ray: "a drop of golden sun" | |
pi: 3.14159 | |
xmas: true | |
french-hens: 3 | |
calling-birds: | |
- huey | |
- dewey | |
- louie |
NewerOlder