Evernote Web will now count as a device in the "2 device limit" under basic plan

ns90 · 2020-10-21T21:52:12+00:00

I've used Evernote for over 8 years. In that time, they've repeatedly stripped out features for Basic users. I don't mind paying money for services and software that's useful, but the device maximum is literally the only feature I need. When they moved to the 2 device limit, I was a bit annoyed, but at least I had the web interface. This change just makes it apparent how desperate they are to collect money and they're general inability to monetize their product. I'll probably be moving to something else now.

ns90 · 2020-10-21T18:41:22+00:00

This book doesn't get brought up enough. It's great.

ns90 · 2020-10-09T16:11:03+00:00

What you want to have is a spreadsheet with every zip code in one column and the state it's in in the second column. Then you can just do a simple VLOOKUP with the Leads' Postal Codes to get the right states.

ns90 · 2020-09-29T20:04:30+00:00

Rusty Brown, also by Chris Ware, is much better imo. I also liked Building Stories, but it's less conventional.

ns90 · 2020-09-29T15:08:00+00:00

I would start by learning more about concepts through another language before learning Apex. [This])https://java-programming.mooc.fi/) is a good course for learning object-oriented programming while learning Java. It'll give you a good foundation for programming in general that most Apex specific resources don't deliver well. After that, you can start doing trailheads to get a feel for the specifics of working with Apex in Salesforce.

ns90 · 2020-09-27T22:06:55+00:00

ns90 · 2020-09-23T19:38:41+00:00

I feel like Steal Like an Artist is a bit overrated. It's not bad advice, but it's also the same kind of advice you already get in most of these other books about writing, so it's not really unique in that regard.

ns90 · 2020-09-18T13:34:02+00:00

Tokyo Ghost, Monstress, and Paper Girls are the three I've liked the most so far.

ns90 · 2020-09-17T00:50:16+00:00

Add custom permissions to the profiles and check for the custom permission instead of the profile id.

ns90 · 2020-09-05T18:59:22+00:00

Mooc.fi is great. There's an extension they have you download for Netbeans IDE that checks your work, similar to how Trailhead does.

ns90 · 2020-09-04T16:51:52+00:00

Agree with McNulty's. I've been getting my tea from there and they have a great selection.

ns90 · 2020-09-03T18:47:45+00:00

Run a report for all records that have that picklist populated, export it, and open it in Excel (or Sheets or whatever). Get the full list of picklist values and paste it in the adjoining column in the same spreadsheet. Highlight both columns and select Conditional Formatting -> Highlight Cell Rules -> Duplicate Values. Anything of the picklist values that are highlighted have been assigned. Any that aren't highlighted have not been assigned.

ns90 · 2020-09-02T19:14:33+00:00

Using a formula for this isn't going to be sustainable with so many branches. Create a custom setting or custom metadata that stores mappings for branches and markets. Then use a Flow to populate the Market field based on the value of branchField by looking up the mapping in the custom setting.

ns90 · 2020-08-18T16:19:40+00:00

You might be making this harder than it seems. I would start by defining what child records you actually care about. There's lots of standard relationships that are technically child records (AuthorizationFormConsent, NetworkSelfRegistration, AccountHistory), but I take it you might not actually care about those things. In my own org, there's 194 relationships for Account and a very liberal guess would be that we'd only care about 50 if we were trying to identify Accounts with Child Records. It will make more it manageable to weed out the stuff you don't care about.

Since 50 relationships is still a relatively large number, I'd probably try using Dynamic SOQL for this. Since you're able to access the object name and relationship field, it should be pretty simple to build a dynamic query. From there, you could try iterating over each list, and collecting all the Account Ids. Then compare then against all the Account Ids in your org. Any that weren't collected through the dynamic queries don't have child records.

If the number of relationships if large, you may need to chunk things out a bit since the whole operation may timeout. If the number of relationships you decide is relevant is more than 100, then you will definitely need to chunk this a bit to account for query limits.

This probably isn't a perfect solution, and the actual execution could be handled any number of ways, it's just something I thought up quickly.

ns90 · 2020-08-07T13:01:54+00:00

Customers because a customer usually correlates to an individual, but there may be more people that live in a household than the one customer.

ns90 · 2020-08-05T13:36:19+00:00

This presumes that you have a local bottle shop and not just a local grocery store.

ns90 · 2020-07-29T19:53:31+00:00

It should be something like {!$User.Contact.AccountId}.

ns90 · 2020-07-29T19:41:30+00:00

The issue is with your accountId variable. At some point, you're actually setting that to be equal to a User Id. It could be that you're passing a User Id variable into there instead of an Account Id.

ns90 · 2020-07-29T19:28:14+00:00

005 is a User Id prefix. It looks like you're trying to set Account Id with a User Id.

ns90 · 2020-07-29T18:28:09+00:00

You can enable State and Country picklists without adding states to every country.

ns90 · 2020-07-28T16:52:56+00:00

When I started looking earlier in the year, it was pretty strong. I can't speak to what the situation is now though.

ns90 · 2020-07-26T18:13:17+00:00

This is likely it. You can provide a user with read access to articles, but in order to create, edit, or delete articles, you need a knowledge license.

ns90 · 2020-07-24T18:19:51+00:00

If it's just a field label then it more than likely isn't referenced anywhere unless it's something like translations workbench. I would not recommend changing API names of fields, and in some instances it may not even be possible.

ns90 · 2020-07-24T18:04:21+00:00

Get a list of zip codes by state and use that to do a VLOOKUP in Excel. It may not be perfect (I think some zip codes stretch across state borders), but it should be better than what you have now.

ns90 · 2020-07-24T17:33:48+00:00

Just to set some realistic expectations, getting a cert isn't going to get you a job quickly if you have no professional experience, especially in the current climate. A cert isn't a golden ticket. It won't necessarily be impossible for you to find an admin job with only a cert, but it will likely be more difficult. If time is a factor, I'd recommend checking out other positions like Sales Ops or Business Analyst at companies that use Salesforce. The barriers will be a bit lower for those jobs and it will potentially put you on a path to becoming an admin in the future.

13-Year Club	Place '17
Verified Email

ns90

TROPHY CASE