Scott Miller
Scott Miller
  • 61
  • 3 139
SQL in Data Cloud
I had (and still do for the next few days 😉) the benefit of using #datacloud and I am making the most of it! While I appreciate the #tech and the #datamodel, I am most interested in it as someone who was a #marketing undergrad and business user in general. 💹
👨🏽‍💻Today I wanted to get more familiar with how #sql is used in Data Cloud and learn how powerful a feature it is. I was able to perform a #sqljoin which we know is not possible using #soql, although we have ways of using maps and subqueries to make up for that. There are definitely more opportunities for creating insights using these added features! #salesforce #salesforcedatacloud #salesforcedeveloper #salesforceapex #apexprogramming #customerdataplatform #salesforcecdp
Переглядів: 11

Відео

Discount Properties
Переглядів 62 місяці тому
Here, I show how I was able to use existing data to discover insights around property discounts. I created a simple formula calculating the difference between list price and value estimate, then created a list view to review it every day when the batch updates. What are some ways you can discover insights in your existing data?
Payment Processing
Переглядів 143 місяці тому
Here I demo a small payment processing application in @salesforce. It involves a few custom objects, a flow, and some #Apex running in the background the perform some calculations.
Marketing Opt in Generation with ChatGPT
Переглядів 93 місяці тому
I used ChatGPT in comparison to Google for a real world need: generating email and text Opt-in language for a website's landing page. As you will see in the video, Google provided a messy result page while ChatGPT gave an exact result, although it had to be modified once.
Video 22 Single Sign On in Salesforce
Переглядів 113 місяці тому
In my latest installment in the #salesforce #developer series, I walk through setting up #singlesignon with @salesforce and @Google. It's a pretty simple process that provides better security and more consistency when your team uses multiple applications with varying credentials.
Video 21 Salesforce Bulk Callout Bug Fix
Переглядів 163 місяці тому
This shows the correction of a bug I found resulting from the last process I created. The system created duplicate records under a certain scenario so I updated it to "clean" the records before upserting.
Video 20 Salesforce Bulk Apex
Переглядів 153 місяці тому
I'm back with the 20th video in my #salesforce #developer study series. In this one, I create a bulk #Apex #callout and either create or update properties, depending on whether they're already in the system. I also created a simple #salesforceflow that checks for duplicate zip codes and throws an error with the new flow error element.
Video 19 Einstein Prediction Builder
Переглядів 344 місяці тому
This is the 19th video in my #salesforce #developer series which is also the1st in a subseries of videos on #analytics and #machinelearning. Here, I walk through a basic (first) prediction of home sales prices in a portion of 3 bordering zip codes and about 2,500 homes. The first prediction while good by the rating given seemed to provide values at less than what they should be. While the predi...
Video 18 Salesforce Files Connect
Переглядів 1135 місяців тому
The latest video in the #SalesforceDeveloper series is about #Salesforce Files Connect! This is an extremely useful feature that allows for connecting Salesforce to an external file system like Google Drive, Box, or Microsoft OneDrive. Take a look at how I set it up to sync files locally, back them up to the cloud, and access them from Salesforce! #salesforcecertified #googlecloud #googledrive
Video 17 Conditionally Visible LWC
Переглядів 415 місяців тому
Video 17 in the @salesforce developer II certification series is a simple #lightningwebcomponent that only shows under a certain condition. This could be customized in a variety of ways but our example is fairly simple. Let me know if you have any questions!
Video 16 LWC Record Picker
Переглядів 655 місяців тому
In this video, I have created a search box in a #salesforce #lightningwebcomponent that queries for job skills against candidates that have applied for the current job (a record the component will live on). After selecting a choice (a job application), and clicking the button, an #apex method is called that creates a job interview for that candidate. I also discuss how I went around the restric...
Video 15 Change Data Capture
Переглядів 275 місяців тому
✨ In my latest video in the @salesforce developer series, I have part 2 of the process that I started yesterday (in video 14). To quickly recap, yesterday we created a #screenflow that collects job application info from a candidate in an #experiencebuilder site. That info was then routed into Salesforce where a custom object named Job Application was created. ✨ In today's continuation, I extend...
Video 14 Experience Sites
Переглядів 525 місяців тому
In my latest video, I present to you the 1st part of a 2 part series. Here, I create a simple Experience Builder site in #salesforce and add a #screenflow that collects potential applicants' job applications. The flow also checks the org to see if the contact already exists, and if so, attaches the new job application record to the existing one. If it does not exist, the flow creates a new cont...
Video 13 Deletions
Переглядів 235 місяців тому
This is part of the #Salesforce Developer Study Series where I demonstrate a simple deletion. First, I use a simple #Apex script to create the tasks that will be deleted, then I show the flow that will delete them. The flow queries the tasks associated with the triggered Opportunity, deletes them, then creates a postmortem case from that Opportunity. The goal for this is to keep the org clean a...
Video 12 Platform Events
Переглядів 335 місяців тому
In this video, I show how I used multiple components to develop a process that gets the sentiment of a new case in #Salesforce. I use a simple #Flask app that posts a new case to Salesforce and another method that creates a platform event in the same org. A flow is subscribed to the event and calls an #ApexMethod that calls #chatgpt to get the sentiment of the case request. This is the 12th vid...
Video 11 External Objects
Переглядів 366 місяців тому
Video 11 External Objects
Video 10 Complex Validation
Переглядів 396 місяців тому
Video 10 Complex Validation
Video 9 Rest Resource
Переглядів 246 місяців тому
Video 9 Rest Resource
Cloud Dominant Intro
Переглядів 76 місяців тому
Cloud Dominant Intro
Multi-Factor Authentication in Python
Переглядів 1026 місяців тому
Multi-Factor Authentication in Python
Video 9 Visualforce Callout
Переглядів 286 місяців тому
Video 9 Visualforce Callout
Video 8 Flow Orchestration
Переглядів 436 місяців тому
Video 8 Flow Orchestration
Video 7 Approval Process
Переглядів 346 місяців тому
Video 7 Approval Process
Video 6 Lead Conversion in Apex
Переглядів 427 місяців тому
Video 6 Lead Conversion in Apex
Video 5 Lightning Web Component
Переглядів 337 місяців тому
Video 5 Lightning Web Component
Video 4 Visualforce
Переглядів 557 місяців тому
Video 4 Visualforce
Video 3 Invocable Methods
Переглядів 687 місяців тому
Video 3 Invocable Methods
Video 2 Custom Metadata Types
Переглядів 907 місяців тому
Video 2 Custom Metadata Types
Video 1 - Apex Managed Sharing
Переглядів 3397 місяців тому
Video 1 - Apex Managed Sharing
Salesforce Account Lookup added to Custom Object Expense
Переглядів 288 місяців тому
Salesforce Account Lookup added to Custom Object Expense

