Welcome to another “How I Solved It.” In this series, we do a deep dive into a specific business problem and share how one #AwesomeAdmin chose to solve it. Once you learn how they solved their specific problem, you’ll be inspired to try their solution yourself! Watch how Manish Thaduri was able to find newly created fields without having to manually go through each individual field in an object to find its created date. Read more details in the post below.
For a Salesforce Admin, developer, or deployment manager, finding the list of fields created on a specific day is a tedious manual job. The user needs to open each individual field in the Object Manager in Setup and check the CreatedDate value. Good luck if you have to repeat that process for all the fields in the object manually and find the CreatedDate! We need a better, easier way to get that list of fields created on a specific day.
Our client follows a 2-week sprint for their Salesforce development process. Every week, the admins or developers working on the project create and modify a number of fields in the sandbox. At the end of 2 weeks, our delivery lead (aka deployment manager) consolidates all the fields created in the prior 2 weeks and deploys them to production. There’s no easy way for the deployment manager to find all of these fields to add to the outbound change set to prepare for the deployment.
The manual way is to open the field from Object Manager > Fields & Relationships and then check the Created By field value of a field. There, the deployment manager would see the Created Date of the field. They have to repeat this manual process for all the fields in the object to find the Created Date.
I opened the Developer Console from the dropdown on the top gear icon.
Then, I clicked the Query Editor tab and checked the Use Tooling API checkbox at the bottom.
I wrote a simple query to find the fields Created Today.
SELECT DeveloperName, TableEnumOrId FROM CustomField WHERE CreatedDate = TODAY
The query found two fields—Approval_Date and Author. These are the fields created today in our Salesforce org in all the objects. It’s that simple!
The column “TableEnumOrId” shows the object these fields are from.
For my scenario, I varied the WHERE condition and used CreatedDate is this_week or last_week. This would give me all the fields created in the last 2 weeks.
SELECT DeveloperName, TableEnumOrId FROM CustomField
WHERE CreatedDate = LAST_WEEK or CreatedDate = THIS_WEEK
I also tried LAST_QUARTER in the WHERE condition to expand my date range further and find all fields created in the last quarter in my org. There you go!
Now, it’s super easy for my deployment manager and even admins and developers to get the list of fields created or modified during a certain time period without having to manually keep track of them.
This example was real and it’s very simple. But the principle behind it could be applied in all sorts of ways just by varying the WHERE conditions. You can also filter fields based on the specific object name or even the LastModifiedDate of the field.
Let us know what you thought of this solution and tell us how you want to use it with #AwesomeAdmins #HowISolvedThis.
Welcome to a special edition episode of “How I Solved It.” In this series, we do a deep dive into a specific business problem and share how one Awesome Admin chose to solve it. But in this episode, we’ll show you how not one, not two, not three, but FOUR Awesome Admins solved the business […]
Welcome to a special edition episode of “How I Solved It.” In this series, we do a deep dive into a specific business problem and share how one Awesome Admin chose to solve it. But in this episode, we’ll show you how not one, not two, not three, but FOUR Awesome Admins solved the business […]
Welcome to another “How I Solved It.” In this series, we do a deep dive into a specific business problem and share how one Awesome Admin chose to solve it. Once you learn how they solved their specific problem, you’ll be inspired to try their solution yourself! Watch how Deanne Walters uses Flow to create […]
