â—¦ 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.