КОМЕНТАРІ

  • @tadeocuchman9881
    @tadeocuchman9881 2 місяці тому

    Would be awesome to have all those solutions on github just to check easyer some things. Have a good one!

  • @tadeocuchman9881
    @tadeocuchman9881 2 місяці тому

    You didn't show the config of this :( I like the videos, great work anyway :)

    • @millertime6
      @millertime6 2 місяці тому

      It was intended to be high level. I’ll post it for you though!

    • @tadeocuchman9881
      @tadeocuchman9881 2 місяці тому

      @@millertime6 I would love it! Thanks! Because not so long ago I did a Implementation of callouts on triggers that every insert or update sended this to an external System. We did it everything by Apex. I wonder if it could be a way to go with external objects. I studied it, but I don't remember why we finally choose to do it custom. Anyways thanks :)

  • @MrJuan585
    @MrJuan585 3 місяці тому

    Getting ready for my retake, will go through your content, thank you for sharing.

    • @millertime6
      @millertime6 3 місяці тому

      Sure. I need to get back to this project!

  • @Hiturion
    @Hiturion 8 місяців тому

    Thank you Sir!

  • @pankajghasoliya5709
    @pankajghasoliya5709 9 місяців тому

    Hey Scott which app are you using for the code backup its look like an starndard Notes app on mac. But I am not able to see coloured font and line number in my Notes app. can please tell me how to do it.

  • @katrinamcguire5739
    @katrinamcguire5739 Рік тому

    💃 Promo*SM

  • @BishopWalters12
    @BishopWalters12 Рік тому

    I did a line of coke and hooked up with my friend's sister in that house. It's looking pretty good and I wish the new owners the best.

  • @natashamarks5412
    @natashamarks5412 Рік тому

    👍 🅿🆁🅾🅼🅾🆂🅼