lukethacoder

Up Accounts API

1. Create a new Sheet (or use an existing one)
2. Tools -> Script Editor
3. Copy + Paste the attached .js code snippet (Save)
4. Back on the sheet, paste in =FetchAccounts("up:yeah:THE_REST_OF_YOUR_TOKEN_HERE", 0)
5. Profit

Don't have an API token, get one here.

lukethacoder

function removeDuplicateObjectsByKey(array, fieldToDuplicateCheck) {
  const newArray = []
  const arrayKeys = []

  array.forEach((item) => {
    // check if we don't already have the value within the arrayKeys array
    if (!arrayKeys.includes(item[fieldToDuplicateCheck])) {
      // push this value to the arrayKeys array
      arrayKeys.push(item[fieldToDuplicateCheck])
      // push this object to the newArray array

lukethacoder

[
  {
    "name": "accessible-icon",
    "type": "lab",
    "unicode": ""
  },
  {
    "name": "american-sign-language-interpreting",
    "type": "la",
    "unicode": ""

lukethacoder

/**
 * @description Inverse the Object keys/values
 * @param {object} obj
 */
export function inverseObjectKeysAndValues(obj: { [key: string]: any }) {
  return Object.keys(obj).reduce(
    (acc, curr) => ({
      ...acc,
      [obj[curr].toString()]: curr,
    }),

lukethacoder

List<Network> communities = [ SELECT Id, Name, UrlPathPrefix, Status FROM Network ];

for (Network community : communities) {
    System.debug(community.Name + ': ' + community);
}

// or via Connect API

List<ConnectApi.Community> communitiesConnect = ConnectApi.Communities.getCommunities().communities;
for ( ConnectApi.Community community : communitiesConnect) {

lukethacoder

mysql -u username -p database_name < file.sql

lukethacoder

document.querySelectorAll('*').forEach(el => el.contentEditable = true)

lukethacoder

[
  {
    "code": "PUB",
    "label": "Australian Public Company"
  },
  {
    "code": "PRV",
    "label": "Australian Private Company"
  },
  {

lukethacoder

List<PicklistEntry> fields = Account.SObjectType.getDescribe().fields.getMap().get('Type').getDescribe().getPicklistValues();
for (PicklistEntry picklistEntry : fields) {
    System.debug(picklistEntry.getLabel() + ' with value: ' + picklistEntry.getValue());
}

lukethacoder

Datetime.valueOfGmt(String.valueOf(Datetime.now()));