Introduction In this article, we will show you how to integrate Salesforce with Google Translate. You will learn how to translate text in Salesforce using a Lightning Web Component and the Google Translation API. Here’s a sample of what we will be developing. You might think of looking for a package on the AppExchange, but […]
Introduction In the Spring’20 release Salesforce finally heard our prayers and provided the ability to: Declare Row Level Formulas. Filter reports using Field to Field comparison (Generally Available). Count unique values in report results (Generally Available). This blog’s goal is to review each one of this new, AWESOME!, features and take a look at some […]
Introduction This tutorial assumes that you already know what a Callout is, and are familiarized with terms like: endpoint, Restful services, SOAP and http requests operations (get, post, put and delete). In conclusion, we are going to show you how to make an http request with Salesforce to consume a web service, and how to […]
The Builder Pattern is a software design pattern intended to add more abstraction to the instantiation of Objects, where you can preset certain steps of the process simply by, setting some properties with default values coherent with the context of the execution. Say you have a Custom Object with several required fields, but you need […]
When we start working in a project that was previously developed by another company, we could fall in the disgrace that the code was written by more than one developer without agreeing in the same practices, something that we can fix with some regular expressions (regex) within Atom. In the examples below I decided how the code should looks like […]
Salesforce-Python Problem: Two weeks ago or maybe more our clients from California requested a script to parse a xml file (Salesforce-Python). After parsing the xml we had to get some data from it and update some Salesforce records using that data. Salesforce-Python: Why Python? Python is a short syntax language (fast coding). We didn’t have to […]
Automating Git tasks is not about hooks or aliases, that’s a story for another day.
Let’s imagine for a second that you are a lazy person, not too lazy, but lazy enough to get a little upset every time you need to, let’s say, update your beautiful working repository or even cheat on your SEO configuration by mentioning ‘Automating’ out of nowhere (see what I did here?). You can’t mess it up, because you and your team are so proud of the beautiful branching model you achieved and you treat merge commits as if they were bitten by a zombie.
But, of course, to achieve that ‘Good Practices of the Month’ badge and be delighted with the output of your git log you need to do some tricky stuff on a daily basis.
Let’s continue with our imagination exercise, and imagine this workflow:
- You work in a feature branch for every story
- That branch is checked out from ‘develop’
- All the commits created in the feature branch must be taken to ‘develop’ at the time they’re created
- Obviously, those commits, need to be synched with the ‘upstream’ and ‘origin’ remotes
- Once that feature branch is done it is merged with a third one, ‘staging’, ‘qa’, ‘release’, whatever
- You hate, absolutely hate, merge commits
So, that comes with some tricky implications: if you don’t want merges in your ‘develop’ branch, and don’t want to get the ‘develop’ commits to the feature (since they might have zero relation with your work) you’ll need to git rebase your changes from the feature to ‘develop’ instead of just merging it.
That means, for example, we need to:1234git fetch upstreamgit merge-base develop upstream/developgit reset --hard <SHA-returned-by-the last command>git merge upstream/develop
That’s four commands every time you want to get the latest changes.
Remember: You are lazy.
But wait! There’s hope, because, in case you didn’t notice: git is awesome.
So, here’s the thing, git has this awesome feature, where you can write a script, add it to your PATH and make git to run it. Just like that.
First, you need a file named ‘git-whatever’ it doesn’t need an extension, and must be named with the ‘git-’ prefix.
I recommend to place it inside an specific folder and add the folder to the PATH, since you may want to store many files in there.
So, what’s inside the file? Well, it must begin with the address of the interpreter for the scripting language you’ll use. Just a hint: the git installation folder comes with an sh interpreter for free!
#!/bin/sh // That’s the generic route for git’s own sh interpreter
After that, you just can do whatever you want, assign variables, control the execution flow, iterate and the most important thing: set the git commands you need to run every time.
Here’s an example for a script that helps automating the job described above, fetches the upstream remote, finds the newest common commit, resets to that point and merges from there:Shell12345678910111213141516171819#!/bin/shbranch_name=$(git branch | sed -n -e 's/^\* \(.*\)/\1/p')echo "Current branch is $branch_name"echo "Fetching upstream..."git fetch upstreamecho "Getting the common ancestor with the remote..."common_ancestor=$(git merge-base $branch_name upstream/$branch_name)echo "Resetting your branch to the best merging point..."git reset --hard $common_ancestorecho "Merging your remote branch..."git merge upstream/$branch_nameecho "All done!"exit 0
Now, all you need to do is go to your repo and ‘git whatever’.
I will try to explain to you a how DAO is a better approach to connect to MySQL through PHP, making the code readable and secure at the same time. Change our connection from mysql_connect() to new mysqli(): Imagine we have a connection.php file. Typically it looks like this:PHP12$con = mysql_connect('localhost', 'myuser', 'mypass');mysql_select_db('mydatabase_name', $con);
Instead of this we could change it into […]
Test your SQL analysis skill. An order can have multiple lines – For example, if a customer ordered cookies, chocolates, and bread, this would count as 3 lines in one order. The question is to find the number of orders in each line count. The output of this query would be something like 100 orders had 1 line, 70 […]
As Salesforce Administrator/DevOps, you might stumble to common situation where you have to mass-update or mass-delete specific records with complex filtering criteria and deep Salesforce object relationship (parent, child, or grand child). Of course, if you are an expert in Apex programming, you could write long and complex nested SOQL queries to get the record […]
The big news is that Modelit has just launched this website. Welcome! You’re among the first visitors to come to our doorstep and read these pages. We now have a place to call home—our virtual home, that is. You might be curious to see what we’re all about, someone may have told you about our […]