◦ Go to Setup > Data Management > Mass Transfer Records and select the object to transfer records.
4) Deactivate Workflow and Approval Process Assignments:
◦ Review any workflows or approval processes that the users are part of. Reassign their
responsibilities to other users to avoid disruptions in business processes.
5) Deactivate Users:
◦ You can deactivate users in bulk using a Data Loader or a similar tool:
▪ Using Data Loader:
▪ Export the list of users you intend to deactivate, including their
Salesforce User IDs.
▪ Update the IsActive field to False for each user in the CSV file.
▪ Perform an update operation in Data Loader to deactivate the users.
▪ Using the Salesforce UI:
▪ If the number of users is small, manually deactivate them by going to
Setup > Users > Users and unchecking the Active checkbox next to each user's name.
6) Verify Deactivation: After the deactivation process, run a report to ensure that all intended users have
been successfully deactivated. Double-check that there are no active users who
should have been deactivated.
7) Communicate the Change: Inform relevant stakeholders, such as managers or team leads, about the
deactivation. Provide them with a list of deactivated users and any necessary next
steps (e.g., reassignment of tasks).
8) Review Licensing: After deactivation, review your Salesforce licenses. Deactivating users frees up
licenses that can be reassigned to new users or help reduce licensing costs.
1) Navigate to Validation Rules: Go to Setup > Object Manager > Project > Validation Rules.
2) Create a New Validation Rule: Write a rule that compares the "Start Date" and "End Date" fields to ensure the "End Date" is not earlier than the "Start Date.”
◦ Formula: End_Date__c < Start_Date__c
3) Set the Error Message: Provide an error message such as "End Date cannot be earlier than Start Date."
4) Test the Validation Rule: Attempt to enter an "End Date" that is earlier than the "Start Date" and ensure the validation rule blocks the save.
1) Consider Using a Duplicate Rule: While a validation rule could check for duplicate entries within the context of a single record save, a Duplicate Rule is generally more effective for this purpose.
◦ Navigate to Setup > Duplicate Management > Duplicate Rules.
2) Create a Duplicate Rule: Set the rule to check for matching email addresses across all "Lead" records.
3) Create a Matching Rule: Define how the system should identify duplicates (e.g., exact matches on the "Email" field).
4) Test the Duplicate Rule: Attempt to create leads with the same email address to ensure the system prevents duplicates.
1) Navigate to Validation Rules: Go to Setup > Object Manager > Opportunity > Validation Rules.
2) Create a New Validation Rule: Write a rule that checks if the "Stage" is "Proposal/Price Quote" and the "Discount" is greater than 20%.
◦ Formula: AND(ISPICKVAL(StageName, "Proposal/Price Quote"), Discount__c > 0.2)
3) Set the Error Message: Provide an error message like "Discount cannot exceed 20% at the Proposal/Price Quote stage."
4) Test the Validation Rule: Try to set a discount greater than 20% at the specified stage to ensure the rule blocks the save.
1) Navigate to Validation Rules: Go to Setup > Object Manager > Contact > Validation Rules.
2) Create a New Validation Rule: Write a rule that checks if the "Birthdate" is greater than today’s date.
◦ Formula: Birthdate > TODAY()
3) Set the Error Message: Provide an error message like "Birthdate cannot be in the future.”
4) Test the Validation Rule: Try setting the birthdate to a future date to ensure the rule prevents the save.
1) Create Validation Rule: AND(ISPICKVAL(Priority, "High"), ISBLANK(Escalation_Reason__c))
2) Error Message: "Escalation Reason is required when the case is marked as High Priority.”
1. Create Validation Rule: AND(Discount__c > 0.3, Amount < 100000)
2. Error Message: "Discount cannot exceed 30% for opportunities less than $100,000.”
AND() - Returns true if all specified conditions are true.
OR() - Returns true if any of the specified conditions are true.
NOT() - Returns the logical opposite of a given condition.
ISBLANK() - Returns true if the specified field is blank.
ISCHANGED() - Returns true if the value of a field has been modified.
ISPICKVAL() - Returns true if a picklist field matches the specified value.
TEXT() - Converts a field value to text.
LEN() - Returns the number of characters in a text field.
REGEX() - Validates whether a text field matches a specified pattern.
CONTAINS() - Returns true if the specified text is found within another text.
INCLUDES() - Returns true if a multi-select picklist field includes the specified value.
PRIORVALUE() - Returns the previous value of a field before the current save.
BLANKVALUE() - Returns a substitute expression if a field is blank, otherwise returns the field
value.
CASE() - Evaluates a series of conditions and returns a corresponding value.
IF() - Returns a value based on whether a condition is true or false.
ABS() - Returns the absolute value of a number.
ISNUMBER() - Returns true if a text value can be converted to a number.
DATEVALUE() - Converts a date/time or text expression to a date.
NOW() - Returns the current date and time.
TODAY() - Returns the current date without time.
Pre-requisites for Salesforce Data Migration
1) Data Mapping:
◦ Field Mapping: Clearly map fields from the source system to the corresponding. fields in Salesforce. Ensure that all necessary fields exist in Salesforce.
◦ Object Mapping: Understand the relationship between objects in both systems (e.g., Accounts, Contacts, Opportunities) and how they correspond.
2) Data Cleanliness:
◦ Data Cleansing: Remove duplicates, correct errors, and standardize data formats in the source system before migration.Admin Scenario Based Interview Questions
◦ Data Validation: Ensure that all required fields have values and that data meets Salesforce’s validation rules.
3) User Permissions:
◦ Profile and Permission Set Configuration: Ensure that the user performing the migration has the necessary permissions to create, update, and delete records in
Salesforce.
◦ API Access: Verify that API access is enabled for the user performing the data migration.
4) Backup and Export:
◦ Backup Source Data: Export and backup all source data before beginning the migration process to avoid data loss.
◦ Salesforce Data Backup: Consider backing up existing Salesforce data if the migration involves updating or merging existing records.
5) Sandbox Testing:
◦ Test in Sandbox: Before migrating data into the production environment, perform the migration in a Salesforce sandbox to test for issues and ensure data integrity.
◦ Dry Run: Conduct a dry run of the migration process using a small subset of data to identify potential issues.
6) Data Loader or Tool Setup:
◦ Data Loader Configuration: Ensure Data Loader (or your preferred migration tool) is installed and configured correctly, including login credentials and settings.
◦ Batch Size Settings: Set appropriate batch sizes in Data Loader to prevent timeouts or API limits from being exceeded.
1. Create Multiple Rule Entries: In the Lead Auto-Response Rule, create separate rule entries based on the "Product Interest" field.
2. Assign Email Templates: Assign specific email templates for each product-related rule entry.
3. Activate the Rule: Test the auto-response by submitting leads with different product interests to ensure the correct email is sent.