This file contains 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
// Use Gists to store code you would like to remember later on | |
console.log(window); // log the "window" object to the console |
This file contains 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
{ | |
"data": [ | |
{ | |
"departmentId": 2682032, | |
"departmentName": "HR", | |
"isEnabled": "Y", | |
"cc": "rgb(19,164,138)", | |
"deptHeadObjId": 8, | |
"deptHeadObjRefId": 2115966, | |
"deptHeadName": "Scott Macmeekin", |
This file contains 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
=IF(accounts[name] = "",0,COUNTROWS ( FILTER (accounts, accounts[name] = EARLIER (accounts[name] )))) |
This file contains 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
EVALUATE | |
CALCULATETABLE(<target_table>,<condition1, condition2, condition3) | |
Note | |
Conditions can use related tables - eg RelatedTableName[ZoomInfo Company ID] <> "" | |
Example | |
EVALUATE | |
CALCULATETABLE(account,accounts[accountid] <> "") |
This file contains 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
EVALUATE | |
SELECTCOLUMNS( | |
// define table with condition | |
CALCULATETABLE(accounts, | |
accounts[accountid] <> "" | |
), | |
// columns to pull in | |
"a2c_zoominfoaccountid" , accounts[a2c_zoominfoaccountid], | |
"accountid" , accounts[accountid], |
This file contains 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
EVALUATE | |
SELECTCOLUMNS( | |
// define table with condition | |
CALCULATETABLE(contacts, | |
contacts[a2c_zoominfocontactid] <> "" | |
), | |
// columns to pull in | |
"contactid" , contacts[contactid], | |
"email" , contacts[emailaddress1], |
This file contains 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
EVALUATE | |
SELECTCOLUMNS( | |
// define table with condition | |
CALCULATETABLE(contacts, | |
contacts[a2c_zoominfocontactid] <> "" | |
), | |
// columns to pull in | |
"a2c_zoominfocontactid" , contacts[a2c_zoominfocontactid], | |
"contactid" , contacts[contactid], |
This file contains 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
<filter type="and"> | |
<condition attribute="statecode" operator="eq" value="0" /> | |
</filter> |
This file contains 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
End of Line characters for search and replace | |
LF character : \n | |
CR character : \r | |
Show in Notepad++ | |
View > Show Symbols > All Characters |