The Lightning Object Creator is finally here!
This is the Admin Tool I have been waiting for the most since I went to Dreamforce in 2018, and it is now GA (Generally Available) for everyone as of August 2019!
What is the Lightning Object Creator?
The Lightning Object Creator is a simple point-and-click tool designed to make an admin’s life easier: take a spreadsheet, and turn it into a brand new object – fields and all – with just a few clicks!
There are so many instances and use cases for this type of tool, that I could probably write pages on it, so how about a very simple example for now? You are the Admin, and the your colleague in Sales Ops would like to create a new object related to Contacts, with several new fields. He already has all of the data and structure set up in an Excel file.
Instead of going the usual way of creating the object, creating the fields, and then loading the data, let’s take a shortcut by using the new Lightning Object Creator tool.
Step 1: Create Object from Spreadsheet
In Lightning, go to Setup → Object Manager → Create
You will see that the Create button now features a drop-down arrow. We want to click on the “Create Object from Spreadsheet” option.
Step 2: Choose The Instance Type
Choose the instance type that you will be creating the object in. Since I am in a developer instance I will be using the Production login.
Step 3: Select Spreadsheet Location
Now we need to select the location of the spreadsheet. As you can see you have 3 options, your desktop, which will accept .csv or .xlsx; you can pull from Google Sheets, or you can pull from OneDrive (Office365). In my example, I am going to pull from my desktop.
Step 4: Define Object Screen
This screen is the meat of it all, so let’s break it down.
- This is allowing you to select whether you want the Field Names to be the names from the Column Headers, or if you want to manually configure the Field Names.
- Use this to tell the Creator which row contains the Column Headers.
- This selection allows you to decide whether to import the data simultaneously, or to wait and handle that later.
- This drop-down allows you to either let Salesforce decide the Record name or you can use one of the Column Headers as the Record name.
- If you have a lot of rows and some of them do not get mapped (see the green checkmark on the far left side of the table), then you can use the Hide mapped fields checkbox to get down to just the rows that are not mapped.
- This allows you to toggle the view you are in. In the screenshot above, I am in the list view – in the screenshot below, you can see what it looks like in the data view.
7. This is the actual table of the mappings of your columns to their respective names and data types – make sure you review this before proceeding.
Step 5: Configure The Object Name
Click on the Next button in the right-hand corner. This will take you to the next screen which allows you to configure the name of the object.
Step 6: Advanced Settings
Check out the Advanced Settings options for things like reporting and activity creation.
Step 7: Finishing Touches
Click Finish. The Lightning Object Creator will then go through the process of creating everything for you.
To check out your newly created object go to Setup → Object Manager and Search for your object.
That’s it, you are done! So fast, and so easy. We Admins are going to save so much time with this app – making objects is going to become a walk in the park. I can’t wait to use it!