Category Blog Lightningobjectcreator
Not sure where to start?
August 19, 2020
Share the link
Link Copied
The ability to create custom objects is one of the most crucial tools in a Salesforce Administrator’s arsenal. It’s very rare that a company’s needs will be entirely met by the “out-of-the-box” standard objects that Salesforce provides, so it usually falls to an Admin to create the custom objects to track what needs to be tracked.
This may be a familiar task for most Admins, but it can be repetitive and time consuming even for the most experienced. To speed up the object creation process, Salesforce released an intuitive tool called the Lightning Object Creator (LOC).
Released for general availability in late 2019, the LOC lets admins transform a spreadsheet with live data into an object in Salesforce. That means it not only takes care of creating the metadata (the object and fields) but also the data (the individual records)! In this way, the Object Creator kills two birds with one stone. This tool is amazingly useful if the goal is to transition a company’s existing workflows from spreadsheets to Salesforce.
To use the LOC, go to Setup in Lightning Experience. Navigate to the Object Manager and click the “Create” button on the top right. Click “Custom Object from Spreadsheet.” You may be asked to enter your login information again. You’ll then be given the option of uploading a spreadsheet directly or using a simple, easy-to-use integration with Google Sheet or Office 365. That’s right—no need to download your existing Google Sheets as CSVs!
Once you’ve selected your spreadsheet, you’ll be taken to a “Define object and fields” screen.
Salesforce will automatically detect the field names from your spreadsheet and assign data types to them. Here, you can adjust labels and data types as needed, select whether or not to automatically add these fields to the default page layout, and decide whether or not to import the rows from your spreadsheet as new records.
Finally, simply enter the Object properties for your new custom object, such as Label, API Name, and Description. Then click “Finish,” sit back, and let the Lightning Object Creator quickly create the custom object, fields, and records so that you don’t have to!
When it’s complete, you’ll be able to see your new custom object in the Object Manager, and the records you selected for import will already be in the system. Don’t forget to adjust page layouts and Lightning Record Pages afterwards to ensure a clean experience for your end users.
At Shift3 Technologies, we use a consultative approach to help you determine the best strategy to identify your challenges, implement appropriate solutions and enhance your systems.
Looking for other tips and tricks while navigating Salesforce in your org? Check out our posts regarding Developing in VSCode or Overcoming the Challenges of Visualforce Pages. If you need help managing your Salesforce instance on an enterprise level, give us a call at 559 560 3300 or email us at [email protected] today.
This post was written by Joseph Wheelock, a triple-certified Salesforce Admin, nature-lover, musician and cat dad.
Tech Services
Maximizing Your Salesforce ROI Doesn’t Have to be a Headache. It’s not uncommon for someone’s initial takeaway from their first...
The New Normal Times have been hard for businesses to stay relevant in the market and efficient in day-to-day operations....
It’s About the Humans It’s just about time to close the book on 2022, and what a year it has...
A New Year Is Just Around the Corner It’s no secret that Salesforce is a powerful tool–whether it’s tracking business...
Bitwise Industries Highlights the Human Benefits At the heart of Bitwise Industries’ mission is the commitment to building a workforce...
Bitwise Industries Will Show You 5 Ways to Get Started Bitwise Industries is a company known for creating solution-based products...
If Mismanaged, Salesforce Can Feel Spooky For businesses big and small, Salesforce is an amazing CRM–but everything’s got a dark...
Use the Dreamforce, Luke Every year, thousands of administrators, executives, and developers gather in San Francisco to celebrate another year...
Turning Survival Into Success Cheat codes: since the dawn of gaming, programmers have baked in little tricks to help players...
What You Need to Know It’s a bit early to be talking about presents under the tree, hidden eggs in...
A Salesforce to be Reckoned With In this technological age, a company doesn’t successfully run without some type of AI-managed...
Bitwise Industries Receives Significant Honor Leadership. It feels like the definition is simple: the action of leading a group of...